• sql insert image


     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),
                    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);
            }
  • 相关阅读:
    php网站请求返回结果被加入恶意代码片段
    php tp5 的index.php 被改成首页静态页面内容
    gitee https 方式每次都要输入密码的解决
    linux 下 php执行 exec 无反应 返回值为空
    layerconfirm 右上角关闭事件等于按钮2
    微信小程序公共方法创建与调用
    php curl 转为 x-www-form-urlencoded 方式
    php 加载 zip 文件
    小程序语音播报
    mysql命令行操作-将查询结果导出到文件
  • 原文地址:https://www.cnblogs.com/siri/p/2993141.html
Copyright © 2020-2023  润新知