列表最常见的数据类型映射 访问类型名称 数据库数据类型 OLEDB 类型 .NET 框架类型 成员名称 文本 VarWChar DBTYPE _ WSTR System.String OleDbType.VarWChar 备忘录 LongVarWCha R DBTYPE _ WSTR System.String OleDbType.LongVarWChar 字节数: UnsignedTin
列表最常见的数据类型映射
访问类型名称
数据库数据类型
OLEDB 类型
.NET 框架类型
成员名称
文本
VarWChar
DBTYPE _ WSTR
System.String
OleDbType.VarWChar
备忘录
LongVarWCha R
DBTYPE _ WSTR
System.String
OleDbType.LongVarWChar
字节数:
UnsignedTinyInt
DBTYPE _ UI 1
System.Byte
OleDbType.UnsignedTinyInt
是 / 否
Boolean
DBTYPE_BOOL
System.Boolean
OleDbType.Boolean
日期 / 时间
DateTime
DBTYPE _ DATE
System.DateTime
OleDbType.date
货币
十进制
DBTYPE_NUMERIC
System.Decimal
OleDbType.numeric
十进制数:
十进制
DBTYPE_NUMERIC
System.Decimal
OleDbType.numeric
双数:
双
DBTYPE_R8
System.Double
OleDbType.Double
Autonumber (复制 ID)
GUID
DBTYPE_GUID
System.Guid
OleDbType.guid
复制 (ID) 号:
GUID
DBTYPE_GUID
System.Guid
OleDbType.guid
Autonumber (长整型)
整数
DBTYPE_I4
System.Int 32
OleDbType.integer
数量: (长整型)
整数
DBTYPE_I4
System.Int 32
OleDbType.integer
OLE 对象
LongVarBinary
DBTYPE_BYTES
数组 System.Byte
OleDbType.LongVarBinary
单个数字:
单个
DBTYPE_R4
System.Single
OleDbType.single
整型数:
SmallInt
DBTYPE_I2
System.Int 16
OleDbType.SmallInt
二进制
VarBinary *
DBTYPE_BYTES
数组 System.Byte
OleDbType.binary
超链接
VarWChar
DBTYPE _ WSTR
System.String
OleDbType.VarWChar
FAILED TO TRANSLATE SENTENCE 您必须创建此数据类型通过代码。
OLE DB Provider for Microsoft Jet 数据类型支持:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_data_type_support.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_data_type_support.asp)
OLE DB Provider for Microsoft Jet DBPROPSET_JETOLEDB_COLUMN 中提供程序特有的属性:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_provider_specific_properties_in_dbpropset_jetoledb_column.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbprovjet_provider_specific_properties_in_dbpropset_jetoledb_column.asp)
OleDbType 枚举
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbTypeClassTopic.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOleDbOleDbTypeClassTopic.asp)
本文原创发布php中文网,转载请注明出处,感谢您的尊重!