Some DataRelation tasks

[raabbasi]

I am new to ADO.NET. I wish to know how to set a DataRelation object so that;

If a row in the Parent DataTable be deleted, the corresponding rows in any Child DataTable objects are also automatically deleted.

If the value of the primary key field in the parent row is modified, the change cascades down to the child rows automatically.

Is it also possible that a modification in a common field among different DataTables, other than the primary key, may reflect in more than one tables?

Anyone should kindly guide me with some sample code and oblige.

R. A. Abbasi

 

[raabbasi]

Probably, a more appropriate and refined way of my question is that how can I enforce Referential Integrity between 2 or more of my DataTables in VB.NET.

Please help.

 

[ca8msm]

Maybe this will help:

http://msdn.microsoft.com/library/d.../html/vbconIntroductionToDatasetRelations.asp

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.