How do i join two tables in datagrid. Actually i want to display transaction table and productmaster table. by entering the productcode (which is primary key in product master and foreign key in transaction table) it should display the product details. I am using visual basic 2003 .net