The correspondence between the access data type and the. NET oledbtype Enumeration type

 

The correspondence between the access data type and the. NET oledbtype Enumeration type

List of the most common data type ing

Access type name	Database Data Type	Oledb type	. NET Framework type	Member name
Text	Varwchar	Dbtype _ wstr	System. String	Oledbtype. varwchar
Memorandum	Longvarwcha R	Dbtype _ wstr	System. String	Oledbtype. longvarwchar
Number of bytes:	Unsignedtinyint	Dbtype _ UI 1	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
Decimal number:	Decimal	Dbtype_numeric	System. Decimal	Oledbtype. Numeric
Double:	Double	Dbtype_r8	System. Double	Oledbtype. Double
Autonumber (copy ID)	Guid	Dbtype_guid	System. guid	Oledbtype. guid
Copy (ID) number:	Guid	Dbtype_guid	System. guid	Oledbtype. guid
Autonumber (long integer)	Integer	Dbtype_i4	System. Int 32	Oledbtype. Integer
Quantity: (long integer)	Integer	Dbtype_i4	System. Int 32	Oledbtype. Integer
OLE object	Longvarbinary	Dbtype_bytes	Array System. byte	Oledbtype. longvarbinary
Single Number:	Single	Dbtype_r4	System. Single	Oledbtype. Single
Integer:	Smallint	Dbtype_i2	System. Int 16	Oledbtype. smallint
Binary	Varbinary *	Dbtype_bytes	Array System. byte	Oledbtype. Binary
Hyperlink	Varwchar	Dbtype _ wstr	System. String	Oledbtype. varwchar

Failed to translate sentence you must create this data type throughCode.

Ole db provider for Microsoft Jet supports the following data types:

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)

Provided in ole db provider for Microsoft Jet dbpropset_jetoledb_columnProgramUnique attributes:

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 =/libraries/en-US/cpref/html/frlrfsystemdataoledboledbtypeclasstopic. asp (http://msdn.microsoft.com/library/default.asp? Url =/library/en-US/cpref/html/frlrfsystemdataoledboledbtypeclasstopic. asp)