ADO 型別對應至 .NET Framework 型別
ADO Recordset 或 Record 物件中的值會轉換為 .NET Framework 型別,以儲存至 DataSet。下列表格顯示 ADO 型別對應至 .NET Framework 型別。
ADO 型別 | .NET Framework 型別 |
---|---|
adEmpty | Null |
adBoolean | Int16 |
adTinyInt | SByte |
adSmallInt | Int16 |
adInteger | Int32 |
adBigInt | Int64 |
adUnsignedTinyInt | 提升為 Int16 |
adUnsignedSmallInt | 提升為 Int32 |
adUnsignedInt | 提升為 Int64 |
adUnsignedBigInt | 提升為 Decimal |
adSingle | Single |
adDouble | Double |
adCurrency | Decimal |
adDecimal | Decimal |
adNumeric | Decimal |
adDate | DateTime |
adDBDate | DateTime |
adDBTime | DateTime |
adDBTimeStamp | DateTime |
adFileTime | DateTime |
adGUID | Guid |
adError | ExternalException |
adIUnknown | object |
adIDispatch | object |
adVariant | object |
adPropVariant | object |
adBinary | byte[] |
adChar | string |
adWChar | string |
adBSTR | string |
adChapter | 不支援 |
adUserDefined | 不支援 |
adVarNumeric | 不支援 |