VISIO 2007 Database save

[RB]

I have linked database to data shapes on VISIO diagram. I am looking for an
option where I can update data on data shapes and VISIO can automatically
update data in database. I am able to view data from database on my VISIO
shapes using data linking but having problems sending data from data shapes
to database ?

Please help.

 

[Al Edlund]

The normal path for data linking is one way, i.e. you update the data source
for the linked shapes and then do a refresh. To roundtrip data you need to
use custom code.
al

 

[RB]

Thanks Al for the response, can you guide me where I can get the code for
save operation. I am a java programmer with little to no knowledge about C#.

 

[Al Edlund]

Well, we're both in the same dilema since I don't do C# either. I'd start
with the visio sdk from msdn.

The general flow would be
need an event routine to capture the shape formula changes
either
xml can be used to update the datarecordset in the document and
forward to database
update database directly

al

 

[David Parker]

I do have a small VBA code example in my Conf presentation that uses ADO to
save data :
http://bvisual.spaces.live.com/blog/cns!3350D61BC93733A9!277.entry