| aspxtreme |
Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics |
  |
OleDbType Enumeration
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.
|
| 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.
|
| 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. |
NOTE: This data type is not currently supported by ADO.NET. Usage may cause unpredictable results. 
