日期:2014-05-18 浏览次数:20473 次
读取图片
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Drawing;
using System.Drawing.Imaging;
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.IO;
using System.Data.SqlClient;
using MySql.Data.MySqlClient;
public partial class Default2 : System.Web.UI.Page
{
MySqlConnection conn = new MySqlConnection(System.Configuration.ConfigurationManager.AppSettings["conmy"]);
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
this.show();
}
}
public void show()
{
string ss = Request.QueryString["id"].ToString();
string s3 = "select * from imgpic where id=" + ss;
MySqlCommand comm = new MySqlCommand(s3, conn);
conn.Open();
MySqlDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
while(dr.Read())
{
Response.Clear();
Response.C;
Response.BinaryWrite((byte[])dr["myimg"]);//读取
}
Response.End();
conn.Close();
}
}
注意图片显示要在另一张页面中
在你要显示的页面添加img 控件src="显示你图片的页面";
122058662 最后编辑于 2008-04-22 09:59:24
------解决方案--------------------
在showImg.aspx中写代码
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
上面是引用
protected void Page_Load(object sender, EventArgs e)
{
// 在此处放置用户代码以初始化页面
连接数据库读取数据-----------------
SqlDataReader Dr = data.GetDataReader(sql);
if (Dr != null)
{
while (Dr.Read())
{
if (Dr[0] != null)
{
Response.ContentType = "image/jpeg";
Response.BinaryWrite((byte[])Dr["photo"]);
}
else
{
Response.Write("暂无图片");
}
}
}
else
{
Response.Write("暂无图片");
}
Dr.Close();
}