Dataset is the main part in all your operations.
1. Fetch the values in dataset from database.
2. Bind it with gridview. Put gridview editable (so user edit values whatever
they want)
3. after editing put gridview table to dataaset.
4. finally update dataset to database.
Gridview changes to dataset.
DataTable dt = (DataTable)GridView1.DataSource;
Dataset ds = new dataSet;
ds.tables[0] = dt
and then
Save Dataset Changes to a Database[
^]