DataGrid Code to handle RowDeleted fromSQL database


I have a gridview with bound fields populated from a SQL table.

I need the ability to delete a row from the datagrid and from the SQL table

I have added a <asp:CommandField ShowDeleteButton=“True” ButtonType=“Button”/> to the datagrid

But don’t know how to action this in the code (VB.Net)

Could someone give me a clue or an example that Icould follow??

Many thanks in advanced.


&lt;asp:GridView ID="grdReportResults" runat="server" AutoGenerateColumns="False" BackColor="White" CellPadding="0" Font-Names="Verdana" Font-Size="x-Small" Width="700px"&gt;
    &lt;HeaderStyle BackColor="Maroon" Font-Bold="True" ForeColor="White" /&gt;
    &lt;AlternatingRowStyle BackColor="#c0c0c0"/&gt;
        &lt;asp:BoundField DataField="EmployeeID" HeaderText="Employee ID  " /&gt;
        &lt;asp:BoundField DataField="Date Of PDR" HeaderText="PDR Date  " /&gt;
        &lt;asp:BoundField DataField="Six Month Review Date" HeaderText="Six Monthly Review Date  " /&gt;
        &lt;asp:BoundField DataField="Training Type" HeaderText="Type of Training  " /&gt;
        &lt;asp:BoundField DataField="Name Of Course" HeaderText="Course Name  " /&gt;
        &lt;asp:BoundField DataField="Qualification Obtained" HeaderText="Qualification Obtained  " /&gt;
        &lt;asp:BoundField DataField="Start Date" HeaderText="Course Start Date  " /&gt;
        &lt;asp:BoundField DataField="End Date" HeaderText="Course End Date  " /&gt;
        &lt;asp:BoundField DataField="Number Of Days" HeaderText="Number of Days  " /&gt;
        &lt;asp:CommandField ShowDeleteButton="True" ButtonType="Button"/&gt;

Private Sub grdReportResults_RowDeleted(sender As Object, e As GridViewDeletedEventArgs) Handles grdReportResults.RowDeleted

End Sub