Double or integer? waht to use with BIG or SMALL data types?
I have a value of: "2.54334881002458E-37" and i keep getting "overflow" exception when i'm using a double.

what should i use to make this work?

Thank you

code snippet:

    Dim curries, act, cat As Double
     For Each dataRow As DataRow In dt.Rows
                curries = dataRow("Activity")

getting the error when i try to assign Activity to curries.

but "activity" is a string in the database....
Double or integer? waht to use with BIG or SMALL data types?
===

I have a value of: "2.54334881002458E-37" and i keep getting "overflow" exception when i'm using a double.

what should i use to make this work?

Thank you

code snippet:

    Dim curries, act, cat As Double
     For Each dataRow As DataRow In dt.Rows
                curries = dataRow("Activity")

getting the error when i try to assign Activity to curries.

but "activity" is a string in the database....