Answer / pushpendra

Dataset is just like a mini database.it contains a
datatable and data in its and create a relationship in tht
table.It is the feature which enable the disconnected
architecture operation in the Ado.net.The table that we
want to perform DML operation on the database can made as
dataset and we can perform whatever operation (DML) we want
in the dataset and that can be updated in the database.

Answer / manikandan

Dataset is the minature of database in the .net.
It is the feature which enable the disconnected
architecture operation in the Ado.net.The table that we
want to perform DML operation on the database can made as
dataset and we can perform whatever operation (DML) we want
in the dataset and that can be updated in the database.

Answer / 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.

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

0 Answers  

---

How to generate XML from a dataset and vice versa?

2 Answers  

---

describe the dataset object in ado.net.

0 Answers  

---

how to add a selected row of a gridview to another gridview without reloading the page??

2 Answers  

---

Define Execute Scalar?

0 Answers   UGC Corporation,

---

What are good ado.net object to replace to ado recordset object.

0 Answers  

---

What is meant by entity framework?

1 Answers  

---

what is different between SqlCommand object and Command Behaviour Object

3 Answers  

---

How to get oledb connection?

3 Answers  

---

What is dao and ado?

0 Answers  

---

What is the difference between oledb sql server and oledbdotnet provider?

0 Answers  

---

what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?

3 Answers  

---