根据网上代码自己该动了些
#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 ConStr ="UID=sa,PWD=sa,Server=local,Database=mydb";
SqlConnection Conn = new SqlConnection(ConStr);
Conn.Open();
SqlCommand myCommand =new SqlCommand();
myCommand.Connection=Conn;
myCommand.CommandText="insert into [UpImage] (imageName,image,imgType,SmallImage) values (@ImgName,@FileByte,@imgType,@SmallImage)";
myCommand.Parameters.Add("@ImgName",ImgName);
myCommand.Parameters.Add("@FileByte",FileByte);
myCommand.Parameters.Add("@imgType",imgType);
myCommand.Parameters.Add("@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]);
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
////图片显示页的代码
myCommand.CommandText="select smallimage from [UpImage] ";
SqlDataReader dr =db.myCommand.ExecuteReader();
this.Response.ContentType="image/gif";
while(dr.Read())
{
Response.BinaryWrite((byte[])dr["smallimage"]);
}