Updating a database from dataset

[loftty]

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

[jmcilhinney]

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?

[loftty]

Hi,

I fill the Dataset like so

oleDbDataAdapter1.Fill(dataSet11);

And I change a value like so

dataSet11.Contacts[0].Address_1 = "Why is this not working";
oleDbDataAdapter1.Update(dataSet11,"Contacts");

Thanks

Loftty

[Hack]

In accordance with this policy, the attachment has been edited and all executable or compiled files have been removed.

[jmcilhinney]

The Update method returns the number of rows affected. What value does your call return?