Could you help me in ASP.Net.

[abglorie]

Sorry for the distrubing. Please give your answer. Now, I want store a picture in database. Later retrieve the picture from database and show in a page. 1. Which type of datatype to create in SQL? and 2. How to retrieve from (picture) data and display on IE. Please give exact coding. Thanking you, abglorie

[sashidhar]

It Is Easy To Store And Retrive the image From Database 1)The DataType In sqlServer Is [image] 2) -->First Store the image in byte format -->Retrieve the Bytes And Conver the Byte In buffer Stream -->And Display the image in image Control To Understand More Clearly You Can Refer the Following Article With Example http://www.beansoftware.com/asp.net-tutorials/images-database.aspx[^] http://www.dotnetcurry.com/ShowArticle.aspx?ID=129[^] Storing and Retrieving Images from SQL Server using Microsoft .NET[^] http://www.dotnetspider.com/resources/460-Store-Retrieve-SQL-Server-database.aspx[^] If the Above Is Helpful Mark It As Answer And let Me Know

modified on Monday, August 31, 2009 7:49 AM

[Abhijit Jana]

I am agree what sashidhar suggested, You can do one more thing, rather than sotring image in DB in byte format, store image in your hard drive and store the path in Database. Retreive the path from database, and display the image from your hard drive. This will make your task simple.

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.