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

Images to database

Hi

I was hoping that someone could point me in the direction of some articles
on how to get images into a SQL Server database. I have an ASP.NET app where
I need to let the users upload images to the server (that's no problem), but
then I need to get the uploaded image into a table in SQL Server. I then
need to know how to get the binary data out ot the table in SQL & write it
back to the disk as an image file.

If anyone could point me in the right direction to read up on this I would
really appreciate it

TIA
Steve
Nov 18 '05 #1
2 1117
Here's a couple good tutorials on the subject for you:
http://www.aspnetpro.com/features/20...200307so_f.asp
http://aspalliance.com/das/tutorial/fileupload.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com
"Steve Peterson" <sp*******@arrakis.es> wrote in message
news:up****************@TK2MSFTNGP11.phx.gbl...
Hi

I was hoping that someone could point me in the direction of some articles
on how to get images into a SQL Server database. I have an ASP.NET app where I need to let the users upload images to the server (that's no problem), but then I need to get the uploaded image into a table in SQL Server. I then
need to know how to get the binary data out ot the table in SQL & write it
back to the disk as an image file.

If anyone could point me in the right direction to read up on this I would
really appreciate it

TIA
Steve

Nov 18 '05 #2
Thank you Steve for taking the time to reply.

However, the article you recommended:

http://www.aspnetpro.com/features/20...200307so_f.asp

requires a a log in ID at $39.95 for a subscription, which I'm not going to
fork over just to read one article (nice salesmanship try!)

the other:

http://aspalliance.com/das/tutorial/fileupload.aspx

is about how to upload files from the client to server, something I already
know how to do. What I need is know is how to get an image into SQL Server,
& how to get it back out...

Steve


"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:uu**************@TK2MSFTNGP12.phx.gbl...
Here's a couple good tutorials on the subject for you:
http://www.aspnetpro.com/features/20...200307so_f.asp
http://aspalliance.com/das/tutorial/fileupload.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com
"Steve Peterson" <sp*******@arrakis.es> wrote in message
news:up****************@TK2MSFTNGP11.phx.gbl...
Hi

I was hoping that someone could point me in the direction of some articles on how to get images into a SQL Server database. I have an ASP.NET app

where
I need to let the users upload images to the server (that's no problem),

but
then I need to get the uploaded image into a table in SQL Server. I then
need to know how to get the binary data out ot the table in SQL & write it back to the disk as an image file.

If anyone could point me in the right direction to read up on this I would really appreciate it

TIA
Steve


Nov 18 '05 #3

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

Similar topics

4
by: yawnmoth | last post by:
i have a script that accesses images on a fairly frequent basis, however, i'm thinking that it would be better to have them in an sql database, instead, for the same reason that it is generally...
3
by: Srdjan Pejic | last post by:
Hello, I have a problem that I have not been able to solve, even after searching the web. I have stored couple of images in the MySQL database and I am trying to get them displayed on a web page...
6
by: bissatch | last post by:
Hi, I am currently writing a news admin system. I would like to add the ability to add images to each article. What I have always done in the past is uploaded (using a form) the image to a...
3
by: Alan | last post by:
Hi, I'm converting a database application from Access 97 to C#/SQL Server. Old database contains some images in OLE fields. I've figured out that there's OLE header preceeding actual image data...
10
by: Neo Geshel | last post by:
I am seeking to hand-roll my own blog in ASP.NET 2.0 and SQLExpress 2005. Why? Because I can. Because I will gain experience. The one thing that has me stumped at square one is inline images....
9
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...
10
by: eholz1 | last post by:
Hello Members, I am setting up a photo website. I have decided to use PHP and MySQL. I can load jpeg files into the table (medium blob, or even longtext) and get the image(s) to display without...
3
by: najimou | last post by:
Hi everyone I will be having a split database, running on 2 computers via mapped drive. computer "A" will have one front end and the back end located in c: \mydatabse 2 tables have links to...
1
by: ttamilvanan81 | last post by:
Hai everyone, I need to provide the slideshow for the images. I have upload the images into database. Then i will retrive all the images from the database and provide the slideshow for those...
7
by: Keith Hughitt | last post by:
Hi all, I am having trouble preloading images in a javascript application, and was wondering if anyone had any suggestions. Basically I have a bunch of images stored in a database as BLOBs. At...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.