How to run an sql statement when a user clicks on a button

The quires I use manually:
INSERT INTO  tblArchive(OrderID, UnitSerialNumber, Class, Type, Status, Title, Inactive)
 
Select       OrderID AS OrderID, UnitSerialNumber AS UnitSerialNumber, Class AS Class, Type As Type, Status As Status, Title AS Title, Inactive AS Inactive
 
FROM         tblActive
WHERE        Inactive = 1; 
 
DELETE FROM tblActive
      WHERE Inactive = 1
 
aspx Page Code
---------------
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
 
        DataKeyNames="OrderID" DataSourceID="AllJobs">
 
        <Columns>
 
            <asp:HyperLinkField DataNavigateUrlFields="OrderID" DataNavigateUrlFormatString="frmTMAPListings.aspx?OrderID={0}"
 
                Text="Order" />
 
            <asp:TemplateField HeaderText="Order">
 
                <ItemTemplate>
 
                    <asp:CheckBox ID="ProcessJob" runat="server" />
 
                </ItemTemplate>
 
            </asp:TemplateField>
 
            <asp:BoundField DataField="OrderID" HeaderText="Order ID" ReadOnly="True" SortExpression="OrderID" />
 
            <asp:BoundField DataField="UnitSerialNumber" HeaderText="UnitSerialNumber" SortExpression="UnitSerialNumber" />
           
            <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
 
            <asp:BoundField DataField="Type" HeaderText="Type" SortExpression="Type" />
 
            <asp:BoundField DataField="Status" HeaderText="status" SortExpression="Status" />
 
            <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
 
            <asp:TemplateField HeaderText="Inactive">
 
 
                <ItemTemplate>
 
                    <asp:CheckBox ID="cbxInactive1" runat="server" Checked='<%# Bind("Inactive") %>' />
 
                </ItemTemplate>
 
            </asp:TemplateField>
 
       </Columns>
 
    </asp:GridView>
 
    <asp:SqlDataSource ID="AllJobs" runat="server" ConnectionString="<%$ ConnectionStrings:JobConnectionString %>"
 
        SelectCommand="SELECT OrderID, UnitSerialNumber, Class, Type, Status, Title, Inactive FROM tblActive WHERE (Class = @Class) ORDER BY Class, Type" ProviderName="<%$ ConnectionStrings:JobsConnectionString.ProviderName %>">
 
        <SelectParameters>
 
            <asp:ControlParameter ControlID="DropDownList1" Name="Class" PropertyName="SelectedValue" />
 
        </SelectParameters>
 
    </asp:SqlDataSource>
<asp:LinkButton ID="btnRmvActiveRecords" runat="server" Visible="False">LinkButton</asp:LinkButton><br />
 
Code Behind Page
----------------
 
Protected Sub btnRmvActiveRecords_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRmvActiveRecords.Click
 
        Dim atLeastOneRowSeleted As Boolean = False
 
        Dim ids As New StringCollection
 
 
 
        ' Iterate through the Rows 
 
        For Each row As GridViewRow In GridView1.Rows
 
            ' Access the CheckBox
 
            Dim cb As CheckBox = row.FindControl("cbxInactive")
 
            If cb IsNot Nothing AndAlso cb.Checked Then
 
                atLeastOneRowSeleted = True
 
 
 
                ' First, get the OrderID for the selected row
 
                Dim OrderID As Integer = _
 
                    Convert.ToInt32(GridView1.DataKeys(row.RowIndex).Value)
 
                ids.Add(OrderID.ToString)
 
            End If
 
        Next
 
 
 
        'Execute SQL 
 
 
        Dim cmd As New SqlClient.SqlCommand()
 
 
 
        cmd.Connection = New SqlConnection(Me.AllJobs.ConnectionString)
 
        cmd.CommandText = "INSERT INTO  tblArchive(OrderID, UnitSerialNumber, Class, Type, Status, Title, Inactive) Select OrderID AS OrderID, UnitSerialNumber AS UnitSerialNumber, Class AS Class, Type As Type, Status As Status, Title AS Title, Inactive AS Inactive FROM tblActive WHERE Inactive = 1; DELETE FROM tblActive WHERE Inactive = 1"
  
 
        cmd.Connection.Open()
 
        cmd.Connection.Close()