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();

    }

posted @ 2008-02-07 13:15  一个IT愤青  阅读(263)  评论(0编辑  收藏  举报