Asp.net(c#)将数据库中以二进制存的图片显示出来

最新推荐文章于 2019-07-02 07:48:04 发布

原创最新推荐文章于 2019-07-02 07:48:04 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #数据库 #c# #dataset #image #database

ASP.NET VS Ajax 专栏收录该内容

42 篇文章

订阅专栏

这篇博客展示了如何在ASP.NET应用程序中，通过C#从数据库中检索以二进制形式存储的图片，并将其显示在网页上。在Page_Load事件中，连接到数据库并填充下拉列表，用户选择图片后，Button1_Click事件读取所选图片的二进制数据，转换为Bitmap对象，保存为本地文件并显示在Image控件上。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;
using System.Drawing;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            SqlConnection con = new SqlConnection("server=(local);user id=sa;pwd=;database=库名");
            SqlDataAdapter ada = new SqlDataAdapter("select * from tb_17 ", con);
            con.Open();
            DataSet ds = new DataSet();
            ada.Fill(ds);
            DropDownList1.DataSource = ds;
            DropDownList1.DataTextField = "字段";
            DropDownList1.DataValueField = "字段";
            DropDownList1.DataBind();
            Image1.Visible=false;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Image1.Visible = true;
        SqlConnection con = new SqlConnection("server=(local);user id=sa;pwd=;database=库名");
        string imagename = "";
        try
        {
            con.Open();
            SqlCommand com = new SqlCommand("select name from 表名 where 字段="+DropDownList1.Text+"", con);
            SqlDataReader dr = com.ExecuteReader();
            dr.Read();
            MemoryStream ms = new MemoryStream((Byte[])dr["name"]);
            Bitmap image = new Bitmap(ms);
            string filepath = Server.MapPath("Files/");
            DirectoryInfo dir = new DirectoryInfo(filepath);
            FileInfo[] filecount = dir.GetFiles();
            int i = filecount.Length;
            imagename = filepath + ((i + 1) + ".jpg");
            image.Save(imagename);
            dr.Close();
            Image1.ImageUrl = "Files/" + ((i + 1) + ".jpg");
        }
        finally
        {
            con.Close();
        }
    }
}