OleDbType OleDbType OleDbType OleDbType Enum

Definition

Specifies the data type of a field, a property, for use in an OleDbParameter.

public enum class OleDbType
public enum OleDbType
type OleDbType = 
Public Enum OleDbType
Inheritance

Fields

BigInt BigInt BigInt BigInt 20

A 64-bit signed integer (DBTYPE_I8). This maps to Int64.

Binary Binary Binary Binary 128

A stream of binary data (DBTYPE_BYTES). This maps to an Array of type Byte.

Boolean Boolean Boolean Boolean 11

A Boolean value (DBTYPE_BOOL). This maps to Boolean.

BSTR BSTR BSTR BSTR 8

A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to String.

Char Char Char Char 129

A character string (DBTYPE_STR). This maps to String.

Currency Currency Currency Currency 6

A currency value ranging from -2 63 (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 Date Date 7

Date data, stored as a double (DBTYPE_DATE). The whole portion is the number of days since December 30, 1899, and the fractional portion is a fraction of a day. This maps to DateTime.

DBDate DBDate DBDate DBDate 133

Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to DateTime.

DBTime DBTime DBTime DBTime 134

Time data in the format hhmmss (DBTYPE_DBTIME). This maps to TimeSpan.

DBTimeStamp DBTimeStamp DBTimeStamp DBTimeStamp 135

Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to DateTime.

Decimal Decimal Decimal Decimal 14

A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to Decimal.

Double Double Double Double 5

A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to Double.

Empty Empty Empty Empty 0

No value (DBTYPE_EMPTY).

Error Error Error Error 10

A 32-bit error code (DBTYPE_ERROR). This maps to Exception.

Filetime Filetime Filetime Filetime 64

A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to DateTime.

Guid Guid Guid Guid 72

A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to Guid.

IDispatch IDispatch IDispatch IDispatch 9

A pointer to an IDispatch interface (DBTYPE_IDISPATCH). This maps to Object.

This data type is not currently supported by ADO.NET. Its usage may cause unpredictable results.

Integer Integer Integer Integer 3

A 32-bit signed integer (DBTYPE_I4). This maps to Int32.

IUnknown IUnknown IUnknown IUnknown 13

A pointer to an IUnknown interface (DBTYPE_UNKNOWN). This maps to Object.
This data type is not currently supported by ADO.NET. Its usage may cause unpredictable results.

LongVarBinary LongVarBinary LongVarBinary LongVarBinary 205

A long binary value (OleDbParameter only). This maps to an Array of type Byte.

LongVarChar LongVarChar LongVarChar LongVarChar 201

A long string value (OleDbParameter only). This maps to String.

LongVarWChar LongVarWChar LongVarWChar LongVarWChar 203

A long null-terminated Unicode string value (OleDbParameter only). This maps to String.

Numeric Numeric Numeric Numeric 131

An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). This maps to Decimal.

PropVariant PropVariant PropVariant PropVariant 138

An automation PROPVARIANT (DBTYPE_PROP_VARIANT). This maps to Object.

Single Single Single Single 4

A floating-point number within the range of -3.40E +38 through 3.40E +38 (DBTYPE_R4). This maps to Single.

SmallInt SmallInt SmallInt SmallInt 2

A 16-bit signed integer (DBTYPE_I2). This maps to Int16.

TinyInt TinyInt TinyInt TinyInt 16

A 8-bit signed integer (DBTYPE_I1). This maps to SByte.

UnsignedBigInt UnsignedBigInt UnsignedBigInt UnsignedBigInt 21

A 64-bit unsigned integer (DBTYPE_UI8). This maps to UInt64.

UnsignedInt UnsignedInt UnsignedInt UnsignedInt 19

A 32-bit unsigned integer (DBTYPE_UI4). This maps to UInt32.

UnsignedSmallInt UnsignedSmallInt UnsignedSmallInt UnsignedSmallInt 18

A 16-bit unsigned integer (DBTYPE_UI2). This maps to UInt16.

UnsignedTinyInt UnsignedTinyInt UnsignedTinyInt UnsignedTinyInt 17

A 8-bit unsigned integer (DBTYPE_UI1). This maps to Byte.

VarBinary VarBinary VarBinary VarBinary 204

A variable-length stream of binary data (OleDbParameter only). This maps to an Array of type Byte.

VarChar VarChar VarChar VarChar 200

A variable-length stream of non-Unicode characters (OleDbParameter only). This maps to String.

Variant Variant Variant Variant 12

A special data type that can contain numeric, string, binary, or date data, and also the special values Empty and Null (DBTYPE_VARIANT). This type is assumed if no other is specified. This maps to Object.

VarNumeric VarNumeric VarNumeric VarNumeric 139

A variable-length numeric value (OleDbParameter only). This maps to Decimal.

VarWChar VarWChar VarWChar VarWChar 202

A variable-length, null-terminated stream of Unicode characters (OleDbParameter only). This maps to String.

WChar WChar WChar WChar 130

A null-terminated stream of Unicode characters (DBTYPE_WSTR). This maps to String.

Remarks

The preceding table shows mappings between OleDbType data types, OLE DB data types (shown in parentheses), and the .NET Framework types. The OleDbType data types accept System.Char[] as Parameter.Value in parameterized queries.

Applies to