显示数据库中的图片,却显示System.byte[]?
这是我从网上搜的代码,存储部分都搞定了,但是当显示的时候只显示了System.byte[],不知道是什么问题?#region 上传图片到数据库
private void UpIMGButton_Click(object sender, System.EventArgs e)
{
string exName=UpFile.Value.Substring(UpFile.Value.LastIndexOf(".")+1).ToUpper();//找出图片的后缀名
string ImgName=DateTime.Now.ToString("yyyyMMddhhmmssfff")+"."+exName;
if (UpFile.PostedFile.ContentLength==0)
{
Response.Write("<script> alert('你上传的图片不能为空!');</script>");
}
else
{
try
{
Byte[] FileByte = new byte[UpFile.PostedFile.ContentLength];
Stream ObjectStream = UpFile.PostedFile.InputStream;
ObjectStream.BeginRead(FileByte,0,UpFile.PostedFile.ContentLength,null,null);
string imgType=UpFile.PostedFile.ContentType;
Byte[] SmallFileByte = new byte[UpFile.PostedFile.ContentLength];
SmallFileByte=CreateThumnail(ObjectStream,100,100);
string C;
SqlConnection Conn = new SqlConnection(ConStr);
Conn.Open();
SqlCommand myCommand =new SqlCommand();
myCommand.Connection=Conn;
into [UpImage] (imageName,image,imgType,SmallImage) values (@ImgName,@FileByte,@imgType,@SmallImage)";
myCommand.Parameters.AddWithvalue("@ImgName",ImgName);
myCommand.Parameters.AddWithvalue("@FileByte",FileByte);
myCommand.Parameters.AddWithvalue("@imgType",imgType);
myCommand.Parameters.AddWithvalue("@SmallImage",SmallFileByte);
myCommand.ExecuteNonQuery();
Response.Write("<script> alert('图片保存到数据库成功!');</script>");
}
catch(Exception ex)
{
Response.Write (ex.Message);
}
}
}
#endregion
#region 生成缩略图
private Byte[] CreateThumnail(Stream ImageStream,int tWidth, int tHeight)
{
System.Drawing.Image g = System.Drawing.Image.FromStream(ImageStream);
int[] thumbSize = new int[]{1,1};
thumbSize = NewthumbSize(g.Width, g.Height, tWidth, tHeight);
Bitmap imgOutput = new Bitmap(g, thumbSize[0], thumbSize[0]);//这里提示为无效参数,所以我把后两个参数直接用100,100代替
MemoryStream imgStream = new MemoryStream();
System.Drawing.Imaging.ImageFormat thisFormat = g.RawFormat;
imgOutput.Save(imgStream, thisFormat);
Byte[] imgbin =new byte[imgStream.Length];
imgStream.Position = 0;
Int32 n = imgStream.Read(imgbin,0,imgbin.Length);
g.Dispose();
imgOutput.Dispose();
return imgbin;
}
#endregion
#region 根据上传图片调整缩略图的尺寸
protected int[] NewthumbSize(int currentwidth,int currentheight,int newWidth ,int newHeight)
{
int tempMultiplier;
if(currentheight > currentwidth)
{
tempMultiplier = newHeight / currentheight;
}
else
{
tempMultiplier = newWidth / currentwidth;
}
int[] NewSize = new int[]{(currentwidth * tempMultiplier),(currentheight * tempMultiplier)};
return NewSize;
}
#endregion
////图片显示页的代码
smallimage from [UpImage] ";
SqlDataReader dr =db.myCommand.ExecuteReader();
this.Response.C;
while(dr.Read())
{
Response.BinaryWrite((byte[])dr["smallimage"]);
}