How you will set the datarelation between two columns?
Answer Posted / 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 |
Post New Answer View All Answers
What are two important objects of ADO.Net?
What is bubbled event?
What is difference between datareader and dataadapter?
Define table relations?
What is ado rdo dao in visual basic?
What is difference between ado and other data object?
What is ado or jdbc?
What are the major difference between classic ADO and ADO.NET?
Define the executescalar method?
What is the executescalar method?
What is the use of connection object in ado.net?
What is adodb dll?
What is fill method in ado.net?
What is executequery?
how Sequence to connect and retrieve data from database using dataset?