62,046
社区成员
发帖
与我相关
我的任务
分享
string selectedKeys=""; //保存所有选中的记录的主键
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
if (row.RowType == DataControlRowType.DataRow)
{
//检查是否选中,假设CheckBox的ID为Checkbox1,且在GridView1的第一列中
CheckBox cb = (CheckBox)row.Cells[0].FindControl("Checkbox1");
//如果选中,则记录选中记录的主键
if (cb.Checked) selectedKeys = selectedKeys + GridView1.DataKeys[row.RowIndex].Value.ToString() +",";
}
}
if (selectedKeys != "")
{
selectedKeys=selectedKeys.TrimEnd(new char[] { ',' });
//生成sql语句,并执行删除
string sql = "delete from tablename where keycolumn in (" + selectedKeys + ")";
SqlConnection conn = new SqlConnection("连接字符串");
SqlCommand cmd = new SqlCommand(sql);
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
else
{
Response.Write("未选中要删除的记录!");
}