Export (0) Print
Expand All
Expand Minimize
7 out of 9 rated this helpful - Rate this topic

SqlDbType Enumeration

Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter.

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

public enum SqlDbType
public enum SqlDbType
public enum SqlDbType
 Member nameDescription
Supported by the .NET Compact FrameworkBigIntInt64. A 64-bit signed integer. 
Supported by the .NET Compact FrameworkBinaryArray of type Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes. 
Supported by the .NET Compact FrameworkBitBoolean. An unsigned numeric value that can be 0, 1, or a null reference (Nothing in Visual Basic). 
Supported by the .NET Compact FrameworkCharString. A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters. 
Supported by the .NET Compact FrameworkDateTimeDateTime. Date 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 FrameworkDecimalDecimal. A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1. 
Supported by the .NET Compact FrameworkFloatDouble. A floating point number within the range of -1.79E +308 through 1.79E +308. 
Supported by the .NET Compact FrameworkImageArray of type Byte. A variable-length stream of binary data ranging from 0 to 2 31 -1 (or 2,147,483,647) bytes. 
Supported by the .NET Compact FrameworkIntInt32. A 32-bit signed integer. 
Supported by the .NET Compact FrameworkMoneyDecimal. 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. 
Supported by the .NET Compact FrameworkNCharString. A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters. 
Supported by the .NET Compact FrameworkNTextString. A variable-length stream of Unicode data with a maximum length of 2 30 - 1 (or 1,073,741,823) characters. 
Supported by the .NET Compact FrameworkNVarCharString. A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters. 
Supported by the .NET Compact FrameworkRealSingle. A floating point number within the range of -3.40E +38 through 3.40E +38. 
Supported by the .NET Compact FrameworkSmallDateTimeDateTime. Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute. 
Supported by the .NET Compact FrameworkSmallIntInt16. A 16-bit signed integer. 
Supported by the .NET Compact FrameworkSmallMoneyDecimal. A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit. 
Supported by the .NET Compact FrameworkTextString. A variable-length stream of non-Unicode data with a maximum length of 2 31 -1 (or 2,147,483,647) characters. 
Supported by the .NET Compact FrameworkTimestampArray of type Byte. Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes. 
Supported by the .NET Compact FrameworkTinyIntByte. An 8-bit unsigned integer. 
Supported by the .NET Compact FrameworkUdtA SQL Server 2005 user-defined type (UDT). 
Supported by the .NET Compact FrameworkUniqueIdentifierGuid. A globally unique identifier (or GUID). 
Supported by the .NET Compact FrameworkVarBinaryArray of type Byte. A variable-length stream of binary data ranging between 1 and 8,000 bytes. Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes. 
Supported by the .NET Compact FrameworkVarCharString. A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. 
Supported by the .NET Compact FrameworkVariantObject. A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared. 
Supported by the .NET Compact FrameworkXmlAn XML value. Obtain the XML as a string using the GetValue method or Value property, or as an XmlReader by calling the CreateReader method. 

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.