這篇文章主要介紹了上傳圖片后使用數(shù)據(jù)庫保存圖片的示例,需要的朋友可以參考下
    代碼如下:
    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);
    }