How can we add/remove row’s in “DataTable” object of “DataSet”?

How can we add/remove row’s in “DataTable” object of “DataSet”?

- ‘NewRow’ method is provided by the ‘Datatable’ to add new row to it.
- ‘DataTable’ has “DataRowCollection” object which has all rows in a “DataTable” object.
- Add method of the DataRowCollection is used to add a new row in DataTable.
- We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished
- Remove method of the DataRowCollection is used to remove a ‘DataRow’ object from ‘DataTable’.
- RemoveAt method of the DataRowCollection is used to remove a ‘DataRow’ object from ‘DataTable’ per the index specified in the DataTable.
How do we use stored procedure in ADO.NET?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
Basic use of “DataView” and explain its methods.
A DataView is a representation of a full table or a small section of rows, it is used to sort and find data within Datatable...
Differences between DataSet and DataReader.
DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them...
Post your comment