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
Define the data provider classes that is supported by ado.net?
Which is faster datareader or dataadapter?
What is commandbuilder in ado.net?
What is the difference between Optimistic and Pessimistic locking?
Explain which name space is used to get assembly details?
How can I retrieve two tables of data at a time by using data reader?
How do I delete a row from a DataTable?
Explain the various objects in dataset.
What are the steps you will take to improve performance?
What is ado code?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What is the use of SqlCommandBuilder?
List all the steps in order, to access a database through ado.net?
Which method is used to sort the data in ADO.Net?
What is ado.net objects?