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

SqlDbType Enumeration

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

Members

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.

Requirements

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

Assembly: System.Data (in System.Data.dll)

See Also

System.Data Namespace

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.