hello everyone
My framework:
- Microsofr window7
- Visual studio 2008
I used AdventureWorks database sample for my application.
I created window form application include:
- 1 datagridview: name = datagridview1
- 1 button: name=button1
I used visual studio 2008's tool to add Datasource (Data>Add new data source...)
I only selected AWBuildVersion table (which within AdventureWorks database)
Now I had:
- AdventureWorks_DataDataSet
My purpose is press 'button1' will create new AWBuildVersionRow, it was display to datagridview1 and then save it to AdventureWorks database permanently
My code:
byte i = 1;
private void button1_Click(object sender, EventArgs e)
{
AdventureWorks_DataDataSetTableAdapters.AWBuildVersionTableAdapter da = new WindowsFormsApplication2.AdventureWorks_DataDataSetTableAdapters.AWBuildVersionTableAdapte();
AdventureWorks_DataDataSet.AWBuildVersionDataTable table = da.GetData();
AdventureWorks_DataDataSet.AWBuildVersionRow row = table.NewAWBuildVersionRow();
row.BeginEdit();
row.Database_Version = "version";
row.SystemInformationID = ++i;
row.VersionDate = DateTime.Now;
row.ModifiedDate = DateTime.Now;
row.EndEdit();
table.AddAWBuildVersionRow(row);
da.Update(table);
this.aWBuildVersionTableAdapter.Fill(this.adventureWorks_DataDataSet.AWBuildVersion);
}
I ran DEBUG. The result is:
when I press 'button1'. New row was displayed on datagridview1. Then stop DEBUG
A moment later, I run DEBUG. Above created new row still was displayed.
But if I stop DEBUG. And a long time later I run DEBUG, Above created new row was not displayed.
I can't understand why is that.
please help me! thank you very much