Can anyone tell me why the update command works with Northwind and Adventureworks databases, but not with a database created by SQL express?

William Costas

I'm using VS 2008. I can't seem to get the update command to work with a database I created with SQL Express but yet it works with the Northwind and Adventureworks sample databases. Can anyone tell me why?
private void myTableBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
try
{
this.Validate();
this.myTableBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.myDataSet);
MessageBox.Show("Update successful");
}
catch (System.Exception)
{
MessageBox.Show("Update failed");
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

William Costas16y ago
Actually is doesn't throw any exceptions. It shows the message update successful, and you can see the added information, but when you close the program and restart it, the data is gone.
0
Sam Hobbs16y ago
Your catch block is not showing anything about the exception; before asking for help in forums, ensure that your program is checking for errors and reporting as much available information about it as possible. It is not possible for someone to tell you waht the problem is here; there is insufficient information.
0