 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / .NET Framework / ADO.NET / May 2005Child Relationships
If I create a child relationship between 2 tables, but the parent table has a value which is not found in the child table, then this will cause an exception....right? So how to I indicate that the parent/child relationship may or may not exists so that no exception is generated when that occurs? Well if the data doesn't satisfy the relation - then you can't create the relation :-). Otherwise the relation would be no use .. right? You can try using a nullable FK though. - Sahil Malik [MVP] http://codebetter.com/blogs/sahil.malik/ > If I create a child relationship between 2 tables, but the parent table has a > value which is not found in the child table, then this will cause an > exception....right? So how to I indicate that the parent/child relationship > may or may not exists so that no exception is generated when that occurs? If you are using an instance of the DataRelation class you can pass a parameter in the constructor telling ado.net not to enforce constraints. Documentation http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlr fsystemdatadatarelationclassctortopic3.asp  SignatureThor Kornbrek .Net Developer > If I create a child relationship between 2 tables, but the parent table has a > value which is not found in the child table, then this will cause an > exception....right? So how to I indicate that the parent/child relationship > may or may not exists so that no exception is generated when that occurs? Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.