command builder

hi,
It automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database.

This class automatically registers itself as an event listener to the RowUpdating event. Whenever data inside a row changes, the object of the CommandBuilder class automatically generates a SQL statement and uses the SelectCommand property to commit the changes made in DataSet. 

DataSet dset = new DataSet();
SqlConnection con = new SqlConnection("myConnectionString");
//Autogenerate Insert, Update & Delete commands
SqlDataAdapter adp = new SqlDataAdapter("Select from table1", con);
SqlCommandBuilder scb = new SqlCommand(adp);

//Fill the dataset
da.Fill(dset,"table1");

please refer

http://vb.net-informations.com/dataadapter/dataadapter-commandbuilder-sqlserver.htm

hope this will help you.