dataadapter.update(dataset1.tablename)
با این فرمان کل اطلاعاتت تو دیتابیس ذخیره می شه
public DataSet updateData ( DataSet myDataSet,
string connString, string query ) {
OleDbConnection myConn = new OleDbConnection ( connString );
OleDbDataAdapter adapter = new OleDbDataAdapter ( );
adapter.SelectCommand = new OleDbCommand ( query, myConn );
OleDbCommandBuilder custCB = new OleDbCommandBuilder ( adapter );
DataSet myDataSet = new DataSet ( );
myConn.Open ( );
adapter.Fill ( myDataSet );
// ... code to modify data in dataset here ...
// without the OleDbCommandBuilder this line would fail
adapter.Update ( myDataSet );
myConn.Close ( );
return myDataSet;
}