Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How can we add/remove row's in "datatable" object of "dataset"?

1062


What is ole data type?

969


What is variable view?

924


What are the connected and disconnected modes in ado.net?

963


What is the use of sqldatareader class?

1052


What does executereader return?

1039


Explain the advantages and disadvantages of using datalist?

1113


What is sqldatasource?

978


How do you find the count of records in a dataset?

1023


Explain ado.net features?

1102


What is isolation?

1075


How does ado.net work?

982


What is method to get XML and schema from Dataset? getXML() and get Schema ()

1021


What are the different methods by which we can populate a dataset?

1283


What is ado.net and its features?

1028