.NET工具浏览MDB数据库 [英] .NET tool for browsing MDB database
问题描述
我正在寻找一个解决方案,提供在我的WinForms应用程序MDB数据库查看功能。的目标是允许用户浏览表,列和行。任何开源或免费软件插件可用于此?
I'm looking for a solution to provide MDB database viewing capabilities in my WinForms application. The goal is to allow user browsing tables, columns and rows. Any open-source or freeware widget available for this?
推荐答案
我觉得你并不需要为这个特殊的小部件。
你可以做到这一点很容易自己,只能用内置.NET的东西,一点接入知识。
I think you don't need a special widget for this.
You can do it quite easily yourself, only with built-in .net stuff and a bit of Access knowledge.
1)浏览表(=获得所有现有的表的列表):
每一个MDB(至少是A2000和A2003,我从来没有使用A2007及以上)有一个名为隐藏的表 MSysObjects
。
它包含了所有对象(窗体和报表,以及例如),但你可以过滤对键入
栏只得到表:
类型= 1:本地表
类型= 6:链接表
1) Browsing tables (=getting a list of all existing tables):
Every MDB (at least A2000 and A2003, I have never used A2007 and above) has a hidden table named MSysObjects
.
It contains ALL objects (forms and reports as well, for example) but you can filter on the Type
column to get only the tables:
Type = 1 : local tables
Type = 6 : linked tables
2)显示一个表的内容:
只需将其加载到数据集,并在网格中显示出来。
2) Showing the content of one table:
Just load it into a DataSet and display it in a grid.
这篇关于.NET工具浏览MDB数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!