Store an image

[clara]

Hi all,

I am in a case that a image and some texts should be best saved as a record
into a
table and can be retrieved back in a win form. I am wondering how to do the
image operation with database both in Access and SQL Server2005.
Could you tell a outline?

Clara

 

[Guest]

I am wondering how to do the
image operation with database both in Access and SQL Server2005.
Could you tell a outline?

Store the image as a blob in the database. In SQL Sever 2005, create a
varbinary(max) column.

 

[Herfried K. Wagner [MVP]]

I am in a case that a image and some texts should be best saved as a
record
into a
table and can be retrieved back in a win form. I am wondering how to do
the
image operation with database both in Access and SQL Server2005.

How To Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;308042>

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and
Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;316887>

HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in
ADO.NET and Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;317034>

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;326502>