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(dset,"table1"); 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.

command builder

Answers (2)