一: 直接把图片放到某个文件夹中 1:<INPUT id="myFile" type="file" class="input" onChange="checkData()" size="34" name="myFile" runat="server">2:判断过程<script>function checkData()...{var fileName=document.getElementById("myFile").value;if(fileName=="")return;var exName=fileName.substr(fileName.lastIndexOf(".")+1).toUpperCase()if(exName=="JPG"||exName=="BMP"||exName=="GIF")...{document.getElementById("myimg").src=fileName}else...{alert("请选择正确的图片文件")document.getElementById("myFile").value=""} }</script><script language="javascript">window.resizeTo(400,250);</script>3:上传图片路径到数据库private void btnSubmit_Click(object sender, System.EventArgs e)...{string strImageName="";string FileName=myFile.Value;string Publishtime=DateTime.Now.ToString();string svrid=this.Hidden_svrid.Value.ToString();string modelid=this.Hidden_modelid.Value.ToString();string itemid=this.Hidden_itemid.Value.ToString();string slocal_ip=Request.ServerVariables["REMOTE_HOST"];string sregtime=System.DateTime.Now.ToString();string exName=FileName.Substring(FileName.LastIndexOf(".")+1).ToUpper();//截取图片的后缀名string fn=myFile.PostedFile.FileName;string imghead=svrid+"_";string SaveName=imghead+DateTime.Now.ToString("yyyyMMddhhmmssfff");//根据时间生成图片名strImageName=SaveName+fn.Substring(fn.LastIndexOf("."));//图片名加上图片后缀名string strpath=Server.MapPath("")+"/upimage/"+"/"+this.Session_UserID+"/";//得到将要保存图片的路径string saveimg="upimage/"+this.Session_UserID+"/"+strImageName;string savepath=strpath+strImageName;string sqlread;string sqladd;if(itemid=="")...{sqlread="select pic_path from BZ_Data_pic where Busi_id='"+this.Session_UserID+"' and Modal_id='"+modelid+"' and svrID='"+svrid+"'";sqladd="insert into BZ_Data_pic(Modal_id,SvrID,Busi_id,pic_path,Reg_time,Local_ip) values('"+modelid+"','"+svrid+"','"+this.Session_UserID+"','"+saveimg+"','"+sregtime+"','"+slocal_ip+"')";}else...{sqlread="select pic_path from BZ_Data_ModalItemPic where Busi_id='"+this.Session_UserID+"' and Modal_id='"+modelid+"' and Item_ID='"+itemid+"' and svrID='"+svrid+"'";sqladd="insert into BZ_Data_ModalItemPic(Modal_id,SvrID,Busi_id,Item_ID,pic_path,Reg_time,Local_ip) values('"+modelid+"','"+svrid+"','"+this.Session_UserID+"','"+itemid+"','"+saveimg+"','"+sregtime+"','"+slocal_ip+"')";}System.Data.DataTable dt=Framework.ComLib.DataBase.Query(sqlread).Tables[0];//判断保存的图片张数if(dt.Rows.Count<3)...{if(exName=="JPG"||exName=="BMP"||exName=="GIF")...{if(myFile.PostedFile.ContentLength>204800)//判断图片是否大于200k...{RegisterClientScriptBlock ("alertInfo","<script>alert('对不起,你上传的图片太大,请转换后上传')</script>");return;}if(System.IO.Directory.Exists(strpath) == false)...{System.IO.Directory.CreateDirectory(strpath);}myFile.PostedFile.SaveAs(savepath);//把图片保存在此路径中Framework.ComLib.DataBase.ExecuteSql( sqladd);RegisterClientScriptBlock ("alertInfo","<script>window.opener.location.reload();window.opener.opener=null;window.close();</script>");}else...{RegisterClientScriptBlock ("alertInfo","<script>alert('请选择正确的图片文件')</script>");return;}}else...{RegisterClientScriptBlock ("alertInfo","<script>alert('最多只能上传3张图片');location.href=location.href;</script>");}}二: 直接把图片放到数据库中一、文件(图片)保存到数据库//得到用户要上传的文件名string strFilePathName = loFile.PostedFile.FileName;string strFileName = Path.GetFileName(strFilePathName);int FileLength = loFile.PostedFile.ContentLength;if(FileLength<=0)return;try...{//上传文件Byte[] FileByteArray = new Byte[FileLength]; //图象文件临时储存Byte数组Stream StreamObject = loFile.PostedFile.InputStream; //建立数据流对像//读取图象文件数据,FileByteArray为数据储存体,0为数据指针位置、FileLnegth为数据长度StreamObject.Read(FileByteArray,0,FileLength); //建立SQL Server链接string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];SqlConnection Con = new SqlConnection(strCon);String SqlCmd = "INSERT INTO ImageStore (ImageData, ImageContentType, ImageDescription, ImageSize) VALUES (@Image, @ContentType, @ImageDescription, @ImageSize)";SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);CmdObj.Parameters.Add("@Image",SqlDbType.Binary, FileLength).Value = FileByteArray;CmdObj.Parameters.Add("@ContentType", SqlDbType.VarChar,50).Value = loFile.PostedFile.ContentType; //记录文件类型//把其它单表数据记录上传CmdObj.Parameters.Add("@ImageDescription", SqlDbType.VarChar,200).Value = tbDescription.Text;//记录文件长度,读取时使用CmdObj.Parameters.Add("@ImageSize", SqlDbType.BigInt,8).Value = FileLength;Con.Open();CmdObj.ExecuteNonQuery(); Con.Close();//跳转页面Response.Redirect("ShowAll.aspx");}catch...{}取出来显示:int ImgID = Convert.ToInt32(Request.QueryString["ID"]); //ID为图片ID //建立数据库链接string strCon = System.Configuration.ConfigurationSettings.AppSettings["DSN"];SqlConnection Con = new SqlConnection(strCon);String SqlCmd = "SELECT * FROM ImageStore WHERE ImageID = @ImageID";SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);CmdObj.Parameters.Add("@ImageID", SqlDbType.Int).Value = ImgID;Con.Open();SqlDataReader SqlReader = CmdObj.ExecuteReader();SqlReader.Read(); Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型//输出图象文件二进制数制Response.OutputStream.Write((byte[])SqlReader["ImageData"], 0, (int)SqlReader["ImageSize"]); Response.End();//也可以保存为图像// FileStream fs = new FileStream(@"C:aa.BMP", FileMode.OpenOrCreate, FileAccess.Write);// fs.Write((byte[])SqlReader["ImageData"], 0,(int)SqlReader["ImageSize"]);// fs.Close();Con.Close();三 在WinForm环境中把图片放在数据库中System.Data.SqlClient.SqlConnection conn = new SqlConnection(sqlconnstr);System.Data.SqlClient.SqlCommand cmd = new SqlCommand("insert imgtable values(@name,@data)",conn);System.Data.SqlClient.SqlParameter pm = new SqlParameter("@name",System.Data.SqlDbType.VarChar,200);pm.Value = fname;System.Data.SqlClient.SqlParameter pm1 = new SqlParameter("@data",System.Data.SqlDbType.Image);System.IO.FileStream fs = new System.IO.FileStream(fname,System.IO.FileMode.Open);int len = (int)fs.Length;System.Byte[] fileData = new byte[len];fs.Read(fileData,0,len);fs.Close();pm1.Value = fileData;cmd.Parameters.Add(pm);cmd.Parameters.Add(pm1);conn.Open();try......{cmd.ExecuteNonQuery();MessageBox.Show("Save Picture to database succeed");}catch(System.Exception ex)......{MessageBox.Show(ex.ToString());}读取的过程System.Data.SqlClient.SqlConnection conn = new SqlConnection(sqlconnstr);System.Data.SqlClient.SqlCommand cmd = new SqlCommand("select * from imgtable where imgname like '%bmp%'",conn);conn.Open();System.Data.SqlClient.SqlDataReader dr;try......{dr = cmd.ExecuteReader();while(dr.Read())......{System.Data.SqlTypes.SqlBinary sb = dr.GetSqlBinary(2);System.IO.MemoryStream stm = new System.IO.MemoryStream(sb.Value);System.Drawing.Bitmap bmp = new Bitmap(Bitmap.FromStream(stm));this.pictureBox1.Image = bmp;}dr.Close();}catch......{}finally......{conn.Close();}说明:Sql Server 数据库中 Image/Text这两种数据类型都是容量比较大的数据类型,单字段可以存取2GB的数据,而普通的字段不能超过8K,Text通常用来保存大文本数据,可直接用字符串判断检索,Image通常用来保存二进制数据,不可直接用字符串判断检索四 给图片加文字和图片水印private void Btn_Upload_Click(object sender, System.EventArgs e)......{if(UploadFile.PostedFile.FileName.Trim()!="")......{//上传文件string extension = Path.GetExtension(UploadFile.PostedFile.FileName).ToUpper();string fileName = DateTime.Now.ToString("yyyyMMddhhmmss");string path = Server.MapPath(".") + "/UploadFile/" + fileName + extension;UploadFile.PostedFile.SaveAs(path);//加文字水印,注意,这里的代码和以下加图片水印的代码不能共存System.Drawing.Image image = System.Drawing.Image.FromFile(path);Graphics g = Graphics.FromImage(image);g.DrawImage(image, 0, 0, image.Width, image.Height);Font f = new Font("Verdana", 32);Brush b = new SolidBrush(Color.White);string addText = AddText.Value.Trim();g.DrawString(addText, f, b, 10, 10);g.Dispose();//加图片水印System.Drawing.Image image = System.Drawing.Image.FromFile(path);System.Drawing.Image copyImage = System.Drawing.Image.FromFile( Server.MapPath(".") + "/Alex.gif");Graphics g = Graphics.FromImage(image);g.DrawImage(copyImage, new Rectangle(image.Width-copyImage.Width, image.Height-copyImage.Height, copyImage.Width, copyImage.Height), 0, 0, copyImage.Width, copyImage.Height, GraphicsUnit.Pixel);g.Dispose();//保存加水印过后的图片,删除原始图片string newPath = Server.MapPath(".") + "/UploadFile/" + fileName + "_new" + extension;image.Save(newPath);image.Dispose();if(File.Exists(path))......{File.Delete(path);}Response.Redirect(newPath);}}// 注意:加文字水印和加图片水印的代码不能共存 原文地址: http://tb.blog.youkuaiyun.com/TrackBack.aspx?PostId=1514195