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.