Em, how to convert a blank data to INTEGER?
I use the code as shown below:
MP1T(hour, 0) = Convert.ToInt16(rs.Fields("MP1T").Value)
but then the field MP1T is previously in VARCHAR format.
It runs smoothly until it found out that the field is blank and cannot be converted.
How can i solve it? Thanks
P/S: Re-declare column data type may be hard to implement.