Connectivity Code For Sql server database in asp.net


A) First Create Database and Table Like UserTable and Table field like UserName,UserPwd,UserMobile,UserEmailId etc.


using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

usingSystem.Web.UI.WebControls;

using System.Data;

usingSystem.Data.SqlClient;

public partial class PgConnect : System.Web.UI.Page

{

    protected void Button1_Click(objectsender, EventArgs e)

    {

        SqlConnectioncon = new SqlConnection(@"Data Source=.\Syscomservice;Initial Catalog=MyEveData;Integrated Security=True");

//Note: Data Source mein .\ aye to Data Source ke pahle @ Add karte hai

        con.Open();

string strInsert = "Insert into USerTable(USerName,USerPwd,UserMobile,UserEmailId) values('Nitin','Joshi',9977298129,'nj@gmail.com')";

        Response.Write(strInsert);

        SqlCommandcmd = new SqlCommand(strInsert,con );

        int x = cmd.ExecuteNonQuery();

        con.Close();

        Label1.Text = "Rows Inserted =" + x;

    }

}

Comments

Post a Comment

Popular posts from this blog

Creating a DDL File & link ddl file in C#

 Creating a DDL File & link ddl file  in C# using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ClassLibraryExample {     public class ClassLibrary     {         private string name;         private string last;         private string fullname;         public string Name         {             get { return name; }             set { name = value ; }         }          public string Last         {             get { return last; }    ...
Read more

SQL Command in asp.net

Image
  SqlCommand classis used to prepare an Sql statement or Stored procedure that we want to execute on a sql server database. The Most commonly used methods of the Sqlcommand class 1 -   ExecuteReader - Use when the T-SQL Statement returns more than a single value. For example, if the query returns rows of data. 2-   ExecuteNonQuery- use when you want to perform an insert, Update or delete Operation. 3-   ExecuteScalar- Use When the Query returns a single (scalar) value. For example, Queries that return the total number of rows in a table.   Example: ExecuteReader Methods:     using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; public partial class ExecuteReaderExamples : System.Web.UI. Page { ...
Read more