| Member Name |
Description |
| AnsiString |
A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| Binary |
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.
|
| Boolean |
A simple type representing Boolean values of true or false. |
| Byte |
An 8-bit unsigned integer. |
| Currency |
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. |
| Date |
Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
| DateTime |
A type representing a date and time value. |
| Decimal |
A simple type representing values ranging from 1.0 x 10-28 to approximately 7.9 x 10 28 with 28-29 significant digits. |
| Double |
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. |
| Guid |
A globally unique identifier ( or GUID ). |
| Int16 |
An integral type representing signed 16-bit integers with values between -32768 and 32767. |
| Int32 |
An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. |
| Int64 |
An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807. |
| Object |
A general type representing any reference or value type not explicitly represented by another TypeCode. |
| SByte |
An integral type representing signed 8-bit integers with values between -128 and 127. |
| Single |
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. |
| String |
A sealed class type representing Unicode character strings. |
| Time |
Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
| UInt16 |
An integral type representing unsigned 16-bit integers with values between 0 and 65535. |
| UInt32 |
An integral type representing unsigned 32-bit integers with values between 0 and 4294967295. |
| UInt64 |
An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615. |
| VarNumeric |
A variable-length numeric value ( OleDbParameter only ). This maps to Decimal. VarNumeric is not supported by the SQL Server™ .NET Provider. |
The type of a parameter is specific to the .NET data provider. Specifying the type converts the value of the Parameter to the .NET data provider Type before passing the value to the data source. If the type is not specified, ADO.NET infers the .NET data provider Type of the Parameter from the .NET Framework Type from the Value property of the Parameter object.
