OleDbType Enumeration

最新推荐文章于 2024-09-28 15:13:45 发布

snail8384

最新推荐文章于 2024-09-28 15:13:45 发布

阅读量880

点赞数

分类专栏： DotNet 文章标签： integer windows stream character string types

DotNet 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

OleDbType Enumeration

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

Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic (Declaration)

Public Enumeration OleDbType

Visual Basic (Usage)

Dim instance As OleDbType

public enum OleDbType

Visual C++

public enum class OleDbType

JScript

public enum OleDbType

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 -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 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	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 -10 38 -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).
	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, and also 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.

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.

Platforms

Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Version Information