PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 1.00 average.

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

 
 
ciruliz ciruliz
Guest
Posts: n/a
 
      10th Aug 2004
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!
 
Reply With Quote
 
 
 
 
Paul Clement
Guest
Posts: n/a
 
      10th Aug 2004
On Tue, 10 Aug 2004 10:43:10 +0300, ciruliz ciruliz <(E-Mail Removed)> wrote:

¤ 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...b;en-us;304643


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
show image stored in database Mike P Microsoft C# .NET 2 3rd Sep 2009 10:49 AM
trouble displaying image stored in database Jeff Microsoft ASP .NET 6 2nd Oct 2008 08:59 PM
why do I get an 'invalid parameter' error when I read a field stored image type ? =?Utf-8?B?Y3liZXJmb3gyMDAy?= Microsoft ADO .NET 0 1st May 2004 01:46 PM
View Jpg image stored in a MS SQL Image field Geoff Microsoft Access Form Coding 1 18th Nov 2003 08:20 AM
How to get an image from an OLE Object type field of an Access database ? Sandi Microsoft ADO .NET 2 6th Nov 2003 09:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:38 AM.