I'm at a loss and don't even know what code to share to have someone help me.
I have 3 tables: client, spouse, addresses. I have datasets for each one. The client record is the primary table and has its primary key in spouse and addresses.
I can create a client and modify as I wish.
After creating the client, I can add a spouse and modify as needed.
After creating the client, I can add an address with no problem. Once I try to modify I get the exception, Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
I am at a loss of where to begin to solve this. For spouse and addresses I have added identical sql queries, where spouse.clientid = client.id and addresses.clientid = client.id (otherwise I would be able to pull the correct data to match the client, which is happening just fine).
Can someone help? I've spent hours on this and have given us.