ADO.NET中取得資料庫字段的資料類型

<b>ADO.NET</b><b>中的資料類型</b>

dim columnTypes(205)

columnTypes(0) = "Empty"

columnTypes(2) = "SmallInt"

columnTypes(3) = "Integer"

columnTypes(4) = "Real"

columnTypes(5) = "Double"

columnTypes(6) = "Currency"

columnTypes(7) = "Date"

columnTypes(8) = "BSTR"

columnTypes(9) = "IDispatch"

columnTypes(10) = "Error Code"

columnTypes(11) = "Boolean"

columnTypes(12) = "Variant"

columnTypes(13) = "IUnknown"

columnTypes(14) = "Decimal"

columnTypes(16) = "TinyInt"

columnTypes(17) = "Unsigned TinyInt (BYTE)"

columnTypes(18) = "Unsigned Small Int (WORD)"

columnTypes(19) = "Unsigned Int (DWORD)"

columnTypes(20) = "BigInt"

columnTypes(21) = "Unsigned Big Int"

columnTypes(64) = "FileTime"

columnTypes(72) = "Unique Identifier (GUID)"

columnTypes(128) = "Binary"

columnTypes(129) = "Char"

columnTypes(130) = "nChar"

columnTypes(131) = "Numeric"

columnTypes(132) = "User Defined (UDT)"

columnTypes(133) = "DBDate"

columnTypes(134) = "DBTime"

columnTypes(135) = "SmallDateTime"

columnTypes(136) = "Chapter"

columnTypes(138) = "Automation (PropVariant)"

columnTypes(139) = "VarNumeric"

columnTypes(200) = "VarChar"

columnTypes(201) = "Text"

columnTypes(202) = "nVarChar"

columnTypes(203) = "nText"

columnTypes(204) = "VarBinary"

columnTypes(205) = "Image"

    本文轉自永春部落格園部落格，原文連結：http://www.cnblogs.com/firstyi/archive/2006/11/17/563214.html，如需轉載請自行聯系原作者