How to Save Image in a SQL-Server DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello all,

iam making a library system, which requires to save a image of titles in
the database. i did came to know how to open an image but i'll b happy if i
can be well assisted on how to save the image to a db.

and one thing more, is there any way to add images to the menu in vb.net !!


Thanks in advance
 
What your talking about is something called a BLOB, or a binary large
Object. Usually, most people recommend storing images on the file system -
and some reference to the image in the actual database, rather than the
image itself as BLOBs can add load to your DB that you might not actually
need.

There is a good read here that will help you get your head round binary
objects
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

Someone (as usual) has done much of the hard work for you already - take a
read of this.
http://dotnetjunkies.com/WebLog/abraham.mathew/articles/39751.aspx

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director
 
hello again,

thanks for those articles, surely they did give me an insight, but still i
would like to have an eg. actually the line where iam saving the image is
something like this

mrow("image") = picture1.image.

can u be with some example !!

thanks in advance,
 
Back
Top