Update varbinary field with photo

Hi Jose

Thank you for the code, but it didn't work with me, maybe I am using different method.

This is my code below:

     private void GetUploadedFile()
        {
            if (Request.Files.Count > 0 && Request.Files[0].FileName != String.Empty)
            {
                Request.Files[0].SaveAs(Path.Combine(Server.MapPath(@"../HR/CompanyDocuments"), Request.Files[0].FileName));
                
                string filePath = Request.Files[0].FileName;
                byte[] _imageToSave = filePath;  (IT SHOWS THE FILE NAME IN THIS VARIABLE BUT IT IS UNDERLINED WITH RED COLOR)
                
                var TheUploadedImage= Request.Files[0].FileName;
               //   var TheUploadedImage = "data:image/jpg;base64," + Convert.ToBase64String(_imageToSave);
                //- Replace nvarcharColumn(MAX) with your column in table.
                // Table->nvarcharColunm(MAX) = TheUploadedImage

                //- Or display the image as follow
                //this.imgPicture.ImageUrl = TheUploadedImage;

                string BranchRecID = Session["BranchLogoRecID"].ToString();
                string Sql = $"Update BudgetCenter set Scan = @Logo,LogoBr=@LogoBr where recid={BranchRecID}";
                string[] paramters = new string[] { "@Logo","@LogoBr" };
                string[] vals = new string[] { filePath, TheUploadedImage };
               
                gm.ExecuteSQL(sConnTime, Sql, paramters, vals);

                

            }
            
        }

Have you try the Convert.ToBase64String() instead, saving it to a nVarchar(MAX) column instead of varbinary column

here it the code, assuming you getting the photo/ image from the UPLOAD Field

byte[] _imageToSave = this.fiUpload.FileBytes;
if (_imageToSave.Length>0)
{
   var TheUploadedImage = "data:image/jpg;base64," + Convert.ToBase64String(_imageToSave);
   //- Replace nvarcharColumn(MAX) with your column in table.
   Table->nvarcharColunm(MAX) = TheUploadedImage
  
   //- Or display the image as follow
   this.imgPicture.ImageUrl = TheUploadedImage;

}

 

Happy Coding