.NET 3.5 DataGridView Wont Save To Database
- by Jimbo
I have created a test Winforms application in Visual Studio 2008 (SP1) to see just how "RAD" C# and .NET 3.5 can be. So far I have mixed emotions.
Added a service-based database to my application
(MyDB.mdf) and added two tables -
Contact (id [identity], name [varchar] and number [varchar] columns) and Group (id [identity] and name [varchar] columns)
Added a DataSource, selected
"Database" as the source, used the
default connection string as the
connection (which points to my
database) and selected "All Tables"
to be included in the data source and saved as MyDBDataSet
Expanded the data source showing my
two tables, selected the "Group" table
and chose to display it as a
DataGridView (from the dropdown
option on the right of each entity)
and dragged it onto Form1, thus creating a groupBindingNavigator, groupBindingSource, groupTableAdapter, tableAdapterManager, myDBDataset and groupDataGridView
Press F5 to test the application,
enter the name "Test" under the
DataGridView's "name" column and
click "Save" on the navigator which
has autogenerated code to save the
data that looks like this:
private void groupBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.groupBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.myDBDataSet);
}
Stop the application and have a look at the database data, you will see no data saved there in the "Group" table. I dont know why and cant find out how to fix it! Googled for about 30 minutes with no luck.
The code is auto-generated with the controls, so you'd think that it would work too :)
