How to use CommandBuilder class in .NET

Hi Alok,

The SQLCommandBuilder generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database.

Following is the simple example:

using (SqlConnection connection = new SqlConnection("connectionString"))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("queryString", connection);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

connection.Open();

DataSet dataSet = new DataSet();
adapter.Fill(dataSet, tableName);

//code to modify data in DataSet here

builder.GetUpdateCommand();

//Without the SqlCommandBuilder this line would fail
adapter.Update(dataSet, tableName);

return dataSet;
}

Please do not forget to mark "Accepted Solution"

Hi,

  You can get more about CommandBuilder class in .NET by reading the following Article written by mahesh sir, 

 http://www.c-sharpcorner.com/UploadFile/mahesh/170/

  

refer article: CommandBuilder in ADO.NET