datagridview删除行的问题
private void tbtndel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确实要删除这条记录吗?", "询问", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int rownum = this.datav.CurrentRow.Index;
try
{
this.ds.Tables[0].Rows[rownum].Delete();
this.link.UpdateDataBase(this.ds.GetChanges(), mytable);
MessageBox.Show("数据删除成功", "提示");
}
catch
{
MessageBox.Show("该数据不能删除!", "提示");
string strsql = "select * from 津贴扣款表";
this.link.SelectDataBase(strsql, mytable);
return;
}
}
}
public DataSet UpdateDataBase(DataSet changedDataSet, string tableName)
{
this.myConnection = new OleDbConnection(connectionString);
this.da = new OleDbDataAdapter(this.strSQL, this.myConnection);
this.oleCmdBld = new OleDbCommandBuilder(da);
this.da.Update(changedDataSet, tableName);
return changedDataSet;//返回更新了的数据库表
}//
调用这个函数来操作,但第一次删除正常,第二次就会有异常,关闭窗口,再打开,问题依旧.