How you will set the datarelation between two columns?

Question Posted / swapna

3 Answers
9190 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How you will set the datarelation between two columns?..

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.

Is This Answer Correct ?

3 Yes

0 No

How you will set the datarelation between two columns?..

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);

Is This Answer Correct ?

4 Yes

2 No

How you will set the datarelation between two columns?..

Answer / ganesh

the only option is foreign key

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

What is ado.net objects?

0 Answers

What are the different ado.net namespaces are available in .net?

0 Answers

What is the difference between data reader and data adapter?

0 Answers

What are all components of ADO.Net data provider?

0 Answers

Define ado.net?

0 Answers

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

0 Answers

what is a dataset?

9 Answers Choice Solutions,

What are the different namespaces used in the project to connect the database?

3 Answers

Which is the best institute in navi mumbai to learn DotNet

2 Answers

Features and disadvantages of dataset?

2 Answers CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,

Define executenonquery?

0 Answers

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers

For more ADO.NET Interview Questions Click Here