<%@ WebHandler Language="C#" Class="ShowImage" %> using System; using System.Web; using System.Configuration; using System.Data; using System.Data.SqlClient; public class ShowImage : IHttpHandler { public void ProcessRequest (HttpContext context) { if (context.Request.QueryString["ProductId"] == null) return; string ProductId = context.Request.QueryString["ProductId"]; string connStr = ConfigurationManager.ConnectionStrings["ConnStr"].ToString(); using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand("SELECT Item FROM BookDetails WHERE ProductId = @ProductId", conn)) { cmd.Parameters.Add(new SqlParameter("@ProductId", ProductId)); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { reader.Read(); context.Response.BinaryWrite((Byte[])reader[reader.GetOrdinal("Item")]); reader.Close(); } } } } public bool IsReusable { get { return false; } } }
Login to post response