Displaying images in gridview using code

takwirira · May 21st, 2008, 01:02 PM

The code below is used to get data from a database and displays it in a gridview. the last column l_image displays for example picture1.jpg text. Using code how can I change that to appear as a picture ? Thanks

Code:

        Dim da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM lettings", myConnection)
        ' create a new dataset

        Dim ds As DataSet = New DataSet
        ' fill dataset

        da.Fill(ds, "lettings")
        ' Attach DataSet to DataGrid

        GridView1.DataSource = ds
        GridView1.DataBind()

weicco · May 23rd, 2008, 06:25 AM

Well, of course you can't change string "picture1.jpg" to an image. You need to have the image data somewhere. So the question is, where does the actual image come from?

robzyc · May 23rd, 2008, 06:28 AM

The Image path needs to either be stored relative to the site itself (i.e. "~/images/lettings/picture1.jpg") you can then simply set the ImageURL property of the Image Web Control. Done :)

Rob
http://robzyc.spaces.live.com