asp.net 读取数据库二进制图片

最新推荐文章于 2020-09-20 13:19:13 发布

置顶 fxh_hua

最新推荐文章于 2020-09-20 13:19:13 发布

阅读量1k

点赞数

分类专栏： C#学习笔记文章标签： asp.net 数据库 byte class string c#

本文链接：https://blog.csdn.net/fxh_hua/article/details/4369020

版权

C#学习笔记专栏收录该内容

26 篇文章 1 订阅

订阅专栏

GetImage.ashx

<%@ WebHandler Language="C#" Class="GetImage" %>

using System;
using System.Web;
using System.Data.SqlClient;
using System.Data.Sql;

public class GetImage : IHttpHandler {
public void ProcessRequest (HttpContext context) {

         using (SqlConnection sc = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
         {
             sc.Open();
             String txtsql = "select photo from employees where employeeid=" + context.Request.QueryString["eid"];
             SqlCommand scd = new SqlCommand(txtsql, sc);

context.Response.Clear();
context.Response.ContentType = "image/bmp";

byte[] bitmapBytes = (byte[])scd.ExecuteScalar();
int length = bitmapBytes.Length;

             context.Response.OutputStream.Write(bitmapBytes, 78, bitmapBytes.Length - 78);
             context.Response.Cache.SetCacheability(HttpCacheability.Public);
         }

         context.Response.End();
    }
    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}