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)

type DbType

Member nameDescription
Supported by the XNA FrameworkAnsiStringA variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
Supported by the XNA FrameworkBinaryA variable-length stream of binary data ranging between 1 and 8,000 bytes.
Supported by the XNA FrameworkByteAn 8-bit unsigned integer ranging in value from 0 to 255.
Supported by the XNA FrameworkBooleanA simple type representing Boolean values of true or false.
Supported by the XNA 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 XNA FrameworkDateA type representing a date value.
Supported by the XNA FrameworkDateTimeA type representing a date and time value.
Supported by the XNA 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 XNA 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 XNA FrameworkGuidA globally unique identifier (or GUID).
Supported by the XNA FrameworkInt16An integral type representing signed 16-bit integers with values between -32768 and 32767.
Supported by the XNA FrameworkInt32An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647.
Supported by the XNA FrameworkInt64An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807.
Supported by the XNA FrameworkObjectA general type representing any reference or value type not explicitly represented by another DbType value.
Supported by the XNA FrameworkSByteAn integral type representing signed 8-bit integers with values between -128 and 127.
Supported by the XNA 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 XNA FrameworkStringA type representing Unicode character strings.
Supported by the XNA FrameworkTimeA type representing a SQL Server DateTime value. If you want to use a SQL Server time value, use Time.
Supported by the XNA FrameworkUInt16An integral type representing unsigned 16-bit integers with values between 0 and 65535.
Supported by the XNA FrameworkUInt32An integral type representing unsigned 32-bit integers with values between 0 and 4294967295.
Supported by the XNA FrameworkUInt64An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615.
Supported by the XNA FrameworkVarNumericA variable-length numeric value.
Supported by the XNA FrameworkAnsiStringFixedLengthA fixed-length stream of non-Unicode characters.
Supported by the XNA FrameworkStringFixedLengthA fixed-length string of Unicode characters.
Supported by the XNA FrameworkXmlA parsed representation of an XML document or fragment.
Supported by the XNA FrameworkDateTime2Date and time data. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.
Supported by the XNA FrameworkDateTimeOffsetDate and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00.

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.

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

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

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

Community Additions

ADD
Show:
© 2014 Microsoft