I want to know how store and retrive images through Asp.net in Sql server 2005, ??

Hey friends i want to know HOw store images like gif, jpeg,png file in sql server 2005 database? using Asp.net in c# or Vb.net whatever? and how to retrive it from sql server into asp.net web page as well as the image control and gridview control also? actually i m a student and i doing one project so i need some help pls guid me .... thanx for your any replyI want to know how store and retrive images through Asp.net in Sql server 2005, ??
SQL server has a data type called image, when you create the table you can enter that as the field type... alternately you can store the path to the images in which case you need to use nvarchar(1000)





And the rest, use the sqlconnection data type.I want to know how store and retrive images through Asp.net in Sql server 2005, ??
This page pretty much says how to do it.





http://www.asp.net/learn/data-access/tut鈥?/a>