datalist删除多行记录

Question

得怎么将那个CHECKBOX选中

Answer 1

 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>");
            }
        }将他循环一下选中 在进行进一步的操作

Answer 2

用js选中所有checkbox<script language="JavaScript" type="text/javascript">
function checkAll(){
    var cbx=document.getElementById("test").getElementsByTagName("input");
        for(var i = 0;i < cbx.length;i ++)
        {
             cbx[i].checked =true;
        }
}
</script> 在你全选按钮加个onclick="checkAll()"cs里
protected void btn_alldel_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < dl.Items.Count; i++)
        {
            CheckBox cb = (CheckBox)dl.Items[i].FindControl("cbx");
            if (cb.Checked == true)
            {
                //删除他
            }
        }
    }