What is the use of the CommandBuilder class?
The CommandBuilder class is used to automatically update a database according to the changes made in a DataSet.
This class automatically registers itself as an event listener to the RowUpdating event. Whenever data inside a row alters, the object of the CommandBuilder class automatically produces an SQL statement and uses the SelectCommand property to commit the changes made in DataSet.
OLEDB provider in .NET Framework has the OleDbCommandBuiider class; while, the SQL provider has the SqlCommandBuilder class.