locked
Adding Picture to Employee Profile RRS feed

  • Question

  • I have an Employee Profile Table.
    I want to add Employee Picture as varbinary(max).
    I am using C# with Ms Sql Server 2008.
    How can i Load/Save Image using Winform.
    Wednesday, October 7, 2015 6:33 AM

Answers

    • Proposed as answer by Hardz Tarrayo Wednesday, October 7, 2015 8:46 AM
    • Marked as answer by Kristin Xie Thursday, October 15, 2015 9:44 AM
    Wednesday, October 7, 2015 8:23 AM
  • There are 3 schools of though on how to store blobs (Binary Large Objects) together with a Database. If the image stays small, the in table approach should be enough.
    But if it ever get's bigger, you may want to look into one of the alternatives. Images literally increase in size exponentially as thier Resolution increases:

    An Introduction to SQL Server FileStream

    • Marked as answer by Kristin Xie Thursday, October 15, 2015 9:44 AM
    Wednesday, October 7, 2015 8:46 AM

All replies

    • Proposed as answer by Hardz Tarrayo Wednesday, October 7, 2015 8:46 AM
    • Marked as answer by Kristin Xie Thursday, October 15, 2015 9:44 AM
    Wednesday, October 7, 2015 8:23 AM
  • There are 3 schools of though on how to store blobs (Binary Large Objects) together with a Database. If the image stays small, the in table approach should be enough.
    But if it ever get's bigger, you may want to look into one of the alternatives. Images literally increase in size exponentially as thier Resolution increases:

    An Introduction to SQL Server FileStream

    • Marked as answer by Kristin Xie Thursday, October 15, 2015 9:44 AM
    Wednesday, October 7, 2015 8:46 AM