Simple Method of Using dataadapter. Update ~~~

A simple implementation method is to use the dataadapter object to initialize a sqlcommandbuilder class object before applying the update method. In this way, you can call the update method to update the database even if you do not set attributes such as insertcommand. Example:
Sqlconnection mysqlconnection = new sqlconnection ("connection string ");
Sqldataadapter dataadapter = new sqldataadapter ("querying SQL", mysqlconnection );
Dataset mydataset = new dataset ("test ");

Mysqlconnection. open ();

Int nlen = dataadapter. Fill (mydataset, "test ");

// Add or modify the mydataset

Sqlcommandbuilder mycb = new sqlcommandbuilder (dataadapter); // you can use this sentence ~~~
Dataadapter. Update (mydataset, "test ");