How to delete multiple checked records (in gridview) with one button in asp?

error007

Please heroes give the code in cs, thank you

86548062

Delete one by one? ? ?
Waiting for a master answer ...

zzclark

It is definitely better to delete one by one with the in clause ... but I will not -_-

chinactboy

string del = "";
Throw all checked data into del. then
delete from table Where id in ("+ del +")

sulfuresser

LZ, show you my cs code:
// Delete the selected button event
    protected void deleteSelectedBtn_Click (object sender, EventArgs e)
    {
        int intFlag = 0;
        for (int i = 0; i <this.ShowMailGridView.Rows.Count; i ++)
        {
            GridViewRow row = this.ShowMailGridView.Rows [i];
            HtmlInputCheckBox selectedChkbox = (HtmlInputCheckBox) row.FindControl ("selectedchkbox") as System.Web.UI.HtmlControls.HtmlInputCheckBox;
            if (selectedChkbox! = null&&selectedChkbox.Checked)
            {
                int InfoId = Convert.ToInt32 (selectedChkbox.Value);
                intFlag = Mail.DeleteMail (InfoId);
            }
        }
        if (intFlag> 0)
        {
            thisShowMailGridViewDataBind ();
        }

    }
    // Delete all button events
    protected void deleteAllBtn_Click (object sender, EventArgs e)
    {
        int intFlag = 0;
        for (int i = 0; i <this.ShowMailGridView.Rows.Count; i ++)
        {
            GridViewRow row = this.ShowMailGridView.Rows [i];
            HtmlInputCheckBox selectedChkbox = (HtmlInputCheckBox) row.FindControl ("selectedchkbox") as System.Web.UI.HtmlControls.HtmlInputCheckBox;
            if (selectedChkbox! = null)
            {
                int InfoId = Convert.ToInt32 (selectedChkbox.Value);
                intFlag = Mail.DeleteMail (InfoId);
            }
        }
        if (intFlag> 0)
        {
            thisShowMailGridViewDataBind ();
        }
       

    }

sulfuresser

ItemTemplate code in HTML, gridview
<ItemTemplate>
                          <table border = "0" cellpadding = "0" cellspacing = "0" width = "100%">
                             <tr align = "left" style = "font-weight: normal; font-size: 9pt" valign = "middle">
                                 <td width = "4%" align = "center">
                                    <input type = "checkbox" id = "selectedchkbox" value = '<% # DataBinder.Eval (Container.DataItem, "InfoID")%>' runat = "server" /> </ td>
                                 <td width = "4%" align = "center> </ td>
                                 <td align = "left" valign = "middle" width = "35%">
                                    <a href="LookMail.aspx?MailId=<%#DataBinder.Eval(Container.DataItem,"MailID")%> "target =" _ self "> <font color =" # 9933ff "> <% DataBinder.Eval ( Container.DataItem, "Subject")%> </ font> </a>
                                 </ td>
                                 <td align = "center" valign = "middle" width = "15%">
                                    <% # DataBinder.Eval (Container.DataItem, "UserID")%>
                                 </ td>
                                  <td align = "center" valign = "middle" width = "15%">
                                    <% = ReceiversNamelbstring%>
                                 </ td>
                                  <td align = "center" valign = "middle" width = "15%">
                                    <% # DataBinder.Eval (Container.DataItem, "SendDate", "{0: yyyy-MM-dd HH: mm}")%>
                                 </ td>
                              
                                  <td align = "center" valign = "middle" width = "12%">
                                        
                                  </ td>
                             </ tr>
                            </ table>
                        </ ItemTemplate>

error007

Thank you all.