怎样可以点击button可以删除DataList内的一个数据

Question

怎样可以点击button可以删除DataList内的一个数据

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ShoppingConnectionString %>" 
        SelectCommand="SELECT * FROM [CApple]" 
        DeleteCommand="DELETE FROM CApple WHERE [id] = @id">
        
        <DeleteParameters>
            <asp:QueryStringParameter Name="id" Type="String"/>
        </DeleteParameters>
    </asp:SqlDataSource>

    <asp:DataList ID="dlProduct" runat="server" DataSourceID="SqlDataSource1" 
        CellPadding="16" HorizontalAlign="Center" RepeatColumns="3" Width="620px" 
        DataKeyField="id">
        <ItemTemplate>
            <div class="divLeft">
            <img id="imgProduct" alt="" src='<%# Eval("img") %>' style="border-width:0px; width:250px;height:250px" runat="server" />
            </div>
            <div  class="divLeft">
                <div class="productName">
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("name") %>' Font-Size="15"></asp:Label>
                </div>
                <div class="productDescription">
                    <%# Eval("descn") %>
                </div>
                <div class="itemText">
                    价格：<%# Eval("price") %></div>
                <asp:Label ID="Label2" runat="server" Text='<%# Eval("id") %>' ForeColor="White"></asp:Label>
                
                <div class="itemText">
                    <asp:Button ID="Button1" runat="server" Text="取消收藏" 
                        onclick="Button1_Click" CommandArgument="'<%#Eval("id") %>'" CommandName="delete" />
                               
                    <asp:Button ID="Button2" runat="server" Text="加入购物车" />
                </div>
            </div> 
        </ItemTemplate>
    </asp:DataList>
        </form>

Answer 1

你可以参考这个完整的简单示例：

https://www.c-sharpcorner.com/uploadfile/anjudidi/add-delete-and-update-command-in-datalist/

简单来说就是通过 CommandName = “Delete” 来指定按钮为 DataList 控件的删除记录事件的触发器。
其中关键代码,请根据自己的数据库及其他细节进行相应修改：

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        con = new SqlConnection("<your connection string>");
        cmd.Connection = con;
        int RecordID = (int)DataList1.DataKeys[(int)e.Item.ItemIndex];
        cmd.CommandText = "Delete from yourTable where RecordID =" + RecordID ;
        cmd.Connection.Open();
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();
        DataList1.EditItemIndex = -1;
        updateYourDataList();
    }

<asp:LinkButton ID="lnkDelete" runat="server" CommandName="delete"> Delete </asp:LinkButton>