Dbtype + sqldbtype + System Data Type table

SQL type	Dbtype	Sqldbtype	Type
Bit	Boolean	Bit	System. Boolean
Tinyint	Byte	Tinyint	System. byte
Smallint	Int16	Smallint	System. int16
Int	Int32	Int	System. int32
Bigint	Int64	Bigint	System. int64
Real	Single	Real	System. Single
Float	Double	Float	System. Double
Smallmoney	Decimal	Smallmoney	System. Decimal
Money	Decimal	Money	System. Decimal
Numeric	Decimal	Decimal	System. Decimal
Decimal	Decimal	Decimal	System. Decimal
Smalldatetime	Datetime	Smalldatetime	System. datetime
Datetime	Datetime	Datetime	System. datetime
Binary	Byte []	Binary	Array of system. byte
Varbinary	Byte []	Varbinary	Array of system. byte
Image	Byte []	Image	Array of system. byte
Timestamp	Byte []	Timestamp	Array of system. byte
Char	String	Char	System. String
Nchar	String	Nchar	System. String
Varchar	String	Varchar	System. String
Nvarchar	String	Nvarchar	System. String
Text	String	Text	System. String
Ntext	String	Ntext	System. String
XML	String	XML	System. String
Uniqueidentifier	Guid	Uniqueidentifier	System. guid
SQL _variant	Object	Variant	System. Object