Duplicate GridView Row from ItemTemplate

Example:

<asp:TemplateField HeaderText="">
    <ItemTemplate>
        <asp:ImageButton ID="CopyButton" runat="server" OnClick="CopyButton_Click" AlternateText="Duplicate" ImageUrl="../Images/Copy.png" CausesValidation="False" />
    </ItemTemplate>
</asp:TemplateField>

Now put this in your code behind:

Protected Sub CopyButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
    Dim row As GridViewRow = CType(CType(sender, ImageButton).NamingContainer, GridViewRow)
    Dim strValue As String = GridView1.DataKeys(row.RowIndex).Value.ToString()
    Dim CopyCommand As String = "INSERT INTO [TableName] ([Column1], [Column2], [Column3]) SELECT [Column1], [Column2], [Column3] FROM [TableName] WHERE [ID] = " & strValue
    Try
        SQLDataSource1.InsertCommand = CopyCommand
        SQLDataSource1.Insert()
    Catch ex As Exception
    End Try
End Sub