KerryMoorman
Fri May 18 11:02:00 CDT 2007
Max,
I have always used the schema information for myself as a developer, so my
presentation usually just consists of displaying the data in a grid.
For your needs you might want to model your presentation on something like
SQL Server's Management Studio.
You could use a Treeview control in a pane on the left and a grid control in
a pane on the right to allow the user to view, navigate and interact with the
data.
Anything more sophisticated would really be turning into an
Entity-Relationship Diagramming application and that would be a considerable
undertaking.
Kerry Moorman
"send.me.all.email@googlemail.com" wrote:
> On 17 Mai, 15:10, Kerry Moorman
> <KerryMoor...@discussions.microsoft.com> wrote:
>
> >
http://support.microsoft.com/kb/309488
> >
> > I usually display the schema table info in a grid by binding the returned
> > table to a control like a datagridview.
>
> Thanks a lot for this hint, Kerry! Using the code presented in the
> knowledge base article I was able to read the basic schema
> information.
>
> Now that I have the schema information, the problem is visualizing it
> neatly in a GUI. Something like: Tables are depicted as boxes,
> containing the fields of the table as rows showing the name and type
> of the field. Fields acting as primary or foreign keys are specially
> marked. Relationships between tables are depicted as lines connecting
> the tables. The graphical representation should be used to enable the
> user to navigate the schema, select a table and perform basic
> operations on them.
>
> Which .NET framework could I use to realize such a graphical
> representation of the schema?
>
>
> Regards,
> Max
>
>