I have the need to bind two different datasources to one datagrid.
I have one datagrid that pulls all entries from a mysql database (table only has a few hundred entries). This table represents a product catalog. Then I have a second table that represents the purchase history for all of the products. Any product will only be sold 1-4 times. So my user wants to see all of the people that have purchased a specific product, and the user wants to see all of their names in a single field inside of the existing datagrid. The link between tables in the product_id, which is in the datagrid already.
So, my basic question is... How do I aggregate the return from a second query into a single field in the existing datagrid? Code examples would be greatly appreciated.
Not sure how hard this is, but if I need to assign more points I will.
Thanks in advance for the help.
P.S. I'm pretty new to asp, and I'm using VB as my language (I'm moderately familiar with VB).
P.P.S. The user isn't interested in a nested datagrid approach or anything that would require the push of a second button. The user is pretty lazy ;)