如何通过单击按钮从dalalist中删除行 [英] how to delete a row from dalalist through a button click

问题描述

我想通过删除按钮点击从datalist中删除特定行。

Plz帮助我

感谢advnc

Hi,
I want to delete a particular row from datalist through delete button click.
Plz help me
Thanks in advnc

推荐答案

查看此链接...



删除datalist的行^ ]

Have a look at this link...

Delete row from datalist^]

尝试



http://forums.asp.net/t/1365814.aspx/1 [ ^ ]

http://www.ezineasp.net/ post / ASP-Net-DataList-Delete-Command-using-C-sharp.aspx [ ^ ]

aspx：

aspx:

<asp:DataList ID="DataList1" runat="server" DataKeyField="ID" OnDeleteCommand="DataList1_DeleteCommand">
        <ItemTemplate>
            <asp:LinkButton ID="lnkDelete" runat="server" CommandName="delete">Delete</asp:LinkButton>
        </ItemTemplate>
    </asp:DataList>

代码落后：

code behind:

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
   {
       int ID = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
       SqlCommand mySqlCommand = new SqlCommand("delete from tab2 where ID=@ID", con);
       mySqlCommand.Parameters.Add("@ID", SqlDbType.Int).Value = ID;    
       if (con.State == ConnectionState.Closed)
           con.Open();
       mySqlCommand.ExecuteNonQuery();       
       if (con.State == ConnectionState.Open)
           con.Close();
       DataList1.DataBind();
   }

这篇关于如何通过单击按钮从dalalist中删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！