使用复选框删除gridview中的多行 [英] delete multiple rows in gridview using checkboxes

问题描述

我已经使用以下代码执行我的查询，以使用复选框删除gridview中的多个值，但是当我执行以下代码时，它说checkbox1.checked为false，但我检查了它.它不会删除我选择的值

i have used following code to execute my query of deleting multiple values in gridview using checkboxes but when i execute the following it says checkbox1.checked is false but i check that . It doesnot delte my selected values

这是我的代码和脚本部分

here is my code and script part

 protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        grd_bnd();
    }
}
 private void grd_bnd()
{
 SqlConnection con = new        SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
    SqlCommand cmd = new SqlCommand("select * from student", con);
    con.Open();
    SqlDataAdapter adp = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    adp.Fill(ds);
    GridView1.DataSource = ds;
    GridView1.DataBind();
    con.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
    foreach (GridViewRow row in GridView1.Rows)
    {
        CheckBox checkbox1 = (CheckBox)row.FindControl("checkboxdelete");
        if (checkbox1.Checked)
        {
            int rollno = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value.ToString());
            //CheckBox checkbox1 = (CheckBox)row.FindControl("checkbox1");
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
            SqlCommand cmd = new SqlCommand("delete from student where rollno = @rollno ", con);
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.Add("@rollno", SqlDbType.Int).Value = rollno.ToString();
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            cmd.Dispose();
        }
    }
    grd_bnd();
}
}

这是脚本

      <asp:GridView ID="GridView1" runat="server" DataKeyNames="rollno" AllowSorting="true" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4" >
        <Columns>
            <asp:TemplateField HeaderText="Select">
                <ItemTemplate>
                    <asp:CheckBox ID="checkboxdelete" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Name">
                <ItemTemplate>
                    <asp:Label ID="lblname" runat ="server" Text='<%#Eval("name") %>' /> 
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Roll No.">
                <ItemTemplate>
                    <asp:Label ID="lblrollno" runat ="server" Text='<%#Eval("rollno") %>' /> 
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Batch">
                <ItemTemplate>
                    <asp:Label ID="lblbatch" runat ="server" Text='<%#Eval("batch") %>' /> 
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Course">
                <ItemTemplate>
                    <asp:Label ID="lblcourse" runat ="server" Text='<%#Eval("course") %>' /> 
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        </gridview>
        <asp:Button ID="Button3" runat="server" Font-Bold="True" Text="Delete Selected" ForeColor="#000066" OnClick="Button3_Click" />
    <asp:Label ID="Label1" runat="server" ForeColor="#666666"></asp:Label>

推荐答案

尝试这种方式

       for (int i = 0; i < GridView1.Rows.Count; i++)
       {
        CheckBox checkboxdelete = ((CheckBox)GridView1.Rows[i].FindControl("checkboxdelete"));

        if (checkboxdelete.Checked == true)
        {
            Label lblrollno = ((Label)GridView1.Rows[i].FindControl("lblrollno"));

            int rolNo = Convert.ToInt32(lblrollno.Text);
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
            SqlCommand cmd = new SqlCommand("delete from student where rollno = @rollno ", con);
            cmd.CommandType = CommandType.Text;

            SqlParameter param = new SqlParameter("@rollno", SqlDbType.Int);
            param.Value = rolNo;
            cmd.Parameters.Add(param);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            cmd.Dispose();
        }
      } 

这篇关于使用复选框删除gridview中的多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！