Stimulsoft.Base.StiDbType.OleDb Enumeration

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

Syntax

C++

Visual Basic

public: enum OleDb { Empty = 0, SmallInt = 2, Integer = 3, Single = 4, Double = 5, Currency = 6, Date = 7, BSTR = 8, IDispatch = 9, Error = 10, Boolean = 11, Variant = 12, IUnknown = 13, Decimal = 14, TinyInt = 16, UnsignedTinyInt = 17, UnsignedSmallInt = 18, UnsignedInt = 19, BigInt = 20, UnsignedBigInt = 21, Filetime = 64, Guid = 72, Binary = 128, Char = 129, WChar = 130, Numeric = 131, DBDate = 133, DBTime = 134, DBTimeStamp = 135, PropVariant = 138, VarNumeric = 139, VarChar = 200, LongVarChar = 201, VarWChar = 202, LongVarWChar = 203, VarBinary = 204, LongVarBinary = 205 };

Members

Members	Description
Empty	No value (DBTYPE_EMPTY).
SmallInt	A 16-bit signed integer (DBTYPE_I2). This maps to System.Int16.
Integer	A 32-bit signed integer (DBTYPE_I4). This maps to System.Int32.
Single	A floating-point number within the range of -3.40E +38 through 3.40E +38 (DBTYPE_R4). This maps to System.Single.
Double	A floating-point number within the range of -1.79E +308 through 1.79E +308 (DBTYPE_R8). This maps to System.Double.
Currency	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 System.Decimal.
Date	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 System.DateTime.
BSTR	A null-terminated character string of Unicode characters (DBTYPE_BSTR). This maps to System.String.
IDispatch	A pointer to an IDispatch interface (DBTYPE_IDISPATCH). This maps to System.Object.
Error	A 32-bit error code (DBTYPE_ERROR). This maps to System.Exception.
Boolean	A Boolean value (DBTYPE_BOOL). This maps to System.Boolean.
Variant	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 System.Object.
IUnknown	A pointer to an IUnknown interface (DBTYPE_UNKNOWN). This maps to System.Object.
Decimal	A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1 (DBTYPE_DECIMAL). This maps to System.Decimal.
TinyInt	A 8-bit signed integer (DBTYPE_I1). This maps to System.SByte.
UnsignedTinyInt	A 8-bit unsigned integer (DBTYPE_UI1). This maps to System.Byte.
UnsignedSmallInt	A 16-bit unsigned integer (DBTYPE_UI2). This maps to System.UInt16.
UnsignedInt	A 32-bit unsigned integer (DBTYPE_UI4). This maps to System.UInt32.
BigInt	A 64-bit signed integer (DBTYPE_I8). This maps to System.Int64.
UnsignedBigInt	A 64-bit unsigned integer (DBTYPE_UI8). This maps to System.UInt64.
Filetime	A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). This maps to System.DateTime.
Guid	A globally unique identifier (or GUID) (DBTYPE_GUID). This maps to System.Guid.
Binary	A stream of binary data (DBTYPE_BYTES). This maps to an System.Array of type System.Byte.
Char	A character string (DBTYPE_STR). This maps to System.String.
WChar	A null-terminated stream of Unicode characters (DBTYPE_WSTR). This maps to System.String.
Numeric	An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). This maps to System.Decimal.
DBDate	Date data in the format yyyymmdd (DBTYPE_DBDATE). This maps to System.DateTime.
DBTime	Time data in the format hhmmss (DBTYPE_DBTIME). This maps to System.TimeSpan.
DBTimeStamp	Data and time data in the format yyyymmddhhmmss (DBTYPE_DBTIMESTAMP). This maps to System.DateTime.
PropVariant	An automation PROPVARIANT (DBTYPE_PROP_VARIANT). This maps to System.Object.
VarNumeric	A variable-length numeric value (System.Data.OleDb.OleDbParameter only). This maps to System.Decimal.
VarChar	A variable-length stream of non-Unicode characters (System.Data.OleDb.OleDbParameter only). This maps to System.String.
LongVarChar	A long string value (System.Data.OleDb.OleDbParameter only). This maps to System.String.
VarWChar	A variable-length, null-terminated stream of Unicode characters (System.Data.OleDb.OleDbParameter only). This maps to System.String.
LongVarWChar	A long null-terminated Unicode string value (System.Data.OleDb.OleDbParameter only). This maps to System.String.
VarBinary	A variable-length stream of binary data (System.Data.OleDb.OleDbParameter only). This maps to an System.Array of type System.Byte.
LongVarBinary	A long binary value (System.Data.OleDb.OleDbParameter only). This maps to an System.Array of type System.Byte.

File

StiDbType.cs

Made with Doc-O-Matic.

What do you think about this topic? Send feedback!