GridView删除多列
protected void btn_del_Click(object sender, EventArgs e)
{
//删除被选中的列
string sql = "delete from users where";
string cal = "";
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("itemChk");
if (cb.Checked == true)
{
cal += " user_id=" + GridView1.DataKeys[i].Value.ToString() + " or";
}
}
if (cal != "")
{
sql += cal.Substring(0, cal.Length - 3);
}
else
{
sql = "";//不删除
}
Response.Write(sql);//这里可以自己定义程序,进行删除任务
SqlConnection conn = DB.createconn();
conn.Open();
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteNonQuery();
Response.Write("删除成功 哦也!!");
Bind();
}