求助：datagrid　删除按钮　　删除指定的一行

#2

wangfuli2008-04-11 01:23

ds.table("").rows.removeat(datagrid1.currentrowindex)

#3

a2542984922008-04-11 01:27

能不能具体点｀｀｀本人初学者

#4

论坛元老2008-04-11 15:54

一行里面肯定有主键了
找到主键然后写Sql语句删除就可以了啊

#5

laohuang2008-05-01 22:53

回复 1# 的帖子

下面是我的一个实例.你可以参考一下:

HTML代码:
<asp:datagrid id="DataGrid1" style="Z-INDEX: 107; LEFT: 136px; POSITION: absolute; TOP: 272px"
                runat="server" Width="720px" Height="276px" AutoGenerateColumns="False" PageSize="6" AllowPaging="True"
                DataKeyField="ID">

DataKeyField="ID",这个是删除功能中最重要.

代码:
Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
         = "delete from users where id=" & DataGrid1.DataKeys(CInt(e.Item.ItemIndex)) & ""
        mycmd.Connection = mycon
        Try
            mycon.Open()
            mycmd.ExecuteNonQuery()
            mycon.Close()
        Catch ex As Exception
        End Try
        DataGrid1.EditItemIndex = -1
        bind()
    End Sub

求助：datagrid 删除按钮 删除指定的一行