.net基础（增删改查）——删除篇

Repeater绑定数据的单条删除：

Aspx文件：

<asp:Repeater ID="rptDes" runat="server">

              <HeaderTemplate>

                 <table width="95%" border="0" cellspacing="0" cellpadding="0" >

                  <tr>   

                    <th  align="left">干燥剂编号</th>

                    <th align="left">干燥剂名称</th>

                    <th align="left">干燥剂吸水率</th>

                    <th width="50%" align="left">干燥剂可使用范围</th>

                    <th align="left">操作</th>     

                        </tr>

                </HeaderTemplate>

                <ItemTemplate>

                 <tr>  <asp:HiddenField ID="hidId" Value='<%#Eval("DesID")%>' runat="server" />                   

                   <td><%#Eval("DesID")%></td>

                   <td><%# Eval("DesName")%></td>

                   <td><%# Eval("Desabsorb")%></td>

                   <td><%# Eval("Desscope")%></td>                                                             <td >

<a href='Desiccant_Edit.aspx?id=<%#Eval("DesID")%>&type=修改' >修改</a>

<asp:LinkButton ID="delete" runat="server" οnclick="delete_Click" OnClientClick="return confirm('你确定要删除吗?’)" >删除</asp:LinkButton>

                   </td>

                 </tr>

                </ItemTemplate>                                            

            </asp:Repeater>

 

 

CS文件：

protected void delete_Click(object sender, EventArgs e)

         {

             LinkButton link = (LinkButton)sender;

             HiddenField hi = ((HiddenField)(link).NamingContainer.FindControl("hidId"));

//把对象转换为HiddenField控件

             int id = int.Parse(hi.Value);//取出HiddenField的Value值

             DesiccantService.DeleteDesiccantByDesID(id);

             show();         

         }

效果如下：

 

Repeater绑定数据的多条删除通过多选框选择：

Aspx文件：

     <asp:Repeater ID="rptFlowMains" runat="server">

                <HeaderTemplate>

                    <table width="100%" border="0" cellspacing="0" cellpadding="0" class="ltable">

                      <tr>

                         <th width="6%">选择</th>

                         <th align="left" width="6%" >事件编号</th>

                         <th align="left" width="10%">事件名称</th>

                         <th align="left" width="10%">事件类型</th>

                         <th align="left" width="10%">事件时间</th>

                         <th align="left" width="10%">事件区域</th>

                         <th align="left" width="10%">事件地址</th>

                         <th width="10%">操作</th>

                         <th width="10%">设置</th>

                       </tr>

                </HeaderTemplate>

                <ItemTemplate>

                    <tr>

                        <td align="center">

        <asp:CheckBox ID="chkId" CssClass="checkall" runat="server" Style="vertical-align: middle;" />

        <asp:HiddenField ID="hidId" Value='<%#Eval("FlowID")%>' runat="server" />

                        </td>

                        <td><%#Eval("FlowID")%></td>

                        <td><%# Eval("FlowName")%></td>

                        <td><%# Eval("FlowType")%></td>

                        <td><%# Eval("FlowTime")%></td>

                        <td><%# Eval("Flowarea")%></td>

                        <td><%# Eval("Flowsite")%></td>

                        <td align="center"><a href="">修改</a>

                        </td>

                         <td align="center"><a href=''>设置</a>

                        </td>

                    </tr>

                </ItemTemplate>          

        </table>                  

            </asp:Repeater>

 

  <asp:LinkButton ID="btnDelete" runat="server" CssClass="del" OnClick="btnDelete_Click" ><i></i><span>删除</span></asp:LinkButton>

 

CS文件：

protected void btnDelete_Click(object sender, EventArgs e)

    {

        int sucCount = 0; //成功数量

        int errorCount = 0; //失败数量 

        for (int i = 0; i < rptFlowMains.Items.Count; i++)

        {

            int id = Convert.ToInt32(((HiddenField)rptFlowMains.Items[i].FindControl("hidId")).Value);

            CheckBox cb = (CheckBox)rptFlowMains.Items[i].FindControl("chkId");

            if (cb.Checked)

            {

                if (FlowMainsService.DeleteFlowMainsByFlowID(id) > 0)

                {

                    sucCount++;

                }

                else

                {

                    errorCount++;

                }

            }

        }  

        Response.Write("<script>alert('成功“+sucCount+”条！');</script>");

 

    }

 

效果图：

 

 

 个人小demo，仅限个人学习

 

转载于:https://www.cnblogs.com/Mingtian-admin/p/9808697.html