Return to Snippet

Revision: 5669
at March 24, 2008 21:36 by rengber


Initial Code
protected void Page_Load(object sender, EventArgs e)
    {
        string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ProductCatalogueConnectionString"].ConnectionString; 
        SqlConnection conn = new SqlConnection(connStr);
        string blobId = Request.QueryString["ID"];
        if (!string.IsNullOrEmpty(blobId))
        {
            string cmdText = "select A.blob from Core.Attachment A where A.AttachmentID = '" + blobId + "'";
            conn.Open();
            SqlCommand cmd = new SqlCommand(cmdText, conn);
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            if (reader.Read())
            {
                byte[] imgBytes = (byte[])reader["blob"];
                Response.ContentType = "image/jpeg";
                Response.BinaryWrite(imgBytes);
            }
        }
    }

Initial URL


Initial Description


Initial Title
ASP.Net Page to Return an Image from an SQL Blob Query

Initial Tags
sql, image, c, aspnet

Initial Language
C#