Uploading images in SQL

17 Nov 2005 10:18 AM

B

Hi,

How can I store images into my DB using VWD Express 2005 in VB.NET ?
Users can update/insert/delete text, but I would like to give the
possibility to update/insert/delete images as well.

Can someone help me?
Thanks,
B.

17 Nov 2005 10:53 AM

Miha Markic [MVP C#]

http://support.microsoft.com/default.aspx?scid=kb;en-us;308042
http://support.microsoft.com/default.aspx?scid=kb;en-us;321900

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"B" <B@discussions.microsoft.com> wrote in message
news:564F6089-3557-4AF9-BE57-83371D2D4DE8@microsoft.com...
> Hi,
>
> How can I store images into my DB using VWD Express 2005 in VB.NET ?
> Users can update/insert/delete text, but I would like to give the
> possibility to update/insert/delete images as well.
>
> Can someone help me?
> Thanks,
> B.

17 Nov 2005 3:34 PM

S.M. Altaf [MVP]

Miha's methods are good, but as an alternative, you can also store the
images on disk with the paths to the images in the database instead.

-Altaf

--------------------------------------------------------------------------------
All that glitters has a high refractive index.
www.mendhak.com

Show quote

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:OmzNNb26FHA.1188@TK2MSFTNGP12.phx.gbl...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;308042
> http://support.microsoft.com/default.aspx?scid=kb;en-us;321900
>
> --
> Miha Markic [MVP C#]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "B" <B@discussions.microsoft.com> wrote in message
> news:564F6089-3557-4AF9-BE57-83371D2D4DE8@microsoft.com...
>> Hi,
>>
>> How can I store images into my DB using VWD Express 2005 in VB.NET ?
>> Users can update/insert/delete text, but I would like to give the
>> possibility to update/insert/delete images as well.
>>
>> Can someone help me?
>> Thanks,
>> B.
>
>

17 Nov 2005 4:21 PM

Cor Ligthert [MVP]

Altaf,

In my opinion that is not an alternative, did you ever upload a real image
to a database. In my opinion is the most sufficient a thumbnail in a
database and the real image as you wrote.

:-)

Cor

18 Nov 2005 4:19 PM

Nandhu

hi,
We can store images in Sql server using Binary large object in Visual Basic
6.0

For More Details -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/BLOB.asp

We can laso use the same proc in VWD Express 2005 in VB.NET, i think so, but
not confident.

If u will get, Plz mail me - nandhu***@gmail.com
Regards,
Nanda Kumar.

Show quote

"B" wrote:

> Hi,
>
> How can I store images into my DB using VWD Express 2005 in VB.NET ?
> Users can update/insert/delete text, but I would like to give the
> possibility to update/insert/delete images as well.
>
> Can someone help me?
> Thanks,
> B.