All You Need to Know about ADO.NET: Part 2/2: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
All You Need to Know about ADO.NET: Part 2/2

page 16 of 27

by Devarticles.com
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 90440/ 122

Article Contents:

DataRelation Objects and Constraings

A DataRelation object is also used to create and enforce the following constraints:

A unique constraint, which guarantees that a column in the table contains no duplicates.

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

when a change is accepted or rejected

« (Page 15)

View Entire Article

(Page 17) »

User Comments

Title: disconnected architecture
Name: kinjalpadashala
Date: 2012-02-14 3:19:39 AM
Comment:
p/z help me how to select the data in grid and bind of textbox.

Title: thank you
Name: kartik
Date: 2011-03-24 1:04:35 AM
Comment:
is it posibile to insert the record enter at the 1st row of database every time?

Title: Ado.net Connected Architecture
Name: Vidhya Patel, India(mota)
Date: 2011-03-08 11:27:53 PM
Comment:
I use this content in my Presentation....it's very useful for me....... so thanks a lot

Title: ado.net
Name: Manimegalai
Date: 2010-09-15 3:31:43 AM
Comment:
That is great collection
thank u;;;;;;;;;;;;;;

Title: Thanks
Name: Amin Anwar
Date: 2009-05-14 5:19:09 AM
Comment:
That isgr8 collection;;;
thanks

Title: Ado.net
Name: Saurabh Shrivastava
Date: 2007-02-20 11:46:46 AM
Comment:
Brilliant Work,It could be more useful by giving some code in it.

Title: Thank you
Name: Jayalakshmi baskaran
Date: 2006-05-30 5:39:23 AM
Comment:
I want to create the sqldataAdapter and the Dataset in Code
Can you please help it out

Title: Ado.Net
Name: Rohan Ragoo
Date: 2006-01-09 12:37:59 PM
Comment:
Excellent Overview. All topics are dicussed in an effective timeline.

Title: XML
Name: Rajesh Medackel,India
Date: 2005-10-01 5:26:30 AM
Comment:
Good write up .... Thanx

Title: ADO.Net
Name: k
Date: 2005-05-03 11:31:30 AM
Comment:
to the authors thanks a lot for the unselfish information

Product Spotlight