HI
i'm facing a problem and i don't know why
i'm retrieving data from a sqlserver databse

select a from table name where ....
then i read the value
by using the executereader finction.
i want to store this value in a session variable.
whenever i store a float sqldatatype in a session no problem accured.
but when i store the a value that has a char sqldatatype in a session.
the following error occured:

cast from string " value of 'a'" to type 'Double' is not valid.

the session is stored in this way:

session("a") = Int(Datareader.Item("a"))

i know that it souldn't be converted to integer but what is the right data conversion that must be used in this case. I nedd to get the value from the query that is a char value as string. the value in the session should be as string

If Anyone can please HELP me.
THanks


Georges M. Kaddoum

__________________
<GMK>

well
i've found the solution
i should keep it as it is without conversion.
session("a") = Datareader.Item("a")

thanks anyway.

Georges M. Kaddoum