Insert Data in Database (mssql)
How TO Insert Data In MSsql DataBase with ASP.NET (C#). So let's Start Now... You must do 5 steps for insert, update, and delete (DML)Operations. Step 1: Add " using System.Data.SqlClient ; ". Step 2: Create Object of SqlConnection... like this.. ( SqlConnection Objname = new SqlConnection(); ) Step 3: Crate Object of SqlCommand.... like this... ( SqlCommand cmd = new SqlCommannd(); ). Step 4: After create Objects of sqlconnection and sqlcommand You Open the Connection. Like this (Objname.Open() ;) Step 5: Execute your Query... Here Example::::...... ------------------------------------------------------------------------------------------- Code Start ------------------------------------------------------------------...