如何删除DataList指定的记录？

Question

前台页面代码如下：
<asp:DataList ID="DataList2" runat="server">
                  <ItemTemplate>
                                <TABLE class=line20px cellSpacing=0 
                                cellPadding=0 width="100%" border=0>
                                <TBODY>
                                
                                <TR>
                                <TD class=line22px height=22<%# Eval("title").ToString %></TD>
                              <td>
                            <asp:LinkButton ID="LinkButton1" runat="server" OnClick="Linkbutton1_Click">删除</asp:LinkButton></td></TR>
                                
                                </TBODY></TABLE></ItemTemplate>
                  </asp:DataList>
后台代码如下：
 protected void Linkbutton1_Click(object sender, EventArgs e)
    {
        my_conn.Open();
        int id = ?//我想删除＂删除＂按钮对应的记录，这里不知怎么写？        
        string Sql = "delete from bbs_info where id=＂+ id +＂";
        OleDbCommand MyCmd = new OleDbCommand(Sql, my_conn);
        MyCmd.ExecuteNonQuery();
        my_conn.Close();
    }
请高手赐教，谢谢！！

Answer 1

不要这样做
在你的linkbutton里加上
CommandName="delete"
然后在后台CS页面这样写  protected void DataList2_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if ("delete".Equals(e.CommandName))
        {
             //删除操作
        }

Answer 2

把linkbutton 的commname改成 delete 然后写 dataview的 rowdeleing事件

Answer 3

这是你的代码 我改 了一下你试试<asp:DataList ID="DataList2" runat="server">
                  <ItemTemplate>
                                <TABLE class=line20px cellSpacing=0 
                                cellPadding=0 width="100%" border=0>
                                <TBODY>
                                
                                <TR>
                                <TD class=line22px height=22<%# Eval("title").ToString %></TD>
                              <td>
                            <asp:LinkButton ID="LinkButton1" CommandArgument='<%# Eval("ID")%>' runat="server" OnClick="Linkbutton1_Click">删除</asp:LinkButton></td></TR>
                                
                                </TBODY></TABLE></ItemTemplate>
                  </asp:DataList>
这是你的后台：protected void Linkbutton1_Click(object sender, EventArgs e) 
    { 
        my_conn.Open(); 
        int id = ((LinkButton)sender).CommandArgument.ToString()；       
        string Sql = "delete from bbs_info where id=＂+ id +＂"; 
        OleDbCommand MyCmd = new OleDbCommand(Sql, my_conn); 
        MyCmd.ExecuteNonQuery(); 
        my_conn.Close(); 
    } 
你去试试

Answer 4

编译器错误信息: CS0029: 无法将类型“string”隐式转换为“int