dataset改变了,但是数据库却没变化?
private void Form1_Load(object sender, System.EventArgs e)
{
this.sqlDataAdapter1.Fill(this.dataSet11, "FlightDetails");
this.dataGrid1.DataSource = this.dataSet11.Tables["FlightDetails"];
}
//删除记录
private void button1_Click(object sender, System.EventArgs e)
{
int rowIndex = this.dataGrid1.CurrentRowIndex;
this.dataSet11.Tables["FlightDetails"].Rows.RemoveAt(rowIndex);
//this.dataSet11.Tables["FlightDetails"].Rows[rowIndex].Delete();
sqlDataAdapter1.Update(this.dataSet11, "FlightDetails");
}
当我使用removeat()方法时,界面的datagrid有变化,但是提交后数据库没有反应,使用delete()就一切正常,不知道是什么原因?