山本

导航

把图片在数据库中读出来并显示在页面上

   这个前台没有代码,我是在后台用代码从数据库里把图片读出来显示在页面上的,

百度了半天,也没看懂网上的是什么意思,只好自己弄了,

效果出来之后需要自己设置图片的显示大小,要不然在界面上显示的乱七八糟的

namespace FriendWeb
{
    public partial class pic : System.Web.UI.Page
    {
        public System.Drawing.Image SetByteToImage(byte[] mybyte)
        {
            System.Drawing.Image image; MemoryStream mymemorystream = new MemoryStream(mybyte, 0, mybyte.Length);
            image = System.Drawing.Image.FromStream(mymemorystream);
            return image;
        }
       int i=0;
        protected void Page_Load(object sender, EventArgs e)
        {         
          if (!Page.IsPostBack)
            {
                using (SqlConnection conn = new SqlConnection())
                {
                    conn.ConnectionString = "data source=QZC-PC;initial catalog=student;User Id=sa;password=123";
                    string strSql = "select FIamge from boke";
                    using (SqlCommand cmd = new SqlCommand(strSql, conn))
                    {
                        conn.Open();
                      
                        using (SqlDataReader reader = cmd.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                i++;
                                System.Drawing.Image img = SetByteToImage((Byte[])reader["FIamge"]);

                                img.Save(Server.MapPath("~/upload")+"/" + i.ToString() + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
                               
                                //string jpg = Server.MapPath("~/upload") + "\\" + i.ToString() + ".jpg";
                                string jpg = "upload/"+i.ToString() + ".jpg";
                               Response.Write("<img src='"+jpg+"' />");

                            }
                        }
                    }
                }
                //Response.End();
                //reader.Close();
            } 
        }
    }
}

posted on 2013-01-04 21:58  高级菜鸟  阅读(499)  评论(0编辑  收藏  举报