asp.net关于如何删除repeater里面的记录

删除单条记录：

前台代码：

<asp:LinkButton ID="lnkbtndel" OnClientClick="return confirm('确定删除此新闻')" OnClick="lnkbtndel_Click"

CommandArgument='<%# DataBinder.Eval(Container.DataItem, "ID") %>' runat="server">删除</asp:LinkButton>

后台代码：

protected void lnkbtndel_Click(object sender, EventArgs e)//删除
    {
        string delID = ((LinkButton)sender).CommandArgument;
        if (delID != "" && delID != null)
        {
            string str = "delete NewsAdd where ID=" + int.Parse(delID);
            db.open();
            db.checksql(str);
            db.close();
            getdate();//重新绑定数据源
        }

    }

删除或修改多条记录：

前台代码：

<input type="checkbox" name="nId" id="nId" value='<%# DataBinder.Eval(Container.DataItem, "ID") %>' class="np" />

<select name="Action" id="Action">
              <option value="Pass">审核</option>
              <option value="NoPass">取消审核</option>
              <option value="Commend">推荐</option>
              <option value="NoCommend">取消推荐</option>
              <option value="Del">删除</option>
            </select>

<asp:Button ID="btnSbm" runat="server" Text="执行" OnClick="btnSbm_Click" />

后台代码：

protected void btnSbm_Click(object sender, EventArgs e)//执行
    {
        string action = Request.Form["Action"].ToString();
        string nid = Request.Form["nId"];

        if (nid != "" && nid != null)
        {
            string[] arr = nid.Split(",".ToCharArray());

            switch (action)
            {
                case "Pass":
                    for (int i=0; i < arr.Length; i++)
                    {
                        db.open();
                        db.checksql("update NewsAdd set Checked=1 where ID=" + arr[i]);
                        db.close();
                    }
                    break;
                case "NoPass":
                    for (int i = 0; i < arr.Length; i++)
                    {
                        db.open();
                        db.checksql("update NewsAdd set Checked=0 where ID=" + arr[i]);
                        db.close();
                    }
                    break;
                case "Commend":
                    for (int i = 0; i < arr.Length; i++)
                    {
                        db.open();
                        db.checksql("update NewsAdd set Commend=1 where ID=" + arr[i]);
                        db.close();
                    }
                    break;
                case "NoCommend":
                    for (int i = 0; i < arr.Length; i++)
                    {
                        db.open();
                        db.checksql("update NewsAdd set Commend=0 where ID=" + arr[i]);
                        db.close();
                    }
                    break;
                case "Del":
                    for (int i = 0; i < arr.Length; i++)
                    {
                        db.open();
                        db.checksql("delete NewsAdd where ID=" + arr[i]);
                        db.close();
                    }
                    break;
            }
        }
        getdate();
        
    }