Question

谁帮我看看这个 删除语句怎么写~用的是三层架构

前台:
<td><a href="Admin_UpdateHangBan.aspx?id=<%#Eval("id") %>">编辑</a></td>
<td><asp:LinkButton ID="LinkButton1" CommandName='<%#Eval("id") %>' OnCommand="Del_Click" runat="server">删除</asp:LinkButton>
</td>
后台:
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Maticsoft.BLL.HangBan bllhangban = new Maticsoft.BLL.HangBan();
Repeater1.DataSource = bllhangban.GetList(15, "1=1", "id desc").Tables[0];
Repeater1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Maticsoft.BLL.HangBan bllhangban = new Maticsoft.BLL.HangBan();
Repeater1.DataSource = bllhangban.GetList(bulidsql()).Tables[0];
Repeater1.DataBind();

}
private string bulidsql()
{
string x = "1=1";
if (TextBox1.Text != "")
{
x += " and StarP like'%" + TextBox1.Text + "%'";
}
if (TextBox2.Text != "")
{
x += " and EndP like '%" + TextBox2.Text + "%'";
}
if (TextBox3.Text != "")
{
x += " and Fdate='" + TextBox3.Text + "'";
}
return x;
}
protected void Del_Click(object sender, CommandEventArgs e)
{

//删除记录

}
}

Answer 1

三层架构你没写好吗？本身就包含删除的方法的啊

Answer 2

试一下 stack