To know this you should understand the difference between SqlCommand and SqlCommandBuilder .
A Command object is used to execute scalar or non query commands to a database. You would set a command objects CommandText property to and sql statement that you want to run and then use it's ExecuteScalar or ExecuteNonQuery method to run it.
A CommandBuilder object is used to automatically create Update, Delete, and Insert SQL statements for you, based on a Select statament that you supply. You would declare a DataAdapter object, set it's SelectCommand.CommandText property to your Select SQL statement. Then when you declare a CommandBuilder object, you include the dataadapter in the CommandBuilder's constructor parameter and it will automatically create the other statements for you when you run a DataAdapter.
In the above link, dataset changes are updated permanently by the code
//save the Row permanently
This is done without writing any update queries, You got it???
Akiii, if this helps please login to Mark As Answer. | Alert Moderator