.NET Framework Class Library
DbType Enumeration

Updated: November 2007

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)
Visual Basic (Declaration)
Public Enumeration DbType
Visual Basic (Usage)
Dim instance As DbType
C#
public enum DbType
Visual C++
public enum class DbType
J#
public enum DbType
JScript
public enum DbType
Member nameDescription
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifAnsiString A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifBinary A variable-length stream of binary data ranging between 1 and 8,000 bytes.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifByte An 8-bit unsigned integer ranging in value from 0 to 255.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifBoolean A simple type representing Boolean values of true or false.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifCurrency 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.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifDate A type representing a date value.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifDateTime A type representing a date and time value.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifDecimal A simple type representing values ranging from 1.0 x 10 -28 to approximately 7.9 x 10 28 with 28-29 significant digits.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifDouble A 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.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifGuid A globally unique identifier (or GUID).
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifInt16 An integral type representing signed 16-bit integers with values between -32768 and 32767.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifInt32 An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifInt64 An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifObject A general type representing any reference or value type not explicitly represented by another DbType value.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifSByte An integral type representing signed 8-bit integers with values between -128 and 127.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifSingle A 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.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifString A type representing Unicode character strings.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifTime A type representing a time value.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifUInt16 An integral type representing unsigned 16-bit integers with values between 0 and 65535.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifUInt32 An integral type representing unsigned 32-bit integers with values between 0 and 4294967295.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifUInt64 An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifVarNumeric A variable-length numeric value.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifAnsiStringFixedLength A fixed-length stream of non-Unicode characters.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifStringFixedLength A fixed-length string of Unicode characters.
fhkx04c4.CFW(en-us,VS.90).giffhkx04c4.xna(en-us,VS.90).gifXml A parsed representation of an XML document or fragment.
fhkx04c4.CFW(en-us,VS.90).gifDateTime2 Date 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.
fhkx04c4.CFW(en-us,VS.90).gifDateTimeOffset Date 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.

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, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360

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.

.NET Framework

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

.NET Compact Framework

Supported in: 3.5, 2.0, 1.0

XNA Framework

Supported in: 1.0
Page view tracker