picture from db to file

[Victor Rodriguez]

Is there a way to write a picture captured on an image column type on SQL
server database table to a file like c:\picture.gif?

thanks,

Victor

 

[Walter Wang [MSFT]]

Hi Victor,

Thank you for posting!

From your post, I assume you're trying to save a blob data to a file using
ADO.NET. Here's a kb article:
HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET
and Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316887

Hope this helps.

Regards,

Walter Wang
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Eliyahu Goldin]

Note, that if your final objective is to show the picture on a web page,
saving it in a file is not the way to go.

Eliyahu

 

[Hans Kesting]

Note, that if your final objective is to show the picture on a web page,

saving it in a file is not the way to go.

Eliyahu

And the C:\ is the disk of the (web)server, not the client ...

Hans Kesting