datalist删除多行记录

最新推荐文章于 2009-07-21 14:45:00 发布

M_arlboro

最新推荐文章于 2009-07-21 14:45:00 发布

阅读量400

点赞数

分类专栏：技术文章标签： delete server cmd

本文链接：https://blog.csdn.net/M_arlboro/article/details/3735397

版权

技术专栏收录该内容

37 篇文章 0 订阅

订阅专栏

for (int i = 0; i < DataList1.Items.Count; i++)
        {
            CheckBox ck = (CheckBox)DataList1.Items[i].FindControl("select");
            if (ck.Checked)
            {
                int id = Convert.ToInt32(DataList1.DataKeys[i].ToString());
                SqlConnection cn = new SqlConnection("server=.;database=pubs;uid=sa;pwd=sa");
                cn.Open();
                SqlCommand cmd = new SqlCommand("delete from students where ID='" + id + "'", cn);
                cmd.ExecuteNonQuery();
                cn.Close();
                Response.Write("<script>alert('OK')</script>");
            }
        }