473,404 Members | 2,170 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

How to Save Image in a SQL-Server DB

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


Jul 21 '05 #1
2 1632
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/d...rt3/c1161.mspx

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

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"Sincere" <Si*****@discussions.microsoft.com> wrote in message
news:D9**********************************@microsof t.com...
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

Jul 21 '05 #2
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,
Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Clay Beatty | last post by:
When you create database diagrams in Enterprise Manager, the details for constructing those diagrams is saved into the dtproperties table. This table includes an image field which contains most of...
0
by: F. Hall | last post by:
If I read a bitmap image from one file and save it to another the save operation is slow unless I draw on the image. In other words, Image inputImage = Image.FromFile( @"c:\temp\source.bmp" );...
5
by: George | last post by:
This program need to draw the some triangles into a 512 × 512 buffer (in memory). Or save it to a file. #include "project3.h" Image::Image(int xres, int yres): xres(xres), yres(yres) {...
0
by: prakash | last post by:
Dear Friends I am new guy to Visual C++.NET I've program to save website as a image vc++.net . It have a function "SaveSnapshot" to save the webpage as an image On that function ifor saving...
3
by: Hardik Shah | last post by:
Hi, I want to save photograph of the customer to sql database, is there any sample data base , any hints for storing image in SQL. Thanks in advance. Hardik Shah
1
by: liuliuliu | last post by:
hi -- sorry if this is trivial -- but how do you make a screenshot of a pygame display? i have a surface which is basically the entire visible screen -- how do you write this surface as an image...
3
by: =?Utf-8?B?Um9nZWxpbw==?= | last post by:
I'm having the wierdest problem. I'm trying to save images into a SQL 2005 database. the field is just called "IMAGES" and hte data type is "image". here is my code to save //following code...
1
by: dodgeyb | last post by:
Hi there, Trying to allow client to upload image, thumbnail it, and save it into sql table image field. Code compiles & runs but image cannot be retrieved. any clues what I'm doing wrong pls ! ...
1
by: kiekar | last post by:
Hello, A yes or no answer would be much appreciated. I have a word document which has a sqlxml annotated schema mapped to it. On the word document there is a image inserted to it. Is it possible...
0
by: hnpatel | last post by:
hello friends, i m making application in vb.NET. i m using MY SQL 5.0 and vs 2005 for this application. Now I want to save image file in sql database. i m using blob datatype of image field. i...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.