The SqlDataAdapter class’s Update method covers all the items from the preceding list.
The Update method is overloaded. You can pass in a DataTable or an array of DataRows. You can also pass in a DataSet; however, the SqlDataAdapter will submit the pending changes stored in just one DataTable.
The Update method walks through the DataRows submitted, checking each DataRow’s RowState property.
The SqlDataAdapter class exposes properties—InsertCommand, UpdateCommand, and DeleteCommand—to store this updating ...