Interested to Buy Any Domain ? << Click Here >> for more details...
How you will set the datarelation between two columns?
- 3 Answers
- 9258 Views
- I also Faced
- E-Mail Answers
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
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is ole used for?
What are the various methods provided by the DataSet object to generate XML?
differance between ADO vs ADO.Net?
What are the objects of ado.net?
What are the classes in System.Data.Common Namespace?
What is ole word?
What is basic use of data view?
What are the differences between OLEDB and SQLClient Providers?
Give an example that shows how to execute a stored procedure in ado.net?
What is the return type of executescalar?
Is datareader faster than datatable?
Which object of ado contains datarow datacolumn collection?
What is DataRowCollection?
What are the different ado.net namespaces are available in .net?
