Save data doesn't work

[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

[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.nwindDataSe t.Customers);
MessageBox.Show("Update successful");
}
catch (System.Exception ex)
{
MessageBox.Show("Update failed");
}
}

"TonyJ" <jo*****************@telia.comskrev i meddelandet
news:%2******************@TK2MSFTNGP02.phx.gbl...

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