Difference between command object and command builder object?
Command object can be used prepare the command and submit the sql command to database engine and result set is given to the database engine and then send back to the application.
Command builder can prepare the sql statements according to the operations done on the tables in the DataSet
and commands are assigned to the DataAdapter
.