Answer / swapna

ADO.NET provides DataRelation object to set relation
between two columns.It helps to enforce the following
constraints,a unique constraint, which guarantees that a
column in the table contains no duplicates and a foreign-
key constraint,which can be used to maintain referential
integrity.

A unique constraint is implemented either by simply setting
the Unique property of a data column to true, or by adding
an instance of the UniqueConstraint class to the
DataRelation object's ParentKeyConstraint.

As part of the foreign-key constraint, you can specify
referential integrity rules that are applied at three
points,when a parent record is updated,when a parent record
is deleted and when a change is accepted or rejected.

Answer / muthu kumar

DataSet d = new DataSet();
DataColumn parentDC = new
DataColumn(d.Tables["parentTable"].Columns["id"]);
DataColumn childDC = new
DataColumn(d.Tables["ChildTable"].Columns["id"]);
DataRelation ds = new DataRelation("relation name",
parentDC, childDC);
d.Relations.Add(ds);

Answer / ganesh

the only option is foreign key

Can datareader hold data from multiple tables?

0 Answers  

---

We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

6 Answers   Accenture, FastStream,

---

What is a dataset?

3 Answers  

---

What is isolation?

0 Answers  

---

How can we check that some changes have been made to dataset since it was loaded?

0 Answers  

---

How to pass multiple tables in datasets simultaneously?

0 Answers  

---

Explain how to call the sql commands asynchronously in ado.net version 2.0?

0 Answers  

---

Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,

---

What is difference between sqldatareader and sqldataadapter?

0 Answers  

---

once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?

2 Answers  

---

types of Store procedure in Sqlserver2000?

4 Answers  

---

What are the Data providers in ADO.Net?

0 Answers  

---