TABLE A: Converting SQL Server Data Types to VB Data Types
SQL Server Data Types Corresponding VB Data Type
Char, VarChar, Text, Decimal, Numeric String
Bit Boolean
Binary, VarBinary, Image One-dimensional byte array
Int Long
SmallInt Integer
TinyInt Byte
Float Double
Real Single
Money, SmallMoney Currency
DateTime, SmallDateTime Date