Input string was not in a correct format.

hertendreef · February 16th, 2008, 12:40 PM

Hi,

I want to delete the selected row in the gridview when clicking on the linkbutton. There is no delete command in the aspx file (because data is fetched from several tables), so i try to do that with the rowcommand in code-behind like this:

aspx file:
---------
<asp:GridView ID="GridView1" DataKeyNames="gridkey" ...>
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lb1" runat="server"
OnClientClick="return confirm('sure?');"
CommandName="Delete" Text="go">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
...
</asp:GridView>

code-behind:
-----------
Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs ) Handles GridView1.RowCommand
Dim r As Int32
Dim dbkey As String
r = Convert.ToInt32(e.CommandArgument)
dbkey = Convert.ToInt32(GridView1.DataKeys(r).Value)
End Sub

I have two questions:
1) i get the error: "Input string was not in a correct format. "
2) do i need somewhere a delete command (sql="delete from ...") . Do i have to define the connectionstring, open the connection etc ..?

Thanks
H.

weicco · February 17th, 2008, 02:59 PM

Set break-point in the beginning of GridView1_RowCommand method. Does it get called at all? Go step-by-step through that method and see if that Convert.ToInt32(...) is throwing the error. You could try something like the following in order to isolate the problem:

Code:

Protected Sub GridView1_RowCommand(...)
    Dim r As Int32
    Dim dbkey As String

    If Not Int32.TryParse(e.CommandArgument, r) Then
        Throw New Exception("CommandArgument was not of integer type")
    End If

    If Not Int32.TryParse(GridView1.DataKeys(r).Value, dbkey) Then
        Throw New Exception("GridView1.DataKeys(r).Value was not of integer type")
    End If

End Sub

hertendreef · February 19th, 2008, 06:22 PM

Thanks