Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Sep 14, 1999

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap