Display Image from DataBase
-
Hi I'm actually developing a very simple WebForm in Visual Studio 2005 usign Web Developer. I have a table in SQL SERVER 2000 and Im trying to put the info into a GridView, When I tray to get the data from the columns "Name" and "Photo" from the SQL TABLE the GridView only displays the name and in the Photo Column displays a message like this: "System.Byte[]" instead of displaying the photo. CAN SOMEBODY HELP ME WITH THIS???? THANX Armando Ramírez Monterrey, MEXICO
-
Hi I'm actually developing a very simple WebForm in Visual Studio 2005 usign Web Developer. I have a table in SQL SERVER 2000 and Im trying to put the info into a GridView, When I tray to get the data from the columns "Name" and "Photo" from the SQL TABLE the GridView only displays the name and in the Photo Column displays a message like this: "System.Byte[]" instead of displaying the photo. CAN SOMEBODY HELP ME WITH THIS???? THANX Armando Ramírez Monterrey, MEXICO
hi there, You have to read the image from DB as binary stream and then stream it to browser. I'm pretty sure there are a lot of articles on this site Below is just one of them. ImageBinaryStream But for me, you should save image as physical file on hard disk and just store the path in SQL. This way is easier and faster, I think << >>
-
hi there, You have to read the image from DB as binary stream and then stream it to browser. I'm pretty sure there are a lot of articles on this site Below is just one of them. ImageBinaryStream But for me, you should save image as physical file on hard disk and just store the path in SQL. This way is easier and faster, I think << >>
Hey thanx ¡¡ sorry but eehm ...how do I store the path in SQL ??¡¡
-
Hey thanx ¡¡ sorry but eehm ...how do I store the path in SQL ??¡¡
hi there,
Armando_Ramirez wrote:
how do I store the path in SQL ??¡¡
I mean that path where u store images (e.g: there is an image stored at images\pic01.jpg, so u will store the string "images\pic01.jpg" into DB) << >>
-
hi there,
Armando_Ramirez wrote:
how do I store the path in SQL ??¡¡
I mean that path where u store images (e.g: there is an image stored at images\pic01.jpg, so u will store the string "images\pic01.jpg" into DB) << >>
OOH RIGHT ¡¡¡ It really works this way... I saved my pictures in my server and wrote the path in the SQL TABLE COLUMN ...i still prefer to retrieve the picture and its name saved in the table 'cause I have allready developed an application for upload images to a SQL DB and I wish to use it THANX FOR UR TIME ¡¡¡