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

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.

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


Recent Articles: