1 Attachment(s)
Updating a database from dataset
Hi,
Sorry I have to post a attachement but I thought it would be the best way for someone to my problem.
The problem is when I click on my button to update to the data base the dataset updates but the database does not seem to, Could someone please help with this please?
Thanks
Loftty
Re: Updating a database from dataset
I'm not downloading your attachment. All you needed to do was post the code you use to do the update. Do you get an error? If so what was the message. A common mistake is to call AcceptChanges before calling Update. Are you doing that?
Re: Updating a database from dataset
Hi,
I fill the Dataset like so
Code:
oleDbDataAdapter1.Fill(dataSet11);
And I change a value like so
Code:
dataSet11.Contacts[0].Address_1 = "Why is this not working";
oleDbDataAdapter1.Update(dataSet11,"Contacts");
Thanks
Loftty
Re: Updating a database from dataset
In accordance with this policy, the attachment has been edited and all executable or compiled files have been removed.
Re: Updating a database from dataset
The Update method returns the number of rows affected. What value does your call return?