|
Databases
|
DataProviders
|
DataAdapters
|
DataSets.....................
The DataSet class exists in the System.Data namespace. The Classes contained in
the DataSet class are:..............
The modified data needs to be sent back to the database in order to save it.
Therefore, to send the modified data to a database...............
Dataset.clone() duplicates (only) the structure of a dataset, without
duplicating the data...............
Datareader fetches one row at a time from the datasource. DataSet fetches all
data from the datasource at a time to its memory area..............
Also read
This is complete article on ADO.NET with code and interview questions
DataSet object can contain multiple rowsets from the same data source as well as
from the relationships between them..........
This method executes the SelectCommand to fill the DataSet object with data from
the data source...........
The changes made to the dataset can be tracked using the GetChanges and
HasChanges 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.
In pessimistic locking, when a user opens a data to update it, a lock is
granted....
|