用的是公共类,用“删除”button实现,并且是同时删除四个表的内容。
private void delete_Click(object sender, System.EventArgs e)
{
if (MessageBox.Show("确定要删除吗?","确认",MessageBoxButtons.OKCancel,MessageBoxIcon.Information)
==DialogResult.Cancel)
return;
int row;
row = dataGrid1.CurrentRowIndex;
string deString1 =" DELETE FROM CardInfo where CID = '" + dataGrid1[row, 0].ToString() + "' ";
string deString2 =" DELETE FROM ClubInfo where CID = '" + dataGrid1[row, 0].ToString() + "' ";
string deString3 =" DELETE FROM StuInfo where StuID = '" + dataGrid1[row, 8].ToString() + "' ";
string deString4 =" DELETE FROM loginInfo where CID = '" + dataGrid1[row, 0].ToString() + "' ";
member ddelete = new member();
ddelete.updateDB(deString1);
ddelete.updateDB(deString3);
ddelete.updateDB(deString2);
ddelete.updateDB(deString4);
showGrid(sqlstring);
MessageBox.Show("删除成功!","信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
怎样修改??谢谢!!