467,910 Members | 1,644 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,910 developers. It's quick & easy.

Save data doesn't work

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
Oct 22 '07 #1
  • viewed: 2203
Share:
1 Reply
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


Oct 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Mark Johnson | last post: by
10 posts views Thread by Henok Girma | last post: by
1 post views Thread by liuliuliu | last post: by
6 posts views Thread by Josetta | last post: by
6 posts views Thread by Joe Kovac | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.