Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

.HasChanges questions for datasets.

Status
Not open for further replies.

qwert231

Programmer
Sep 4, 2001
756
US
I have a Dataset with 2 tables in it. I have a routine that checks the datasets HasChanges property. If table 2 has changes the routine runs, but part of it runs the dataAdapter.Update for table1. If table1 has no changes I get a Data Concurrency error. What can I do to get around it? Do I have to create a second Dataset to check for changes on a per table basis? Thanks.
 
The update command has an option to specify which table to update just make use of this.

.update(mydataset, "Table1")

Just make sure the table has data in it before you call the update command That'l do donkey, that'l do
[bravo] Mark
If you are unsure of forum etiquette check here faq796-2540
 
Yes, and yes. I am doing that. I ended up putting the tables in separate datasets to resolve the problem for now... but I am running into a different problem now, but I have to troubleshoot that one first to see what exactly is wrong.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top