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

What is ado.net and its features?

0 Answers  

---

Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  

---

Which parameter of ConnectionString is used to specify the name of the database?

0 Answers  

---

Define data adapter?

0 Answers  

---

How to read data with the sqldatareader ?

0 Answers  

---

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?

0 Answers  

---

Can we load multiple tables in a dataset?

0 Answers  

---

If we are not returning any records from the database, which method is to be used?

0 Answers  

---

What is the usage of the dataset object in ado.net?

0 Answers  

---

Difference between ADO and ADO.Net

4 Answers   IBM,

---

Which architecture does Datasets follow?

0 Answers  

---

Explain the different row versions available in table?

0 Answers  

---