displaying images in aspx file or in gridview

Question

hi, how can i dispaly image file like jpg, gif etc. from sql database to gridview or aspx page in asp.net. thanking u all in advance anu bajracharya

Rekha Singh · Answer

save the image into database fisrt(the image will be stored in binary form) and then select it from table as in the given code below write this code on page load of ur aspx page //build our query statement string sqlText = "SELECT PassPicture FROM PassportDetails WHERE empcode = 123 " ; SqlConnection connection = new SqlConnection ( "Your ConnectionString Here" ); SqlCommand command = new SqlCommand (sqlText, connection); //open the database and get a datareader connection.Open(); SqlDataReader dr = command.ExecuteReader(); dr.Read(); Response.Clear(); byte [] buffer = ( byte [])dr[ "PassPicture" ]; int blen = (( byte [])dr[ "PassPicture" ]).Length; Response.OutputStream.Write(buffer, 0, blen); Response.End(); connection.Close(); this code will display the image in ur aspx page

Niradhip Chakraborty · Answer

I think, I have already sent you the code concept. Only thing you need to do is giving proper image path for different size of image. Checkout the following articles to display images in gridview. 1. http://www.devasp.net/net/articles/display/692.html 2. http://www.aspxcode.net/free-asp-net-data-sample-source-code.aspx?Topics=How%20to%20display%20images%20in%20GridView

Ruchi R · Answer

thanks for ur reply, can u plz send me c# code to do this...........

Niradhip Chakraborty · Answer

For all the images you can have two images.One is small in size another one is bigger. Now based on selection you can display the small or big image.

Ruchi R · Answer

hi all, Actually i need to display pictures in gridview in thumbnail size . when user clicks on the thumbnail picture , large sized picture should be displayed.Is it possible to do .If yes then how can i do it.

Niradhip Chakraborty · Answer

Say u have created the following to hold the image Now in your code behind get the image Path and display it. Something like this. imgEvent2.ImageUrl = dstEvents.Tables["Events"].Rows[intIndex]["evm_txt_EventImagePath"].ToString(); I am using dataset(dstEvents) to fetch the record from table. Make sure the path contains the image correctly.

Manish Dwivedi · Answer

Hi Take the reference of this article, this article will solve your problem. http://www.aspsnippets.com/post/2009/02/21/Display-Images-from-Database-using-ASPNet.aspx

Ruchi R · Answer

Thanks for the reply, i have stored image itself in the sql database.table for this contains following fields like image_id (int), image_name(varchar), image_data(image), image_contenttype(varchar).Now i need to display image name , image_data, and imagecontentype in a grid view or in aspx file.how can i do this? waiting for ur reply

aru v · Answer

Hi, Are you storing the Image path in SQL or the Image itself? Thanks, Aru

Ruchi R · Answer

Thanks for ur reply. Actually i am new user of asp.net .So can u plz tell me how to do all this.Waiting for ur reply.

Gorgi Markovski · Answer

I think is better to save link of that picture in the SQL and after call the link of that picture.

displaying images in aspx file or in gridview

Answers (11)