public class DisplayImage : IHttpHandler { string constring = ConfigurationManager.ConnectionStrings["AMTConnectionString"].ConnectionString; public void ProcessRequest(HttpContext context) { string ImageID = context.Request.QueryString["Sampleid"]; SqlConnection conn = new SqlConnection(constring); conn.Open(); SqlCommand cmd = new SqlCommand("select image from solids where sampleid=" + ImageID, conn); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); context.Response.BinaryWrite((Byte[])dr[0]); conn.Close(); context.Response.End(); } public bool IsReusable { get { return false; } } } ASPX page: <div> <asp:GridView ID="ImageGrid" runat="server" AutoGenerateColumns="False"> <columns> <asp:TemplateField HeaderText="Image"> <itemtemplate> <asp:Image ID="Image1" runat="server" ImageUrl='<%# "ImageHandler.ashx?ImageID="+ Eval("SampleID") %>' Height="150px" Width="150px"/> </itemtemplate> </columns> </div>
public partial class SolidsDetail : System.Web.UI.Page { string constring = ConfigurationManager.ConnectionStrings["AMTConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { Image(); } private void Image() { string ImageID = Request.QueryString["Sampleid"]; SqlConnection conn = new SqlConnection(constring); SqlCommand cmd = new SqlCommand("SELECT * from solids where sampleid =" + ImageID, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ImageGrid.DataSource = dt; ImageGrid.DataBind(); } }
83, 121, 115, 116, 101, 109, 46, 66, 121, 116, 101, 91, 93
System.Byte[]
TextBox17
ImageHandler.ashx
src
DisplayImage
class="..."
<%@ WebHandler ... %>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)