上传图片后使用数据库保存图片的示-例分享

2019-11-02 14:57:52

字体：大中小

来源：转载

供稿：网友

这篇文章主要介绍了上传图片后使用数据库保存图片的示例,需要的朋友可以参考下

代码如下:HttpPostedFile UpFile = File1.PostedFile;int FileLenght = UpFile.ContentLength;decimal FileSize = FileLenght / 1024;if (FileLenght == 0){ DIVShowGVError.Visible = true; LblShowGVError.Text = "请选择上传文件"; return;}string strImageName = UpFile.FileName;string strImageType = strImageName.Substring(strImageName.LastIndexOf(".")).ToLower();if (strImageType != ".jpg" && strImageType != ".jpeg" && strImageType != ".bmp" && strImageType != ".png"){ DIVShowGVError.Visible = true; LblShowGVError.Text = "上以下文件格式的片：jpg,jpeg,bmp,png"; return;}if (FileSize > 2048){ DIVShowGVError.Visible = true; LblShowGVError.Text = "上片不能大於2M"; return;}else{ Byte[] FileByteArray = new Byte[FileLenght]; Stream StreamObject = UpFile.InputStream; StreamObject.Read(FileByteArray, 0, FileLenght); strNewLeave = "insert into [Leave]([ID],[EmployeeNo],[AgentID],[LeaveType],[StartDate],[EndDate],[Hours],[LeaveReason],[ReportTime],[ReportID],[ImageName],[ImageData]) "; strNewLeave += "values(@LeaveNo,@EmpNo,@AgentName,@LeaType,@StartDate,@EndDate,@Hours,@Reason,getdate(),@Admin,@ImageName,@Image) "; sqlPara = new SqlParameter[] { new SqlParameter("@LeaveNo",strLeaNo), new SqlParameter("@EmpNo",strEmpNo), new SqlParameter("@AgentName",strAgentID), new SqlParameter("@LeaType",strLeaType), new SqlParameter("@StartDate",strDateSt), new SqlParameter("@EndDate",strDateEnd), new SqlParameter("@Hours",strHours), new SqlParameter("@Reason",strReason), new SqlParameter("@Admin",strAdmin), &nb

放放电影网[www.aikan.tv/special/fangfangdianyingwang/]

sp; new SqlParameter("@ImageName",strImageName), new SqlParameter("@Image",FileByteArray) }; StreamObject.Close();} 代码如下:SQLHelper sqlH = new SQLHelper(); string strID = context.Request["ID"]; byte[] MyData = new byte[0]; string str = " select [ImageData] from [Leave] where [ID]='" + strID + "' "; DataTable dt = sqlH.ExecuteQuery(str, CommandType.Text); if (dt.Rows.Count > 0) {MyData = (byte[])dt.Rows[0][0];int ArraySize = MyData.GetUpperBound(0); context.Response.OutputStream.Write(MyData, 0, ArraySize); }

上一篇：asp防止网页刷-新代码

下一篇：如何在!网页中显示服务器时间(asp)

学习交流

索泰发布一款GTX 1070 Mini迷你版本:小机

索泰发布一款GTX 1070 Mini迷你版本:小机箱大爱...

热门图片

猜你喜欢的新闻

猜你喜欢的关注