2.2.1 .NET Framework Types for DataColumn Objects
The following types are specified in [MS-DTYP] (introduced in the Microsoft .NET Framework 1.0).
Object Boolean
Byte
Int8
Int16
Int32
Int64
Uint16
Uint32
Double
String
The following types are specified in [MS-NRBF] (introduced in the .NET Framework 1.0).
Single
TimeSpan
DateTime
Decimal
The following table describes additional types that the DataSet object can use. Further information about how values are serialized is specified in section 2.2.3.
Type name |
Description |
.NET Framework introduction |
---|---|---|
System.Uri |
A resource that is available to the application on the intranet or Internet. |
.NET Framework 1.0 |
System.Guid |
A GUID. A GUID is a 128-bit integer (16 bytes) that can be used across all computers and networks wherever a unique identifier is required. |
.NET Framework 1.0 |
System.DateTimeOffset |
A point in time, typically expressed as a date and time of day, relative to Coordinated Universal Time (UTC). |
Microsoft .NET Framework 3.5 |
System.Numerics.BigInteger |
An unbounded integer. |
Microsoft .NET Framework 4.0 |
System.Data.SqlTypes.SqlBinary |
A variable-length stream of binary data to be stored in or retrieved from a database. |
Microsoft .NET Framework 2.0 |
System.Data.SqlTypes.SqlBoolean |
An integer value, either 1 or 0, to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlByte |
A variable-length stream of bytes to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlChars |
A variable-length stream of chars to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlDateTime |
The date and time data - ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds - to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlDecimal |
A numeric value, between - 10^38 +1 and 10^38 - 1, with fixed precision and scale. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlDouble |
A floating-point number within the range of -1.79E +308 through 1.79E +308 to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlGuid |
See System.Guid in this table. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlInt16 |
A 16-bit signed integer to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlInt32 |
A 32-bit signed integer to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlInt64 |
A 64-bit signed integer to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlMoney |
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 currency unit, to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlSingle |
A floating point number, within the range of -3.40E +38 through 3.40E +38, to be stored in or retrieved from a database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlString |
A variable-length stream of characters to be stored in or retrieved from the database. |
.NET Framework 2.0 |
System.Data.SqlTypes.SqlXml |
XML data stored in or retrieved from a server. |
.NET Framework 2.0 |