Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter.
[Visual Basic] <Serializable> Public Enum SqlDbType [C#] [Serializable] public enum SqlDbType [C++] [Serializable] __value public enum SqlDbType [JScript] public Serializable enum SqlDbType
| Member name | Description |
|---|---|
| BigInt
Supported by the .NET Compact Framework. |
Int64
A 64-bit signed integer. |
| Binary
Supported by the .NET Compact Framework. |
Array of type Byte
A fixed-length stream of binary data ranging between 1 and 8,000 bytes. |
| Bit
Supported by the .NET Compact Framework. |
Boolean
An unsigned numeric value that can be 0, 1, or a null reference (Nothing in Visual Basic). |
| Char
Supported by the .NET Compact Framework. |
String
A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| DateTime
Supported by the .NET Compact Framework. |
DateTime
Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
| Decimal
Supported by the .NET Compact Framework. |
Decimal
A fixed precision and scale numeric value between -1038 -1 and 10 38 -1. |
| Float
Supported by the .NET Compact Framework. |
Double
A floating point number within the range of -1.79E +308 through 1.79E +308. |
| Image
Supported by the .NET Compact Framework. |
Array of type Byte
A variable-length stream of binary data ranging from 0 to 231 -1 (or 2,147,483,647) bytes. |
| Int
Supported by the .NET Compact Framework. |
Int32
A 32-bit signed integer. |
| Money
Supported by the .NET Compact Framework. |
Decimal
A currency value ranging from -263 (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. |
| NChar
Supported by the .NET Compact Framework. |
String
A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters. |
| NText
Supported by the .NET Compact Framework. |
String
A variable-length stream of Unicode data with a maximum length of 230 - 1 (or 1,073,741,823) characters. |
| NVarChar
Supported by the .NET Compact Framework. |
String
A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Note 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. |
| Real
Supported by the .NET Compact Framework. |
Single
A floating point number within the range of -3.40E +38 through 3.40E +38. |
| SmallDateTime
Supported by the .NET Compact Framework. |
DateTime
Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute. |
| SmallInt
Supported by the .NET Compact Framework. |
Int16
A 16-bit signed integer. |
| SmallMoney
Supported by the .NET Compact Framework. |
Decimal
A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit. |
| Text
Supported by the .NET Compact Framework. |
String
A variable-length stream of non-Unicode data with a maximum length of 231 -1 (or 2,147,483,647) characters. |
| Timestamp
Supported by the .NET Compact Framework. |
Array 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. |
| TinyInt
Supported by the .NET Compact Framework. |
Byte
An 8-bit unsigned integer. |
| UniqueIdentifier
Supported by the .NET Compact Framework. |
Guid
A globally unique identifier (or GUID). |
| VarBinary
Supported by the .NET Compact Framework. |
Array of type Byte
A variable-length stream of binary data ranging between 1 and 8,000 bytes. Note 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. |
| VarChar
Supported by the .NET Compact Framework. |
String
A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| Variant
Supported by the .NET Compact Framework. |
Object
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. |
Namespace: System.Data
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework - Windows CE .NET
Assembly: System.Data (in System.Data.dll)