>>Didn't see this question before. You can use bigint in SQL Server.
>
>Before posting this question, I changed it to Double. It resolved the issue. But, I was wondering which one was better.
I wanted to update this answer as I seem to look at wrong column. I checked few more links
http://visualbasic.about.com/od/usingvbnet/a/datatypes.htmSo, can you do
Dim Big as Int64
?
If it's not broken, fix it until it is.
My Blog