How can I get database information, which is table name, column na

[Get the database infomation from the vis]

How can I get database information, which is table name, coulumn name and
etc..., from visio file.
I'm using Visual studio .net C#.
I'm import the visio com dll(visio type library)
I could get the shape infomation and master and page...
but I couldn't get the database information from the visio file.
the visio file is shown the database diagram.
please help me...
I want the sample source.

 

[Chris Roth [ Visio MVP ]]

Do you mean from a Visio Database diagram? Your question is not very clear.

As far as I know, the Database diagrams don't have a published API for
accesssing the meta-data of the drawing.

A lot of the information can be figured out by dissecting the diagram -
shapes have custom properties ( Shape.Cells("Prop.X").Formula / .Result ,
etc. ), and the connections can be traced as well ( Page.Connections,
Shape.Connections, cnnct.FromSheet, cnnct.ToSheet, etc. )

I believe the developers of the database diagram store their meta-data in a
COM object that lives inside of an invisible master in the document stencil
of the Database diagram. I'm not sure if this COM object can be
read/dissected/reverse-engineered or not, but you're welcome to try.

--

Hope this helps,

Chris Roth
Visio MVP


"Get the database infomation from the vis"