private string fullFileNameSql(HtmlInputFile File,string imageFile,string imageName)//上传图片(数据库) { string fullFileName=File.PostedFile.FileName; if(fullFileName!=""&&imageFile!=""&&imageFile!=null) { string fileName=imageName; string imgType=fullFileName.Substring(fullFileName.LastIndexOf(".")+1); if (imgType=="bmp"||imgType=="jpg"||imgType=="gif") { int imgSize=File.PostedFile.ContentLength; Stream imgDataS=File.PostedFile.InputStream; byte[] imgData=new byte[imgSize]; this.Response.Clear(); imgDataS.Read(imgData,0,imgSize); Inc inc=new Inc(); SqlConnection con=inc.con(); string sql="insert into proImg(imgName,imgData,imgType) values(@imgName,@imgData,@imgType)"; SqlCommand cmd=new SqlCommand(sql,con); SqlParameter PimgName=new SqlParameter("@imgName",SqlDbType.VarChar,50); PimgName.Value=imageFile+fileName; cmd.Parameters.Add(PimgName); SqlParameter PimgData=new SqlParameter("@imgData",SqlDbType.Image); PimgData.Value=imgData; cmd.Parameters.Add(PimgData); SqlParameter PimgType=new SqlParameter("@imgType",SqlDbType.VarChar,50); PimgType.Value=imgType; cmd.Parameters.Add(PimgType); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return imageFile+fileName; } else { Response.Write(Message.ShowAndBack("图片格式错误")); } } return ""; }
如何将图片存储到数据库中
最新推荐文章于 2024-03-09 11:09:30 发布