Display image along with the grid view

[Lost User]

Hi All, I am working on an application where I wants to display employee details in GridView. The image of the employee is stored in SQL Server 2005 table as image field . Now I wants to display the data along with the grid so how to display this can anybody help me with code. Thanks Regards

Sujit

[N a r e s h P a t e l]

Hi, First save your image to Sql Server 2005[Database] in Byte Format.And then receive it as a Byte array format at server side. NOw you have to cast this image into Stream and then into write this Stream into another UserControl. But I am suggesting you not to store Your Image into DataBase, store it into FileSystem.

Naresh Patel

[Lost User]

Hello Yes You are right.But This is requirement is like that we have to store 2 images in sql server database.I have stored image in database successfully.I am facing problem in showing this image in gridview.

Sujit

[N a r e s h P a t e l]

Hi Please wait i am giving you the code for it.

Naresh Patel

[N a r e s h P a t e l]

Hi, Please view the atricle for Displaying And Storing Image to Database at http://www.codeproject.com/useritems/Image.asp

Naresh Patel

[DarynRoberts]

Hey man. We were having the same problem. Try do this. When you store it in the database...store the full url of where the picture can be found within your project. For example...our image is stored inside a folder called "Properties" which is inside a folder called "Images" So it finally worked when we saved it in the DB field as: ~\Images\Properties\officeblock1.jpg Hope that helps peace

Dazz

[Lost User]

Yea You are right.I am generally follow yours methods.That is quite good.but i have to store this in sql server.i am trying to do this.

Sujit

[Lost User]

Hello Yes yours code is good.i have already done this.only problem i am facing to displaying those images in grid view.i can easily show this in aspx page by retrieving image from sql server.

Sujit