Dealing with converting empty string value to Integer

[Ida]

Hi,

With the textboxes in a RadGrid, it is possible to deal with an empty string value, that needs to be stored to an Integer value?

I am assigning a texbox to a Integer variable, though that textbox can be blank:

Dim

 

 

CodEnd As Integer? = TryCast(edit("CodEnd").Controls(0), TextBox).Text

The variable CodEnd will then be used as parameter to pass into an UPDATE SQL query.

I tried setting ConvertEmptyStringToNull="True" in the textbox, though I still got the following error:

Conversion from string "" to type 'Integer' is not valid

Any advice please?

Thank you, Ida

 

[Shinu]

Hi Ida,

I guess you want to store a string as Int,and convert the empty string to 0.Please try the following.

VB:

Protected Sub RadGrid1_UpdateCommand(sender As Object, e As GridCommandEventArgs)
    If TypeOf e.Item Is GridEditableItem Then
        Dim edit As GridEditableItem = DirectCast(e.Item, GridEditableItem)
        Dim id As String = TryCast(edit("CodEnd").Controls(0), TextBox).Text
        If id = String.Empty Then
            id = Nothing
        End If
            'Value converted Int
        Dim value As Integer = Convert.ToInt32(id)
    End If
End Sub

Hope this helps,let me know if any concern.
Thanks,
Shinu

[Ida]

Thank you Shinu.