As you saw in the Data Table, Data Row, and Data Column sections at the beginning of this article, you can use the Delete method of a Data Row to delete a row.
The Add New method of the Data Table adds a row to a Data Table.
To change an existing row's data, you can directly assign a row's value.
To save data to the data source, you need to call the Data Adapter's Update method.
For more information see Generating Commands with Command Builders. After a row updates successfully, the changes to that row are accepted.
As you can see from listing 5-48, I created a filled Data Set and created a new Data Row using the Data Table. After creating a Data Row, I set its column values and called the Data Adapter's Update method and displayed data in the Data Grid.