Way of Insert Data in Database Table with ADO.Net

There are many way Insert data in database table.

I described Five way here.

1. using sql command techniques insert data into database table 

2.Using Bind parameters sql command techniques insert data into database table 

3.using sql command with Parameters techniques insert data into database table 

4.Using ExecuteScalar and SqlCommand Insert data into Database Table 

5.using CommandBuilder insert datat in form datatable in datadase 

5 is Best and Optimize way of insert data into database table because in with 

using conncetionless (SqlDataAdpter) concepts and in insert in datatable form so 

it is best in Performance view and it can use with asp.net where large amount of

users are working.  

using CommandBuilder insert datat in form datatable in datadase

This is the best and optimize way of insert data in to database table 

with ado.net

InsertingDataUsingCommandBuilder

using System;
using System.Data;
using System.Data.SqlClient;

public class InsertingDataUsingCommandBuilder

{

static void Main(string[] args)
 {
string Cn="DataSource=(local);InitialCatalog=CaseManager;Integrated Security=true";
string Query="SELECT ID, Contact, Email FROM Test";
SqlConnection objConnection = new SqlConnection(Cn);
SqlDataAdapter objDataAdapter = new SqlDataAdapter(Query,objConnection);
SqlCommandBuilder objCmd = new SqlCommandBuilder(objDataAdapter);
DataSet objDataSet = new DataSet();
objDataAdapter.Fill(objDataSet);
DataRow objRow = objDataSet.Tables[0].NewRow();
objRow["ID"] = 520;
objRow["Contact"] = "Bill";
objRow["Email"] = "Ray";
objDataSet.Tables[0].Rows.Add(objRow);
objDataAdapter.Update(objDataSet);
        }
    }

Using ExecuteScalar and SqlCommand Insert data into Database Table

using System;

using System.Data;

using System.Data.SqlClient;
   

public class InsertingDataUsingSQLStatementsExecuteScalar

{

static void Main(string[] args)

{

string CN="Data Source=(local); Initial Catalog = DBNAME; Integrated Security=true; 
SqlConnection objConnection = new SqlConnection(CN);
            

String Query ="INSERT INTO tblTest(ID, Contact, Email) VALUES(3, 'Bill', 'John')";

SqlCommand objCmd = new SqlCommand(Query, onConnection);objConnection.Open();
objCmd.ExecuteScalar();
objConnection.Close();

} 

}