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
Which object of ado contains datarow datacolumn collection?
Why is it important to close an ado.net application?
Some important instruction regarding ADO.NET connection string ?
What is the difference between Data adaptor and Data set?
What is the difference between the clone() and copy() methods of the dataset class?
What are the ado.net connection pooling parameters?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What is the use of adodc?
What is the meaning of executenonquery?
Describe the command object and its method.
What is difference between ado and other data object?
What is ado.net connection?
What are the advantages using ado.net?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?