asp.net.ph

OleDbType Enumeration

System.Data.OleDb Namespace


Returns the data type of a field, a property, or an OleDbParameter. The corresponding OLE DB data type is shown in parentheses in the description of each member.

Members


Member Name Description
BigInt A 64-bit signed integer ( DBTYPE_I8 ). This maps to Int64.
Binary A stream of binary data ( DBTYPE_BYTES ). This maps to an Array of type Byte.
Boolean A boolean value ( DBTYPE_BOOL ). This maps to Boolean.
BSTR A null-terminated character string of Unicode characters ( DBTYPE_BSTR ). This maps to String.
Char A character string ( DBTYPE_STR ). This maps to String.
Currency A currency value ranging from -263 ( or -922,337,203,685,477.5808 ) to 2 63 -1 ( or +922,337,203,685,477.5807 ) with an accuracy to a ten-thousandth of a currency unit ( DBTYPE_CY ). This maps to Decimal.
Date Date data, stored as a double ( DBTYPE_DATE ). The whole portion is the number of days since December 30, 1899, while the fractional portion is a fraction of a day. This maps to DateTime.
DBDate Date data in the format yyyymmdd ( DBTYPE_DBDATE ). This maps to DateTime.
DBTime Time data in the format hhmmss ( DBTYPE_DBTIME ). This maps to TimeSpan.
DBTimeStamp Data and time data in the format yyyymmddhhmmss ( DBTYPE_DBTIMESTAMP ). This maps to DateTime.
Decimal A fixed precision and scale numeric value between -1038 -1 and 10 38 -1 ( DBTYPE_DECIMAL ). This maps to Decimal.
Double A floating point number within the range of -1.79E +308 through 1.79E +308 ( DBTYPE_R8 ). This maps to Double.
Empty No value ( DBTYPE_EMPTY ). This maps to Empty.
Error A 32-bit error code ( DBTYPE_ERROR ). This maps to Exception.
Filetime A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 ( DBTYPE_FILETIME ). This maps to DateTime.
Guid A globally unique identifier ( or GUID ) ( DBTYPE_GUID ). This maps to Guid.
IDispatch A pointer to an IDispatch interface ( DBTYPE_IDISPATCH ). This maps to Object.

NOTE: This data type is not currently supported by ADO.NET. Usage may cause unpredictable results.

Integer A 32-bit signed integer ( DBTYPE_I4 ). This maps to Int32.
IUnknown A pointer to an IUnknown interface ( DBTYPE_UNKNOWN ). This maps to Object.

NOTE: This data type is not currently supported by ADO.NET. Usage may cause unpredictable results.

LongVarBinary A long binary value ( OleDbParameter only ). This maps to an Array of type Byte.
LongVarChar A long string value ( OleDbParameter only ). This maps to String.
LongVarWChar A long null-terminated Unicode string value ( OleDbParameter only ). This maps to String.
Numeric An exact numeric value with a fixed precision and scale ( DBTYPE_NUMERIC ). This maps to Decimal.
PropVariant An automation PROPVARIANT ( DBTYPE_PROP_VARIANT ). This maps to Object.
Single A floating point number within the range of -3.40E +38 through 3.40E +38 ( DBTYPE_R4 ). This maps to Single.
SmallInt A 16-bit signed integer ( DBTYPE_I2 ). This maps to Int16.
TinyInt A 8-bit signed integer ( DBTYPE_I1 ). This maps to SByte.
UnsignedBigInt A 64-bit unsigned integer ( DBTYPE_UI8 ). This maps to UInt64.
UnsignedInt A 32-bit unsigned integer ( DBTYPE_UI4 ). This maps to UInt32.
UnsignedSmallInt A 16-bit unsigned integer ( DBTYPE_UI2 ). This maps to UInt16.
UnsignedTinyInt A 8-bit unsigned integer ( DBTYPE_UI1 ). This maps to Byte.
VarBinary A variable-length stream of binary data ( OleDbParameter only ). This maps to an Array of type Byte.
VarChar A variable-length stream of non-Unicode characters ( OleDbParameter only ). This maps to String.
Variant A special data type that can contain numeric, string, binary, or date data, as well as the special values Empty and Null ( DBTYPE_VARIANT ). This type is assumed if no other is specified. This maps to Object.
VarNumeric A variable-length numeric value ( OleDbParameter only ). This maps to Decimal.
VarWChar A variable-length, null-terminated stream of Unicode characters ( OleDbParameter only ). This maps to String.
WChar A null-terminated stream of Unicode characters ( DBTYPE_WSTR ). This maps to String.

See Also

SqlDbType Enum Skip Navigation Links




Home
Suggested Reading


Previous page Back to top Next page

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph