command builder

Question

Brief describe command builder class work.

Jignesh Trivedi · Answer

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(dsettable1); please refer http://vb.net-informations.com/dataadapter/dataadapter-commandbuilder-sqlserver.htm hope this will help you.

Vulpes · Answer

It automatically generates INSERT UPDATE or DELETE commands to write changes made to a DataSet to the associated database.