Here's my situation: I have a database created with SQL Express. I have a VS solution that has a Windows Forms project. In the project I've added a datasource by clicking "Data->Add new datasource" I selected database as where to get the data from, then I selected my database, then I selected the tables that I wanted included in the DataSet. The dataset gets created all well and good. I add a dataset from the toolbox onto my form and set it's datasource property to my solution dataset. Then I add a binding source and set it's datasource to the list instance of the dataset (the one dragged from the toolbox) and it's datamember to the correct table. Then I bind all the controls on my form to the bindingsource. Then all I should need to do (according to everything I've read) is type:
this
.Validate ();this.epsBindingSource.EndEdit ();
this.epsTableAdapter.Update (this.oxfordDataSet.eps);But this doesn't work, no data is ever added to the database. The Update method return 0 as the number of rows updated. I'm trying to add new data to the database, but it never works. I thought maybe it was something in the project or something I may have done wrong. So I created a completely new project added the datasource exactly how it should be done, and simply dragged the table I'm trying to update from the "Data Sources" window (in "detail" mode) onto the form and let the designer do everything for me. I typed my information into the form pressed the save button (on the bindingnavigator toolbar the designer created), but there was still nothing added to the database.
Any help on what I may be doing wrong would be very very appreciated. I've been dealing with this for a week and can't wrap my brain around why nothing is getting added to the database. I'm new to working with datasets, but I don't think I'm doing anything wrong.
Bindingsource & Tableadapter not updating database.