上傳圖片後使用數據庫保存圖片的示例分享

 這篇文章主要介紹了上傳圖片後使用數據庫保存圖片的示例,需要的朋友可以參考下

 代碼如下: 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);         }