C # Adapter Batch Modification

DataTable DT;                                  Declaring data tables outside the method
SqlDataAdapter adapter;             Declaring the data adapter outside the method

Query method
adapter = new SqlDataAdapter (SQL statement, SqlConnection);

Adapter. Fill (DT);                                                          Populate the data table with the results
Datagridview1.datasource = DT;                               Bind a data table to a DataGridView

The overall update method of the data table
SqlCommandBuilder build = new SqlCommandBuilder (adapter);      Package adapter automatically generate update-related commands
Adapter.Update (DT);                                                            Update methods for Adapter
MessageBox.Show ("Modified successfully!"); C # Adapter Batch Modification

C # Adapter Batch Modification