Storing and Retrieving Images in SQL Server

-
I typically use the File System for storing images, that doesn't work so well when using a web farm.  Below is an example of storing the image information into SQL server and then retrieving and rendering image back on the page.
The datatype for the image column I am using is the varbinary(max).  For this example I am allowing the upload of an image so I limit both the size and file extension type.

Upload Action



 [HttpPost]
public ActionResult Upload(HttpPostedFileBase file, DataModel.MyClass imginfo)
{
if (ModelState.IsValid)
   {
     if (file == null)
    {
     
     }
else if (file.ContentLength > 0)
    {
int MaxContentLength = 1024 * 1024 * 3; //3 MB - Could put this in a config

 string[] AllowedFileExtensions = new string[] { ".jpg", ".gif", ".png", ".JPG", ".jpeg", ".JPEG", ".GIF", ".PNG" };

 if (!AllowedFileExtensions.Contains(file.FileName.Substring(file.FileName.LastIndexOf('.'))))
{


 ViewBag.Message = "Your file must be JPG, GIF or PNG";
}
else if (file.ContentLength > MaxContentLength)
{

ViewBag.Message = "Your file is too large, maximum allowed size is 3 meg";
}
else
{
//imginfo is the dataclass I passed in

imginfo.imageContentType = file.ContentType;

 //This is a temp save
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Assets/"), imginfo.imageName);
file.SaveAs(path);

 imginfo.imagePath = "Assets/" + imginfo.imageName;
imginfo.imageFile = ImageTypeOptions.GetPhoto(path);

 //adding straight into my table
dt.TableName.Add(imginfo);
dt.SaveChanges();

 //deleting the temp image 
//since file system deletions can be buggy we are going to throw into a static method
//with a try catch just so it doesn't stop us

 TryToDelete(path);

ViewBag.Message = "File uploaded successfully";
}
}
}
return RedirectToAction("Final", new { id = imginfo.AccountCode, dppID = imginfo.dppID, message = "Successfully Uploaded image" });


}

 Static TrytoDelete method


     private static bool TryToDelete(string f)
        {
            try
            {
                System.IO.File.Delete(f);
                return true;
            }
            catch (IOException)
            {
                return false;
            }

        }

  Static method to convert the image to a format to insert into database
 public static byte[] GetPhoto(string filePath)
        {
            FileStream stream = new FileStream(
                filePath, FileMode.Open, FileAccess.Read);
            BinaryReader reader = new BinaryReader(stream);

             byte[] photo = reader.ReadBytes((int)stream.Length);

             reader.Close();
            stream.Close();

             return photo;

        }

 Then to display on the page just use it like this we are passing in the ID of the row (AssetID):

   <img src="@Url.Action( "DisplayImage", "Fran", new { id = item.AssetID })" width="50" height="50" />

 And the action that we are calling

    public ActionResult DisplayImage(int id)
        {
            var img = db.TableName.Find(id);
            byte[] imageData = img.imageFile;
            var contType = img.imageContentType;
            return new FileStreamResult(new System.IO.MemoryStream(imageData), contType);
           

        }


Comments

Post a Comment

Popular posts from this blog

Linq Exclude from separate list

-
 var urlList = new List<DisplayAssets>();    var assetsToExclude = (from a in db.DisplayAssets                 join h in db.Hardware_Assets on a.id equals h.displayId                 where h.assetId == hardwareid                 select a.id); var allAssets = db.DisplayAssets; var urls = allAssets.Where(x => !assetsToExclude.Contains(x.id));         urlList = urls.Select(a => new DisplayAssets()         {             locaterAddress  = a.locaterAddress,             assetType = a.assetType,             id = a.id         })         .ToList();
Read more

Sorting Ascending and Descending

-
Toggling the direction of your datagrid sort is easy using a session to remember which direction you sorted last.   You will want to declare an empty string in the top of your page       Dim SortField As String Then on your sort command add this logic - Example of entire command Private Sub dgTaskExceptions_SortCommand( ByVal source As Object , ByVal e As System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles dgTaskExceptions.SortCommand     SortField = e.SortExpression If Session( "toggle" ) = True Then SortField += " DESC" Session( "toggle" ) = False Else SortField += " Asc" Session( "toggle" ) = True End If Dim orderstring As String = SortField 'REBIND dgTaskExceptions.DataSource = POTracking_Data.tracking.getSampleTasks(orderstring) dgTaskExceptions.DataBind() End Sub   In my datalayer I add this logic to my query and pass in an OPTIONAL value Dim orderbyString As String = String .Empt
Read more

Linq Query Syntax vs Method Syntax

-
Referenced from MSDN: https://msdn.microsoft.com/en-us/library/bb397947.aspx Query syntax: IEnumerable<int> numQuery1 =               from num in numbers             where num % 2 == 0             orderby num             select num; Method syntax:         IEnumerable<int> numQuery2 = numbers.Where(num => num % 2 == 0).OrderBy(n => n)
Read more