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
da.Update(dt);
This is done without writing any update queries, You got it???
Mark this as answer, if it is.....
With regards
Nishithraj Narayanan
Akiii, if this helps please login to Mark As Answer. | Alert Moderator