Use of a CommandBuilder class

Question

Explain the use of a CommandBuilder class?

Answer 1

The CommandBuilder class is used to involuntarily update the database according to changes made in the DataSet.

This class automatically records itself as an event listener to a RowUpdating event. When data inside the row changes, object of a CommandBuilder class automatically generates the SQL statement and uses SelectCommand property to perform changes made in the DataSet. OLEDB provider in .NET Framework consists of OleDbCommandBuiider class; while, the SQL provider consists of SqlCommandBuilder class.