Export (0) Print
Expand All
Expand Minimize

DbType Enumeration

Specifies the data type of a field, a property, or a Parameter object of a .NET Framework data provider.

Namespace: System.Data
Assembly: System.Data (in system.data.dll)

'Declaration
Public Enumeration DbType
'Usage
Dim instance As DbType

public enum DbType
public enum DbType

 Member nameDescription
Supported by the .NET Compact FrameworkAnsiStringA variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. 
Supported by the .NET Compact FrameworkAnsiStringFixedLengthA fixed-length stream of non-Unicode characters. 
Supported by the .NET Compact FrameworkBinaryA variable-length stream of binary data ranging between 1 and 8,000 bytes. 

ADO.NET cannot correctly infer the type if the byte array is larger than 8,000 bytes. Explicitly specify the DbType when working with byte arrays larger than 8,000 bytes.

Supported by the .NET Compact FrameworkBooleanA simple type representing Boolean values of true or false
Supported by the .NET Compact FrameworkByteAn 8-bit unsigned integer ranging in value from 0 to 255. 
Supported by the .NET Compact FrameworkCurrencyA 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. 
Supported by the .NET Compact FrameworkDateDate and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. 
Supported by the .NET Compact FrameworkDateTimeA type representing a date and time value. 
Supported by the .NET Compact FrameworkDecimalA simple type representing values ranging from 1.0 x 10 -28 to approximately 7.9 x 10 28 with 28-29 significant digits. 
Supported by the .NET Compact FrameworkDoubleA floating point type representing values ranging from approximately 5.0 x 10 -324 to 1.7 x 10 308 with a precision of 15-16 digits. 
Supported by the .NET Compact FrameworkGuidA globally unique identifier (or GUID). 
Supported by the .NET Compact FrameworkInt16An integral type representing signed 16-bit integers with values between -32768 and 32767. 
Supported by the .NET Compact FrameworkInt32An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. 
Supported by the .NET Compact FrameworkInt64An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807. 
Supported by the .NET Compact FrameworkObjectA general type representing any reference or value type not explicitly represented by another DbType value. 
Supported by the .NET Compact FrameworkSByteAn integral type representing signed 8-bit integers with values between -128 and 127. 
Supported by the .NET Compact FrameworkSingleA floating point type representing values ranging from approximately 1.5 x 10 -45 to 3.4 x 10 38 with a precision of 7 digits. 
Supported by the .NET Compact FrameworkStringA type representing Unicode character strings. 
Supported by the .NET Compact FrameworkStringFixedLength 
Supported by the .NET Compact FrameworkTimeDate and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. 
Supported by the .NET Compact FrameworkUInt16An integral type representing unsigned 16-bit integers with values between 0 and 65535. 
Supported by the .NET Compact FrameworkUInt32An integral type representing unsigned 32-bit integers with values between 0 and 4294967295. 
Supported by the .NET Compact FrameworkUInt64An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615. 
Supported by the .NET Compact FrameworkVarNumericA variable-length numeric value. 
Supported by the .NET Compact FrameworkXmlA parsed representation of an XML document or fragment. 

The type of a parameter is specific to the .NET Framework data provider. Specifying the type converts the value of the Parameter to the data provider Type before passing the value to the data source. If the type is not specified, ADO.NET infers the data provider Type of the Parameter from the Value property of the Parameter object.

You can also generically specify the type of a Parameter by setting DbType property of a Parameter object. For more information, see Using Parameters with a DataAdapter.

Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

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

.NET Framework

Supported in: 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft