.Net中Access数据格式对应
来源:互联网 发布:c语言输出你好 编辑:程序博客网 时间:2024/06/09 22:53
INFO: OleDbType Enumeration vs. Microsoft Access Data Types
View products that this article applies to.
Article ID : 320435 Last Review : February 22, 2007 Revision : 4.1
This article was previously published under Q320435
On This Page
SUMMARY
MORE INFORMATION
List of the Most Common Data Type Mappings
REFERENCES
SUMMARY
This article describes how the Microsoft .NET Platform OLE DB types map to the Microsoft Access data types for columns.
Back to the top
MORE INFORMATION
When you use the Access interface to design a table, you see several choices for field types that do not match to database data types. This is because these "types" are just display formats and do not determine the data type. Access uses other properties that are not necessarily exposed through the Microsoft OLE DB Provider for Jet to determine how to format the data.
Examples of these properties include the following: • General Date, Long Date, Long Time, Medium Time, Short Time, Medium Date, and Short Date are display formats for DateTime data type. • Hyperlink is a display format for Access Text data type. • True/False and On/Off both map to the Access Yes/No data type.
Access Type Name Database Data Type OLE DB Type .NET Framework Type Member Name Text VarWChar DBTYPE_WSTR System.String OleDbType.VarWChar Memo LongVarWChar DBTYPE_WSTR System.String OleDbType.LongVarWChar Number: Byte UnsignedTinyInt DBTYPE_UI1 System.Byte OleDbType.UnsignedTinyInt Yes/No Boolean DBTYPE_BOOL System.Boolean OleDbType.Boolean Date/Time DateTime DBTYPE_DATE System.DateTime OleDbType.Date Currency Decimal DBTYPE_NUMERIC System.Decimal OleDbType.Numeric Number: Decimal Decimal DBTYPE_NUMERIC System.Decimal OleDbType.Numeric Number: Double Double DBTYPE_R8 System.Double OleDbType.Double Autonumber (Replication ID) GUID DBTYPE_GUID System.Guid OleDbType.Guid Number: (Replication ID) GUID DBTYPE_GUID System.Guid OleDbType.Guid Autonumber (Long Integer) Integer DBTYPE_I4 System.Int32 OleDbType.Integer Number: (Long Integer) Integer DBTYPE_I4 System.Int32 OleDbType.Integer OLE Object LongVarBinary DBTYPE_BYTES Array of System.Byte OleDbType.LongVarBinary Number: Single Single DBTYPE_R4 System.Single OleDbType.Single Number: Integer SmallInt DBTYPE_I2 System.Int16 OleDbType.SmallInt Binary VarBinary* DBTYPE_BYTES Array of System.Byte OleDbType.Binary Hyperlink VarWChar DBTYPE_WSTR System.String OleDbType.VarWChar
* This data type is not available in the Access designer user interface. You must create this data type through code.
Examples of these properties include the following: • General Date, Long Date, Long Time, Medium Time, Short Time, Medium Date, and Short Date are display formats for DateTime data type. • Hyperlink is a display format for Access Text data type. • True/False and On/Off both map to the Access Yes/No data type.
Back to the top
List of the Most Common Data Type Mappings
The following table lists the most common data types that are used in Microsoft Access and how these data types relate to the Microsoft .NET Framework data types and to the OleDbType enumeration.Access Type Name Database Data Type OLE DB Type .NET Framework Type Member Name Text VarWChar DBTYPE_WSTR System.String OleDbType.VarWChar Memo LongVarWChar DBTYPE_WSTR System.String OleDbType.LongVarWChar Number: Byte UnsignedTinyInt DBTYPE_UI1 System.Byte OleDbType.UnsignedTinyInt Yes/No Boolean DBTYPE_BOOL System.Boolean OleDbType.Boolean Date/Time DateTime DBTYPE_DATE System.DateTime OleDbType.Date Currency Decimal DBTYPE_NUMERIC System.Decimal OleDbType.Numeric Number: Decimal Decimal DBTYPE_NUMERIC System.Decimal OleDbType.Numeric Number: Double Double DBTYPE_R8 System.Double OleDbType.Double Autonumber (Replication ID) GUID DBTYPE_GUID System.Guid OleDbType.Guid Number: (Replication ID) GUID DBTYPE_GUID System.Guid OleDbType.Guid Autonumber (Long Integer) Integer DBTYPE_I4 System.Int32 OleDbType.Integer Number: (Long Integer) Integer DBTYPE_I4 System.Int32 OleDbType.Integer OLE Object LongVarBinary DBTYPE_BYTES Array of System.Byte OleDbType.LongVarBinary Number: Single Single DBTYPE_R4 System.Single OleDbType.Single Number: Integer SmallInt DBTYPE_I2 System.Int16 OleDbType.SmallInt Binary VarBinary* DBTYPE_BYTES Array of System.Byte OleDbType.Binary Hyperlink VarWChar DBTYPE_WSTR System.String OleDbType.VarWChar
* This data type is not available in the Access designer user interface. You must create this data type through code.
Back to the top
REFERENCES
For more information about data types, visit the following MSDN Web sites:
OLE DB Provider for Microsoft Jet: Data Type Support
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: Provider-Specific Properties in 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 Enumeration
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)
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: Provider-Specific Properties in 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 Enumeration
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)
- .Net中Access数据格式对应
- asp.net中Jquery解析json数据格式
- Access数据类型与.net OleDbType枚举类型的对应
- C# SQL数据格式对应关系
- ASP.NET 2.0中Gridview利用DataFormatString属性设置数据格式
- ASP.NET 2.0中Gridview利用DataFormatString属性设置数据格式
- ASP.NET 2.0中Gridview利用DataFormatString属性设置数据格式
- access数据库类型对应
- .net 数据格式设置大全
- .net 数据格式说明
- VB.Net中动态创建Access数据库
- c#.net 中压缩access并且更名
- ASP.NET中禁止下载Access数据库文件
- ASP.net中操作Access数据库
- VB.Net中动态创建Access数据库
- 在.net中连接ACCESS数据库
- Asp.net中Access日期型比较
- .net中使用OleDb连接Access数据库
- 武松托地从柜身前踏 水浒传
- 说时 水浒
- 话说当时武松踏住蒋 水浒传
- 酒至数碗 水浒传
- 荏苒光阴 水浒
- .Net中Access数据格式对应
- 时光迅速 水浒传
- 看看月明光彩照入东 水浒
- 武松进到房里 水浒传
- 话里却说施恩已有人 水浒传
- 不多时 水浒传
- 连续正整数之和
- Hibernate工具类的实现(不断更新中)
- 需求管理方案第三方评测报告