writing images from SQL in a table...

writing images from SQL in a table...

• Netjunkie

  They are stored at SQL Server, I think that the way you said works...

  Thanks...I have these codes already, I'm not at work right now so tomorrow I'm gonna test...and post here the answer

  Thanks a lot

  PS: I haven't thought in this option...lol

  
  
  

• Jocky

  Can you give me an example, I understood,but I just doesn't know how can I get the html from the page that I resquest and print it with the image

  Thanks for helping me

  
  
  

• Mark W.

  For good example have a look at Personal Starter Kit 2005 .
  

• Hakatom

  Hi,

  It worked, but instead of print the image it's printing System.Byte[]

  Any Idea

  Here is the code...

  try
  {
  IDataReader dr=cons.consulta_imagem(Request.QueryString["cod"].ToString());
  dr.Read();
  string tipo=dr["Tipo"].ToString();
  byte[] images=(byte[]) dr["Imagem"];
  int tamanho=Convert.ToInt32(dr["Tamanho"].ToString());
  dr.Close();
  Response.Clear();
  Response.Buffer = true;
  Response.Charset = "";
  Response.ContentType = tipo;
  Response.OutputStream.Write(images, 0, tamanho);
  Response.End();
  }
  catch(Exception err){
  Response.Write("<img src='imagens/noimage.jpg' border=0>");
  Response.End();
  }

  
  
  

• Srikanth_mr

  Wait. Actually, after reading your initial post, I might have said things incorrectly.
  
  Where are these images stored again
  
  
  

• puppalag

  what you'll need to do is make additional http requests to another file that will retrieve the binary from SQL Server, and stream it back to the client. That's the way of the image rendering in web browsers.
  
  
  

• Elan

  in the table, you'd do <img src="http://yourdomain.com/image.aspx id=12345" border="0" />
  
  your image.aspx page will get the id, and retrieve the binary from the database. You change the content type, and forward the byte to the output stream. I don't have code readily available to do that on this machine, but I believe it's all over google.com
  
  
  
• writing images from SQL in a table...