| 标题 | 上传图片后使用数据库保存图片的示例分享 |
| 内容 | 这篇文章主要介绍了上传图片后使用数据库保存图片的示例,需要的朋友可以参考下 代码如下: 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],[LeaveR eason],[ReportTime],[ReportID],[ImageName],[ImageData]) "; strNewLeave += "values(@LeaveNo,@EmpNo,@AgentName,@LeaType,@StartDate,@EndDate,@Hours,@Reason,getdate(),@Adm in,@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), 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); } |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。