上傳圖片后用法數(shù)據(jù)庫保存圖片的示例分享_

1、上傳圖片后用法數(shù)據(jù)庫保存圖片的示例分享_ 這篇文章主要介紹了上傳圖片后用法數(shù)據(jù)庫保存圖片的示例,需要的伴侶可以參考下 代碼如下: HttpPostedFile UpFile = File1.PostedFile; int FileLenght = UpFile.ContentLength; decimal FileSize = FileLenght / 1024; if (FileLenght = 0) DIVShowGVError.Visible = true; LblShowGVError.Text = 請(qǐng)選擇上傳文件; return; string strImageName = UpFi

2、le.FileName; string strImageType = strImageName.Substring(strImageName.LastIndexOf(.).ToLower(); if (strImageType != .jpg strImageType != .jpeg strImageType != .bmp strImageType != .png) DIVShowGVError.Visible = true; LblShowGVError.Text = 請(qǐng)上傳以下文件格式的圖片：jpg,jpeg,bmp,png; return; if (FileSize 2048) DI

3、VShowGVError.Visible = true; LblShowGVError.Text = 上傳圖片不能大於2M; return; else Byte FileByteArray = new ByteFileLenght; Stream StreamObject = UpFile.InputStream; StreamObject.Read(FileByteArray, 0, FileLenght); strNewLeave = insert into Leave(ID,EmployeeNo,AgentID,LeaveType,StartDate,EndDate,Hours,Leav

4、eR 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,str

5、AgentID), 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,FileBy

6、teArray) ; StreamObject.Close(); 代碼如下: SQLHelper sqlH = new SQLHelper(); string strID = context.RequestID; byte MyData = new byte0; string str = select ImageData from Leave where ID= + strID + ; DataTable dt = sqlH.ExecuteQuery(str, CommandType.Text); if (dt.Rows.Count 0) MyData = (byte)dt.Rows00; int ArraySize = MyDat