Go through the following Links. These would give you the necessary information about how to do it:
Storing and Retrieving Images from SQL Server Using Strored Procedures
How to insert\retrieve image in SQL Server database
Storing and Retrieving Images from SQL Server using Microsoft .NET