protected void Page_Load(object sender, EventArgs e)
{
if(Request.QueryString["jid"]!=null){
string sql = "select * from TGoods where jid="+Convert.ToInt32(Request.QueryString["jid"].ToString());
SqlDataReader dr = DBSql.GetReader(sql);
if(dr.Read()){
byte[] bytes = (byte[])dr["jphoto"];
MemoryStream ms = new MemoryStream(bytes);
System.Drawing.Image image = System.Drawing.Image.FromStream(ms);
Response.ContentType = "image/JPEG";
Response.BinaryWrite(bytes);
}
dr.Close();
}
}
2、如果你是Repeater控件绑定读取数据,那么在你的Repeater控件中放入一个Image控件。
在Repeater的ItemDataBound后台页面代码如下:
protected void Repeater2_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//找出刚才在Repeater控件中放入的Image控件,设置其图片URL来自StreamImage.aspx页面
Image img = e.Item.FindControl("imgStream") as Image;
img.ImageUrl = "~/Wp_WorkTable/StreamImage.aspx?jid=" + ((DataRowView)e.Item.DataItem)["jgoodsid"];
}
}
以上2步就可以做到 让二进制数据在页面显示图片
评论