Click here to Skip to main content
15,894,405 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,



what is the best way to store image,audio and video file in sql server database.
Posted
Comments
Prerak Patel 14-Sep-11 8:15am    
Best way is to store only path.

1 solution

You have two options:
  1. Store a link (e.g. full path) to the actual file.
  2. Store the whole binary content as a BLOB[^] inside the database

The 'best way' actually depends on your needs.
 
Share this answer
 
Comments
Suresh Suthar 14-Sep-11 8:35am    
Simple but Nice. 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900