SQL Connectiopn in ADO.NET

Question

Hi What is SQL Connection command?

Manoj Singh Panwar · Answer

hi first you need to include Using System.Data.SqlClient; //then create swl connection : Sqlconnection scon = new Sqlconnection(server = .\sqlexpress ; database = your database name; integrated security = true); // now the sql command is written as : SqlCommand comm = new SqlCommand(insert into tablename values(@p1@p2)scon); // now inserting values of p1p2 //Here I have used two parameters one is varchar and its value is inserted by textbox. com.Parameters.Add(@p1SqlDbType.Varchar50).value = textbox1.text; // similarly you can insert values for other parameters.