T
tk547
I have a parent child relationship that I have having a hard time
either inserting and updating or deleting. I have a parent DataTable
(Contact) and a child DataTable (ContactPhone). I am using a
DataRelation between them. I am also using the MS Data Access
Application Blocks. I have read numerous forums on how to delete a
child record with changing the AcceptRejectRule to cascade. From what
I can understand this is done at the DataAdapter level. I also
understand that inserts and updates need to happen in a different
order than deletes with a relation.
What I am wondering is if and how I can implement a relation like this
using the MS DAAB. Has anyone been able to do this and if so how? I
thought about extending the SqlHelper.cs, but don't know if there is
success in doing that. Thought I would try it out here before
pounding my head even more with this issue.
Any help would be greatly appreciated and thank you in advance.
Thanks.
either inserting and updating or deleting. I have a parent DataTable
(Contact) and a child DataTable (ContactPhone). I am using a
DataRelation between them. I am also using the MS Data Access
Application Blocks. I have read numerous forums on how to delete a
child record with changing the AcceptRejectRule to cascade. From what
I can understand this is done at the DataAdapter level. I also
understand that inserts and updates need to happen in a different
order than deletes with a relation.
What I am wondering is if and how I can implement a relation like this
using the MS DAAB. Has anyone been able to do this and if so how? I
thought about extending the SqlHelper.cs, but don't know if there is
success in doing that. Thought I would try it out here before
pounding my head even more with this issue.
Any help would be greatly appreciated and thank you in advance.
Thanks.