0x010007004454465320504D000000000000000000000000000000000000000000000000000000000000000000000000000000
public void ProcessRequest (HttpContext context) { if (context.Request.QueryString["machinenamedisplay"] == null) return; string connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString(); string machinenamedisplay = "SINGULATION # 2"; using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand("SELECT top 100 CCList from dbo.Obs_PMChkList_1 where machinenamedisplay = @machinenamedisplay", conn)) { cmd.Parameters.Add(new SqlParameter("@machinenamedisplay", machinenamedisplay)); conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { reader.Read(); context.Response.BinaryWrite((Byte[])reader[reader.GetOrdinal("CClist")]); reader.Close(); } } } } public bool IsReusable { get { return true; } }
string connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString(); DataTable table = new DataTable(); using (SqlConnection conn = new SqlConnection(connStr)) { string sql = "SELECT top 100 machinenamedisplay,CCList from dbo.Obs_PMChkList_1"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) { conn.Open(); ad.Fill(table); conn.Close(); } } } gvImages.DataSource = table; gvImages.DataBind();
<asp:GridView Width="500px" ID="gvImages" runat="server" AutoGenerateColumns="False" > <Columns> <asp:BoundField HeaderText = "machinenamedisplay" DataField="machinenamedisplay" /> <asp:TemplateField HeaderText="Image"> <ItemTemplate> <%--<img src="ImageHandler.ashx?machinenamedisplay=<%# Eval("machinenamedisplay").ToString() %>" width="150" height="100" />--%> <asp:Image runat="server" ID="pic1" ImageUrl='<%# "~/ImageHandler.ashx?machinenamedisplay=" + Eval("machinenamedisplay") %>'> </asp:Image> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)