Hi.
1. Sql Server Express 2005 database
2. 1 table named "customer" with columns "customersID,customersname" (customersID is "int" datatype and is "IDENTITY" and can contain NULLS)
3. I add this table to my DataSet designer.
4. I go into the DataSources window and drag-and-drop the "customers" typed datatable onto my Form1.
5. A Toolstrip, CustomersBindingSource, CustomersTableAdapter, CustomersBindingNavigator, CustomersDataGridView gets added automatically to my "Form1".
6. And the following methods gets also added automatically:
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dataSet1.customers' table. You can move, or remove it, as needed.
this.customersTableAdapter.Fill(this.dataSet1.customers);
}
private void customersBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.customersBindingSource.EndEdit();
this.customersTableAdapter.Update(this.dataSet1.customers);
}
7. I run my project, and all of the customers row in the database gets displayed in the CustomersDataGridView.
8. I add a row in the CustomersDataGridView, both within the CustomersDataGridView by pressing return and also add a row with the "+" button.
9. Everything seems OK, so i press the little Diskette button to save my changes back the database. no errors occured.
10. But!, when i check the database for new rows, none of the rows i added in the CustomersDataGridView where added, it doesnt mather if i add the rows with the "+" or just change a existing row or add them within the CustomerDataGridView, NONE of the changes i do to the CustomerDataGridView is reflected back to the database.
And the funny thing is if i check the "rows affected" with this code:
MessageBox.Show(this.customersTableAdapter.Update(this.dataSet1.customers));
it actually shows "1" if i have added a row to the CustomersDataGridView. But again none of it has been added,updated,deleted to the real database. that is really strange.
BindingSource,DataSet,TableAdapter doesnt reflect changes
Hot Topic
- Where to put user-level settings in a ClickOnce app?
- Outlook 2003 Clone
- modifying control properties
- Updater Component Breakes Shortcuts
- Setting default value for null in datacolumn and datagrid
- Adding an eventhandler to a control created at runtime
- Default Namspace Error
- setting a listbox's DataSource property, and THEN setting DisplayMember causes SelectedIndexChanged event to be fired twice
- Maintaining the selected row after sorting a DataGridView
- Custom Forms Designer Serializer Issue
BindingSource,DataSet,TableAdapter doesnt reflect changes