Please Help Displaying Images in Datagrid

B

blackg

I need help to display images from my table in a datagrid

I have two tables that are join together. Product_Image and Product

my select query is :
SELECT
Product_Image.ProductID,Product.Product,Product.Price,Product_Image.SMimgdata
FROM Product_Image INNER JOIN
Product ON Product_Image.ProductID =
Product.ProductID
where ProductID = ProductID

Note the ProductID is a foreign key in the Product_Image Table

The SMimgdata is a binary datatype:

What I want is that the Datagrid should display the Product, price and
the image
Could somebody help me with a brief sample.

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,995
Messages
2,570,228
Members
46,818
Latest member
SapanaCarpetStudio

Latest Threads

Top