Inserting a record
A blank record is inserted by using the NewRow method. The new row inherits all of the columns from the concerned table's DataColumnCollection collection:
|Dim anyRow as DataRow = ExistingTable.NewRow |
The code shown above is an example of adding a row. A row can be added using the add method of the DataRowCollection. After the new blank record is added, it is treated like an existing record and updated in the same way.
Deleting a record
A record is deleted using the Delete method of the DataRow object:
Merging two Datasets
You can merge two Datasets by using Merge method of the DataSet object.