批量删除

  //批量删除
    protected void ibtnDel_Click(object sender, ImageClickEventArgs e)
    {
        string id="";
        for(int i=0;i<dl_news.Items.Count;i++)
        {
            string hyid=((Label)dl_news.Items[i].FindControl("labID")).Text;
            CheckBox cb=(CheckBox)dl_news.Items[i].FindControl("chk");
            if(cb.Checked)
            {
                id+=hyid.Trim()+",";
            }
        }
        if(id==null||id=="")
        {
            ClientScript.RegisterStartupScript(this.GetType(),"","<script>alert('请选择要删除的项目')</script>");
        }
        else
        {
            id = id.Substring(0,id.Length-1);
            string sqlCode = "delete from zqc_Scase where id in ("+id+") ";
            conn.Open();
            cmd = new SqlCommand(sqlCode,conn);
            int count=cmd.ExecuteNonQuery();
            if (count > 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功')</script>");
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(),"","<script>alert('操作失败')</script>");
            }
            conn.Close();
        }
        Bind();
    }