ADO.NET中取得数据库字段的数据类型

简介:

ADO.NET中的数据类型

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,如需转载请自行联系原作者


相关文章
|
29天前
|
SQL 安全 数据库连接
使用ADO.NET访问数据库
使用ADO.NET访问数据库
10 0
|
9月前
|
SQL 存储 缓存
机房重构系列——ADO.NET访问数据库
机房重构系列——ADO.NET访问数据库
69 0
|
SQL 数据库
C#_使用ADO.NET实体模型与数据库进行快速连接
C#_使用ADO.NET实体模型与数据库进行快速连接,实现增、删、改、查操作
402 0
|
SQL .NET 数据库
一起谈.NET技术,使用LINQ to SQL更新数据库(上):问题重重
在学习LINQ时,我几乎被一个困难所击倒,这就是你从标题中看到的更新数据库的操作。下面我就一步步带你走入这泥潭,请准备好砖头和口水,Follow me。 从最简单的情况入手 我们以Northwind数据库为例,当需要修改一个产品的ProductName时,可以在客户端直接写下这样的代码: // Li...
1076 0