Images in SQL

  • Thread starter Thread starter Dharmen
  • Start date Start date
D

Dharmen

Once again Thanks William,
Even though the code is in VB, i will try to figure it out...

Is it possible to add a coloum to the database for images and then display
them in the same datagrid?

Thanks
-Seelan
 
Is it only possible to upload images to a database using webpage uploads?
When we create a database for text entries, we do it in the SQL Server
database itself. But is uploading to the specific table the only way to get
images in the database or is there a simple way to do it in the SQL Server
itself?

Thanks
 
Hi Seelan:

I'm not sure I understand the question but I'll take a stab at it. You need
to get the data into binary format and you can do what you want with it.
You could do this via a web service, a gui app or a whole host of other
ways. You are communicating with the DB over TCP/IP so that's going to be
the transfer mechanism. However you can break the image into binary, store
it in the db and reconstruct it later on. Or you can transfer the whole file
over FTP/HTTP/HTTPS etc and place it on the web server. From there you can
provide a file reference in the db and access the physical file that way.
So you have quite a few options here.

Does this answer it? If not, please let me know and I'll take another stab
at it.

Bill

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
 
Back
Top