This problem is driving me nuts
.
I'm using VS2005, Access 2007, on Win XP SP2
1. Built a single table database in Access nd saved it as a ".mdb".
2. Create a new project in VS2005.
3. Create a new data set (pointing to my database)
4. Drag table to 'Form1'.
5. DataGrid control appears with the column headings from my data set.
6. Press F5.
7. DataGrid populates with the data from my database.
8. Change a cell's contents.
9. Press 'Save' button.
10. I get the following message;
"InvalidOperationException was Unhandled"
"Update requires a valid UpdateCommand when passed DataRow collection with modified rows"
When I do the same steps with the supplied 'Northwinds' database, the Update works.
I think it's something I'm not doing, but I can't figure it out.
HELP!!!
Hugh
I'm using VS2005, Access 2007, on Win XP SP2
1. Built a single table database in Access nd saved it as a ".mdb".
2. Create a new project in VS2005.
3. Create a new data set (pointing to my database)
4. Drag table to 'Form1'.
5. DataGrid control appears with the column headings from my data set.
6. Press F5.
7. DataGrid populates with the data from my database.
8. Change a cell's contents.
9. Press 'Save' button.
10. I get the following message;
"InvalidOperationException was Unhandled"
"Update requires a valid UpdateCommand when passed DataRow collection with modified rows"
When I do the same steps with the supplied 'Northwinds' database, the Update works.
I think it's something I'm not doing, but I can't figure it out.
HELP!!!
Hugh