Click here to Skip to main content
14,699,608 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Can you please explain the image storage and retrieval in sql server2008 and also explain the code in visualstudio 2010?
Posted

Storing and accessing Images from physical application folder is better way as compare to Database.

However, you may have a look at below link for several Question-Answers posted on this topic earlier here on CodeProject.
http://www.codeproject.com/search.aspx?q=Image+SQL+Server+C%23&sbo=qa&usfc=false
   
Comments
fjdiewornncalwe 8-Nov-12 14:13pm
   
+5. It's all there.
RaisKazi 8-Nov-12 14:21pm
   
Thank you Marcus. :)
You store the binary data of the image in a varbinary(max) field in SQL server. You can retrieve this data using ADO.net, Entity Framework or NHibernate. When you are working with the data in C# it will be in the form of a byte[]

there is a CodeProject article which explains it all:

Storing and Retrieving Images from SQL Server Using Strored Procedures and C#.net[^]
   

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