Database` image` field type & excel as OLE obj. stored in

[ciruliz ciruliz]

In Excel there is one greate feature - I can create table with ole
object field type & put excel document [workbook] in it, then in table
view when double-clicking on that field , excel document opens in excel
window [with update button, no `save` -- no temp files created -
directly linked to database]

how can i do this in VB.NET ?

I've found in Ms Access macros , I can do this with ole container
object, launching external excel from it automatically. but there is no
ole support in VB.NET. Any ideas?

P.S. using MS SQL server with 'image' as field type.

Thx a lot!

 

[Paul Clement]

¤ In Excel there is one greate feature - I can create table with ole
¤ object field type & put excel document [workbook] in it, then in table
¤ view when double-clicking on that field , excel document opens in excel
¤ window [with update button, no `save` -- no temp files created -
¤ directly linked to database]
¤
¤ how can i do this in VB.NET ?
¤
¤ I've found in Ms Access macros , I can do this with ole container
¤ object, launching external excel from it automatically. but there is no
¤ ole support in VB.NET. Any ideas?
¤
¤ P.S. using MS SQL server with 'image' as field type.

No native .NET control available. You have to use the Webbrowser control and it only works from a
file.

How To Use the WebBrowser Control to Open an Office Document in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;304643


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)