protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete") //判断是哪个按钮
{
string id = e.CommandArgument.ToString().Trim(); //取得当前记录在GridView中的index
GridView1.SelectedIndex = Convert.ToInt32(id);//选中被点击按钮所在的行
OleDbCommand delCom = new OleDbCommand("delete from 信息表 where ID=@ID",conn);
delCom.Parameters.Add("@ID",(int)GridView1.DataKeys[GridView1.SelectedIndex].Value);//取得被选中行在数据库中的键字段的值
conn.Open();
delCom.ExecuteNonQuery();
conn.Close();
ds.Tables["信息表"].Clear();
da1 = new OleDbDataAdapter("select * from 信息表",conn);
da1.Fill(ds, "信息表");
GridView1.DataSource = ds.Tables["信息表"].DefaultView;
GridView1.DataBind();
}
}
{
if (e.CommandName == "Delete") //判断是哪个按钮
{
string id = e.CommandArgument.ToString().Trim(); //取得当前记录在GridView中的index
GridView1.SelectedIndex = Convert.ToInt32(id);//选中被点击按钮所在的行
OleDbCommand delCom = new OleDbCommand("delete from 信息表 where ID=@ID",conn);
delCom.Parameters.Add("@ID",(int)GridView1.DataKeys[GridView1.SelectedIndex].Value);//取得被选中行在数据库中的键字段的值
conn.Open();
delCom.ExecuteNonQuery();
conn.Close();
ds.Tables["信息表"].Clear();
da1 = new OleDbDataAdapter("select * from 信息表",conn);
da1.Fill(ds, "信息表");
GridView1.DataSource = ds.Tables["信息表"].DefaultView;
GridView1.DataBind();
}
}