Store an image

[=?Utf-8?B?Y2xhcmE=?=]

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
--

--
thank you so much for your help

[Spam Catcher]

Re: Store an image

=?Utf-8?B?Y2xhcmE=?= <clara@discussi ons.microsoft.c omwrote in
news:FFB4B6D3-1AED-4843-A8ED-4DFEE345DFCC@mi crosoft.com:

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.

--
spamhoneypot@ro gers.com (Do not e-mail)

[Herfried K. Wagner [MVP]]

Re: Store an image

"clara" <clara@discussi ons.microsoft.c omschrieb:

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.microso ft.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.microso ft.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.microso ft.com/?scid=kb;EN-US;317034>

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

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>