how to display the object datatype output into a text box.

[bnathvbdotnet]

how to convert the 'object' datatype into an integer and display it on the text box.

dim o as object
o = SqlHelper.ExecuteScalar(connection, "CountProductsByCategory", 1)

The variable 'o' has the correct output (single value) but how should I use CTYPE to convert it into the integer/string to display on the text box?

thanks
nath

[Carnifex]

2 Methods

Dim myInteger As Integer

myInteger = CInt(o)

Or

myInteger = CType(o, Integer)

[VBCrazyCoder]

Integer.Parse(o) might also work.

[bnathvbdotnet]

THANK YOU

[Pirate]

Or use the Convert static method :

Dim o As Object
Dim int As Integer = Convert.ToInt32(o)