Store and retrieve image using SQL database

Tags:
SQL Database
How can I store and retrieve images using a SQL database?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi RAJA12us28 Welcome to ITKE. You have two options to store images in SQL Server database. First one is to convert image into binary and then save that binary in SQL Server database table field of type BLOB. Second option is to save images in application folder and save their path in table field of type VARCHAR. Then retrieve images accordingly. If you search around you will find a lot of sample codes for this purpose.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    I would probably do it by saving the image path. That way you could have multiple image formats without having to convert every image.
    131,550 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: