打印本文 打印本文 关闭窗口 关闭窗口
将图片插入数据库并使用asp.net读取出来的正确方法
作者:武汉SEO闵涛  文章来源:敏韬网  点击数4151  更新时间:2009/4/23 10:45:58  文章录入:mintao  责任编辑:mintao
           string type="jpeg";

           if(extension=="jpg")

           {

              type="jpeg";

           }else

           {

              type=extension;

           }

           return "image/"+type;

       }

    }

}

 

附录二:

ReadImage.aspx

<%@ Page language="c#" Codebehind="ReadImage.aspx.cs" AutoEventWireup="false" Inherits="ReadImage.ReadImage"%>

ReadImage.aspx.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

 

namespace ReadImage

{

    /// <summary>

    /// Summary description for ReadImage.

    /// </summary>

    public class ReadImage : System.Web.UI.Page

    {

       private void Page_Load(object sender, System.EventArgs e)

       {

           try{

              SqlConnection conn=new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DatabaseImage;Data Source=(local)");

              conn.Open();

 

              SqlCommand comm=conn.CreateCommand();

              comm.CommandText="select * from Images where id>@id";

              comm.CommandType=CommandType.Text;

 

              comm.Parameters.Add("@id", SqlDbType.BigInt).Value=int.Parse(Request["id"]);

 

              SqlDataReader reader=comm.ExecuteReader();

              while(reader.Read())

              {

                  Response.ContentType=reader["contentType"].ToString();

                  Response.BinaryWrite((byte[])reader["Image"]);

              }

              Response.Write("aaaaaa");

              Response.End();

 

              conn.Close();

           }

           catch

           {

              Response.End();

           }

       }

 

       #region Web Form Designer generated code

       override protected void OnInit(EventArgs e)

       {

           //

上一页  [1] [2] [3] [4] [5] [6]  下一页

打印本文 打印本文 关闭窗口 关闭窗口