473,327 Members | 1,936 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,327 software developers and data experts.

Picture in database

Can i put picture in sql server database but not filename and path. I want
to put complete picture in field in database. Is it possible?
Dec 28 '06 #1
2 3004
Igor (ig**@nesalji.hr) writes:
Can i put picture in sql server database but not filename and path. I want
to put complete picture in field in database. Is it possible?
Yes, this is possible. If you are on SQL 2005 use the varbinary(MAX)
datatype, if you are on SQL 2000 you need to use the image data type.
"image" is on SQL 2005 as well, but is deprecated.

I have a very simple example on how to work with blobs (binary large
objects) through ADO .Net on http://www.sommarskog.se/blobload.txt.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 28 '06 #2

"Erland Sommarskog" <es****@sommarskog.seha scritto nel messaggio
news:Xn**********************@127.0.0.1...
Igor (ig**@nesalji.hr) writes:
Can i put picture in sql server database but not filename and path. I
want
to put complete picture in field in database. Is it possible?

Yes, this is possible. If you are on SQL 2005 use the varbinary(MAX)
datatype, if you are on SQL 2000 you need to use the image data type.
"image" is on SQL 2005 as well, but is deprecated.

I have a very simple example on how to work with blobs (binary large
objects) through ADO .Net on http://www.sommarskog.se/blobload.txt.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Talking about pictures, I saw you from your website came in Italy in 2006
....
did you like it?
greetings from Milan

Jan 10 '07 #3

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

Similar topics

1
by: Tamer Sabry | last post by:
Hi, I am making a real estate database for my company. I am new to access. I made a picture field and I want to have different pictures for every record. My problem is no matter if I have an OLE...
2
by: Ulrike | last post by:
I need to bind in (thumbnail-sized) pictures into an Access Database in such a way that there is one picture for each record (abt. 3000 records on the whole). Ideally, the pictures should show on...
2
by: Lyn | last post by:
I am trying to embed a picture into a Bound Object Frame (Me!Photograph) with the following code which is based on MS article http://support.microsoft.com/?id=158941: strPathname =...
1
by: Amr Moselhy | last post by:
Hi Everyone i m trying to create a crystal report that contains a picture and this picture differs according to certain database information . the name of the picture to be included in the report...
4
by: NASAdude | last post by:
I'm working on distributing a database using VS Tools for Office, and am having trouble with linked images on forms/reports. The image objects have a default path\file set on the .Picture property,...
6
by: Jeff | last post by:
Hey (and thank you for reading my post) In visual web developer 2005 express edition I've created a simple website project.. At this website I want users who register to be able to upload a...
3
by: abspring | last post by:
Hi I am a technology teacher/support person at an elementary school. I have created a database in which I need to insert a picture for each of our 650+ students. I have a table of student...
1
by: mclewell | last post by:
I would like to start off by saying i'm in no way an expert by any means. I've had access since 97 and way back then set up a database for eBay stock. i had the old micrografx picture publisher...
1
by: davidwelli | last post by:
Hello, I have a Access 200 format database that contains contact details and a picture for each record. The contact details are held in one table and the images are held in another as OLE...
1
oranoos3000
by: oranoos3000 | last post by:
hi i make a shopping online that in home page i show my product picture's to user (information product's such as address location of picture and name and the other properties is kept in database my...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.