ciao,
allora io devo cancellare un record con il datagrid. visto che sono un novelino vi riporto il codice:
codice:
DataGrid
<asp:DataGrid id="dgData" runat="server" BackColor="#00C0C0" BorderColor="Black" BorderWidth="2px" ForeColor="Black" ShowFooter="True" AllowSorting="True" AutoGenerateColumns="False" HorizontalAlign="Center" AllowCustomPaging="True" AllowPaging="True" OnDeleteCommand="dgData_Delete" DataKeyField="id">
                <FooterStyle backcolor="Wheat"></FooterStyle>
                <HeaderStyle font-bold="True" backcolor="Aqua"></HeaderStyle>
                <AlternatingItemStyle bordercolor="White" backcolor="Green"></AlternatingItemStyle>
                <Columns>
                    <asp:BoundColumn HeaderText="Nome" DataField="Nome" />
                    <asp:BoundColumn HeaderText="Congome" DataField="Cognome" />
                    <asp:BoundColumn HeaderText="Città" DataField="Città" />
                    <asp:BoundColumn HeaderText="Email" DataField="Email" />
                    <asp:HyperLinkColumn Text="Modificami" DataNavigateUrlField="id" DataNavigateUrlFormatString="update.aspx?ID={0}" Target="_new" />
                    <asp:ButtonColumn HeaderText="" Text="Cancella" CommandName="delete" />
                </Columns>
            </asp:DataGrid>

la parte delle funzioni:
    Dim Conn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _
                                                    "Initial Catalog=Agenda")
    sub Page_Load(obj as object, e as eventargs)
        if not page.ispostback then
            FillDataGrid()
        end if
    end sub

    Sub dgData_Delete(obj As Object, e As DataGridCommandEventArgs)
        dim strSQL as String = "DELETE FROM Clienti WHERE id="&e.item.itemIndex+1

        ExecuteStatement(strSQL)

        FillDataGrid()
    End Sub

    sub FillDataGrid(Optional EditIndex as integer=-1)
        dim objcmd as new SqlCommand("SELECT * FROM Clienti", Conn)

        dim objReader as SqlDataReader

        try
            objcmd.connection.open()
            objreader = objcmd.executereader()
        catch ex as exception
            lblMessage.Text="Errore"
        end try

        dgData.DataSource = objReader
        if not editindex.equals(nothing) then
            dgData.EditItemIndex = EditIndex
        end if

        dgData.DataBind()
        objReader.Close
        objCmd.Connection.Close()
    end sub

    sub ExecuteStatement(sql as string)
        dim objCmd as new SqlCommand(sql,conn)

        try
            objcmd.connection.open()
            objcmd.executenonquery()
        catch ex as exception
            lblMessage.Text="Query"

        end try

        objcmd.connection.close()


    end sub

aiutatemi vi prego