Datalist 删除

来源：互联网发布：网络机房规划编辑：程序博客网时间：2024/06/11 03:47

*aspx

添加删除按钮：

<asp:LinkButton ID="DeleReply" runat="server" CausesValidation="False" CommandName="hfsc" Font-Bold="True" Font-Size="9pt" ForeColor="Black" Width="74px">删除此帖</asp:LinkButton>

在Datalist属性绑定主键；

Datalist里添加一个Label 绑定删除的字段（可以隐藏）；

业务逻辑层：

public bool BBSDeleReply(int XReplyID)
{
SqlParameter[] Params = new SqlParameter[1];

DataBase db = new DataBase();

Params[0] = db.MakeInParam("@ReplyID", SqlDbType.VarChar, 20, XReplyID);

            int Count = -1;
            Count = db.RunProc("Proc_BBSDeleReply", Params);
            if (Count > 0)
                return true;
            else
                return false;
        }

ItemCommand 事件：

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
             int ReplyID = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex].ToString());
            Reply reply = new Reply ();
            if (reply.BBSDeleReply(ReplyID))
            {
                Page.RegisterStartupScript("null", "<script>alert('删除成功！');</script>");
                InitData();
                Dl();

            }
            else
            {
                Page.RegisterStartupScript("null", "<script>alert('删除失败！');</script>");
            }
        }