[bin]

hi everybody...
i'm trying to display images along with the image details stored in mysql database thru my webpage... the best i can do is display one image but no details ... i can retrieve all images as needed and store it someplace but i'm not able to display it

any kind of help will be appreciated...
this is the current code...

Dim con As New OdbcConnection(ConfigurationSettings.AppSettings(" ConnString"))
Dim da As New OdbcDataAdapter("select * from products", con)
Dim CmdB As New OdbcCommandBuilder(da)
Dim ds As New DataSet

Dim arr As Array
con.Open()
da.Fill(ds, "products")

Dim row As DataRow
row = ds.Tables("products").Rows(0)
Dim data() As Byte
Dim k As Long
Dim fs As FileStream
Dim strfilename As String

Response.Buffer = True
Response.ContentType = "image/jpeg"

For Each row In ds.Tables("products").Rows
arr = row.ItemArray
data = row("image")
strfilename = "\Shy\" & arr(0)
k = UBound(data)
fs = New FileStream(strfilename, FileMode.OpenOrCreate, FileAccess.Write)
fs.Write(data, 0, k)
Response.BinaryWrite(data)
Next

fs.Close()
fs = Nothing
CmdB = Nothing
ds = Nothing
da = Nothing
con.Close()

[bin]

wht u do is...
1.make a field in the db which stores the path to the image (which is better than storing actual image in the db)

2.in the datagrid where u want to display the image add a bound column as this field... (do this by property builder). then convert this bound column to template column.

3. on the datagrid right click and select edititemtemplate and the column .
in the column tht appears drop an image control along with the label tht u see in the itemtemplate.

4. in the html page add this
ImageUrl='<%# DataBinder.Eval(Container, "DataItem.imageurl") %>'
in the <img> tag. so that it looks like this....

<asp:TemplateColumn HeaderText="imageurl">
<ItemTemplate>
<asp:Image id=Image4 runat="server" Width="101" ImageUrl='<%# DataBinder.Eval(Container, "DataItem.imageurl") %>' Height="101">
</asp:Image>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id=TextBox1 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.imageurl") %>'>
</asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>

5. in code page... fill the datagrid by connection, sql select statement, dataadapter and dataset. and atlast datagrid.databind().