CommandBuilder class

Question

Illustrate the use of CommandBuilder class?

Answer 1

The CommandBuilder class automatically update a database in accordance with the changes which are made in a DataSet.This class automatically registers itself as an event listener to the RowUpdating event. When data inside the row changes, object of the CommandBuilder class spontaneously generates an SQL statement and uses SelectCommand property for commiting the changes which are made in DataSet.

OLEDB provider in .NET Framework has the OleDbCommandBuiider class; on the other hand, the SQL provider has the SqlCommandBuilder class.