Save data doesn't work

T

TonyJ

Hello!

I'm using VS2005.
I'm looking at ADO.NET and have found some test tutorial solution on
microsoft MSDN.
The one that I'm looking at now is called Walkthrough: Saving Data to a
Database (Single Table)

I have followed the walkthrought exectly but it doesn't work as expected.

I have a Data Source with one database table.
The table is from the northwind database and is called customer.
This table is set to be in Detail mode meaning I get individuals control for
the whole table when I drag the table into the windows form.

In this form there is a diskett meaning that I can save data back to the
database.

So I do the following change some data in one of the control and then click
the diskett symbol meaning I save the data back to the database.
If I now go to the next record and then go back to the previous record the
change is there.
So I manage to change in the dataset but if I then close the application and
look in the database my changes has not changed anything in the database.

I can't understand why this doesn't work.


//Tony
 
T

TonyJ

Hello!!

Below is the event handler that is called when I click the diskett save
icon.
The text that is printed is Update successful so I don't get any errors but
as I mentioned no update is done to the
database.
private void customersBindingNavigatorSaveItem_Click(object sender,
EventArgs e)
{
try
{
this.Validate();
this.customersBindingSource.EndEdit();
this.customersTableAdapter.Update(this.nwindDataSet.Customers);
MessageBox.Show("Update successful");
}
catch (System.Exception ex)
{
MessageBox.Show("Update failed");
}
}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top