DataSource Controls :: Select Multiple Products With Images?

the best way to achieve the following:A products table linked to an images table where 1 product can have many images.Simple scenario is to select a product and its images using

select * from products where id=5
select * from images where pid =5

So far so good, its easily mapped to an object once the query has executed with ado.net.

what if i want to select all products and their related images and map them to a Product object, the result is as follows

SELECT * FROM PRODUCTS JOIN IMAGES ON ID=PID

Now the table I get is:


ID PRODUCTNAME IMAGEURL

1 COMPUTER IMAGE1.JPG
2 COMPUTER IMAGE2.JPG
3 COMPUTER IMAGE3.JPG

I would need to do some work in c# to keep track of id and get images until the id changes, if you get what I mean.

I want a way that I can execute a single query like the one above, or modifed version and make it easier to map the result to my objects.

Something like,loop products,map products to product object,loop images map images to products.images