displaying data from multiple table in a one gridview

Hello All,

I've three tables namely - orders (pk as order_id and fk as custprod_id); customerProduct (pk as custprod_id and fk as prod_id); product(pk as prod_id). Now I want to display the data in the orders table in a gridview but instead of custprod_id , I would like to display product name which is present in product table. Could any suggest the way to code. Thank you in advance.