problem while retrive image from database

Arul Selvan

15y3.4k.NET

Hi i stored image in database,i use these coding for bind a image in image control,

DL.OpenConnection();
SqlDataAdapter
DataSet
da.Fill(ds);
DataRow dr = ds.Tables[0].Rows[0];

byte[] bytes = (byte[])dr["Category_Image"];
Response.OutputStream.Write(bytes, 0, bytes.Length);

Response.End();
DL.CloseConnection();
this coding work correctly i already used another one application, it give output in web page
O÷öôRTZ¡Zd;§¦¥ïìçxy{™ššbhpÛ½ŒQ?3,&DCCÈ ‹lMŽcOîðñw\@ÞÝÚ†ƒ~d`]ÆÀ¸ÿÿÿ!ù,‹¸ÿÀŸpH,È¤rÉl:ŸÐ¨tJZ¯Ø¬vËíz¿à°ø˜ò) è4ZÁf›¾¸ÏÐR«Ûò~?Øõw€€)c‡G qm"igh™š™œŸ
like this binary values...

but this same coding i am used another one my web application it not give the correct output.it gives on page
System.Byte[]

what is the problem?
i used in this web application both c# and VB languages...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arul Selvan15y ago
















server side coding:
Da_Layer DL = new Da_Layer();
   protected void Page_Load(object sender, EventArgs e)
   {
   if (!IsPostBack)
   {
   string query = "select * from gallery";
   DataSet ds = DL.Grid(query);
   DataList1.DataSource = ds.Tables[0];
   DataList1.DataBind();
   }
   }

ImageHandler.ashx coding:

<%@ WebHandler Language="C#" Class="ImageHandler" %>

using System;
using System.Web;
using System.Data.SqlClient;

public class ImageHandler : IHttpHandler {
   Da_Layer DL = new Da_Layer();

   public void ProcessRequest (HttpContext context)
   {
   //context.Response.ContentType = "text/plain";

   //context.Response.Write("Hello World");

   string query = "select * from gallery where gname='"+context.Request.Params["id"]+"'";
   SqlDataReader dr = DL.ExecuteReader(query);

   dr.Read();

   Byte[] Imagedata = (byte[])dr["gphoto"];

   // context.Response.BinaryWrite(dr["gphoto"]);

   context.Response.BinaryWrite(Imagedata);

   dr.Close();


   }

   public bool IsReusable {
   get {
   return false;
   }
   }

}

hi this same coding i used another one application its work

but now it not working whats the problem,
Arul Selvan15y ago
Thanks friend but i want to bind image control inside grid view
dinamically
above coding worked another one application.
but now i am using But give output System.Byte[]
its not read binary values from database... whats the problem
i used in this application both c# and Vb
Amit Choudhary15y ago
Hi friend,

You need to specify the output stream type while sending it to the client.
for e.g.,
Image oImg = Image.FromFile(sPath + @"\images\" + sFileName,true);
oImg.Save(oContext.Response.OutputStream,ImageFormat.Jpeg);

Thanks.