Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 1647264
Datasets are the result of bringing together ADO and XML. A dataset contains one or more data of tabular XML, known as DataTables, these data can be treated separately, or can have relationships defined between them. Indeed these relationships give you ADO data SHAPING without needing to master the SHAPE language, which many people are not comfortable with.
The dataset is a disconnected in-memory cache database. The dataset object model looks like this:
Dataset
DataTableCollection
DataTable
DataView
DataRowCollection
DataRow
DataColumnCollection
DataColumn
ChildRelations
ParentRelations
Constraints
PrimaryKey
DataRelationCollection
Let's take a look at each of these:
DataTableCollection: As we say that a DataSet is an in-memory database. So it has this collection, which holds data from multiple tables in a single DataSet object.
DataTable: In the DataTableCollection, we have DataTable objects, which represents the individual tables of the dataset.
DataView: The way we have views in database, same way we can have DataViews. We can use these DataViews to do Sort, filter data.
DataRowCollection: Similar to DataTableCollection, to represent each row in each Table we have DataRowCollection.
DataRow: To represent each and every row of the DataRowCollection, we have DataRows.
DataColumnCollection: Similar to DataTableCollection, to represent each column in each Table we have DataColumnCollection.
DataColumn: To represent each and every Column of the DataColumnCollection, we have DataColumn.
PrimaryKey: Dataset defines Primary key for the table and the primary key validation will take place without going to the database.
Constraints: We can define various constraints on the Tables, and can use Dataset.Tables(0).enforceConstraints. This will execute all the constraints, whenever we enter data in DataTable.
DataRelationCollection: as we know that we can have more than 1 table in the dataset, we can also define relationship between these tables using this collection and maintain a parent-child relationship.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are disadvantages of microsoft-provided data provider classes in ado.net?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
How do you implement locking concept for dataset?
Define Execute Scalar?
Difference between sqlcommand and sqlcommandbuilder?
How do you connect to sql server database without using sqlclient?
Explain the difference between data reader and data set?
What are all components of ADO.Net data provider?
Is it possible to edit data in Repeater control?
What are the differences between OLEDB and SQLClient Providers?
What is the difference between DataReader and DataSet in ADO.NET?
Explain ODP.net
What is variable view?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Which provider is used to connect ms access, oracle, etc…?
