We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info
Developer Fusion » Miscellaneous » User Comments » [5223] Using ASHX files to retrieve DB images

[5223] Using ASHX files to retrieve DB images

Last post 05-09-2007 10:29 AM by fakhruddins128. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 01-01-1999 12:00 AM

    [5223] Using ASHX files to retrieve DB images

    Reply Contact

    This thread is for discussions of Using ASHX files to retrieve DB images.
    • Post Points: 20

  • 04-22-2006 7:00 PM In reply to

    • semma
    • Not Ranked
    • Joined on 04-22-2006
    • United States
    • New Member
    • Points 5

    Re: [5223] Using ASHX files to retrieve DB images - Modified - Download PDF stored in SQL Server Database

    Reply Contact

    Thank you, thank you, thank you!  

    For those gurus out there, I hope I am not gushing too much.  I have been working for a week trying to find out how to get a pdf out of sql server in asp.net 2.0.  I made one small code tweak to the above and it worked flawlessly!!!  Thanks Again.... I'll buy the beer next time you are in Massachusetts!!!! 

    Here's my tweak:  I just call the page with http://mysite.com/handler.ashx?id=xxx  and viola!

    <%

    @ webhandler language="C#" class="NWEmpPhotoHandler" %>

    using

     System;

    using

     System.Web;

    using

     System.Data;

    using

     System.Data.SqlClient;

    public

     class NWEmpPhotoHandler : IHttpHandler

    {

    public bool IsReusable { get { return true; } }

    public void ProcessRequest(HttpContext ctx)

    {

    string id = ctx.Request.QueryString["id"];

    SqlConnection con = new SqlConnection("Data Source=server;Initial Catalog=schema;Persist Security Info=True;User ID=userid;Password=password");

    SqlCommand cmd = new SqlCommand("SELECT Image FROM mytable WHERE DocID = @DocID", con);

    cmd.CommandType =

    CommandType.Text;

    cmd.Parameters.Add(

    "@DocID", id);

    con.Open();

    byte[] pict = (byte[])cmd.ExecuteScalar();

    con.Close();

    ctx.Response.ContentType =

    "application/pdf";

    // ctx.Response.OutputStream.Write(pict, 78, pict.Length - 78);

    ctx.Response.BinaryWrite(pict);

    }

    }

     
    • Post Points: 5

  • 11-13-2006 4:33 PM In reply to

    • kidsonk
    • Not Ranked
    • Joined on 11-13-2006
    • New Member
    • Points 5

    Re: [5223] Using ASHX files to retrieve DB images

    Reply Contact

    Brilliant piece of code - and is far faster than a standard aspx page

    If a suggestion is in order - a trap to see if a value is returned and if not, to show a blank image ( thus not showing the broken image link

    if (pict.Length > 0){
            ctx.Response.ContentType = "image/jpeg";
            ctx.Response.OutputStream.Write(pict,0,pict.Length);
          }
     else {
       Image pict2 = Image.FromFile("C:\\somedirectory\\blankimage.gif");
      ctx.Response.ContentType="image/jpeg";
      pict2.Save(ctx.Response.OutputStream,System.Drawing.Imaging.ImageFormat.Jpeg);






    }

    This however bombs out on pict.Length if no id is supplied - any suggestions ??
    • Post Points: 5

  • 05-09-2007 10:29 AM In reply to

    Re: [5223] Using ASHX files to retrieve DB images

    Reply Contact

    Hi

    I read your post its realy nice. kindly explan how to pass ID with <img> or <asp:image>

     

     
    • Post Points: 5
Page 1 of 1 (4 items)