asp.net中如何获取access数据库中表的每个字段说明信息

[uheart]

谢谢

[wwwwb]

用ADOX：VBA示例，你可以修改为你的代码：
Dim MyTableName As String
Dim MyFieldName As String

MyTableName = "rrrr"
MyFieldName = "id"

Dim MyDB As New ADOX.Catalog
Dim MyTable As ADOX.Table
Dim MyField As ADOX.Column

MyDB.ActiveConnection = CurrentProject.Connection
Set MyTable = MyDB.Tables(MyTableName)
MsgBox MyTable.Columns(MyFieldName).Properties("Description")

[wwwwb]

or
Dim MyTableName As String
Dim MyFieldName As String

MyTableName = "rrrr"
MyFieldName = "id"

Dim MyDB As New ADOX.Catalog
Dim MyTable As ADOX.Table
Dim MyField As ADOX.Column

MyDB.ActiveConnection = CurrentProject.Connection
Set MyTable = MyDB.Tables(MyTableName)
MsgBox MyTable.Columns(MyFieldName).Properties("Description")
For Each ff In MyTable.Columns
MsgBox ff.Properties("Description")
Next

[uheart]

up

[wwwwb]

ADO部份在各个语言中的写法及用法没有多大变化，你要修改的只有几句代码。

[uheart]

http://community.csdn.net/Expert/topic/4864/4864063.xml?temp=.3895075
有了解答 不过还是有问题没解决 !-_-帮看看

[OracleRoob]

用DAO和ADOX都可以实现。