Inserting Images to SQL Using a SP and N-tier App

Question:
I am in the process of creating an n-tier database application and am stuck at storing images to the SQL Server database. Any help would be appreciated.

Obviously, I need to read the image from the hard drive and store it to a variable (of what type?), and then pass it to my business layer, data access layer, and then the SP.

Answer:
The text datatype holds binary large objects, too, which is what you want to store. It’s done via the GETCHUNCK method in Visual Basic.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: