ADO 数据类型转换表 oledbtype sqldbtype

ADO DataType Enum	ADO DataType Enum Value	.NET Framework	SQL Server	Size	Access	Oracle	Visual Basic 6.0
adBigInt	20	Int64 SqlDbType.BigInt 10 OleDbType.BigInt 11	bigint 9	8			Variant
adBinary	128	Byte[] SqlDbType.VarBinary 10 OleDbType.Binary 11	binary timestamp	50 8		Raw 7	Variant
adBoolean	11	Boolean SqlDbType.Bit 10 OleDbType.Boolean 11	bit	1 2	YesNo		Boolean
adBSTR	8	String OleDbType.BSTR 11
adChapter	136	(DataReader)
adChar	129	String  SqlDbType.Char 10 OleDbType.Char 11	char	X		Char	String
adCurrency	6	Decimal SqlDbType.Money 10 OleDbType.Currency 11	money smallmoney	8 4 0	Currency		Currency
adDate	7	DateTime OleDbType.DBDate 11		0	DateTime 2		Date
adDBDate	133	DateTime OleDbType.DBDate 11
adDBFileTime	137	DBFileTime 11
adDBTime	134	DateTime OleDbType.DBTime 11
adDBTimeStamp	135	DateTime SqlDbType.DateTime 10 OleDbType.DBTimeStamp 11	datetime  smalldatetime	8 4 0	DateTime 1	Date	Date
adDecimal	14	Decimal OleDbType.Decimal 11				Decimal 7	Variant 6
adDouble	5	Double SqlDbType.Float 10 OleDbType.Double 11	float	8 0	Double	Float	Double
adEmpty	0	Empty 11
adError	10	External-Exception OleDbType.Error 11
adFileTime	64	DateTime OleDbType.Filetime 11
adGUID	72	Guid  SqlDbType.UniqueIdentifier 10 OleDbType.Guid 11	uniqueidentifier5	16	ReplicationID2,3		Variant