yes i have to manually populate the list and in my dataadapter i have the following query
SELECT Supplier.Supplier_name, Product.Product_Id, Product.Product_Name, Product.unitprice, Product.descp, Product.sup_stockcode
FROM Product LEFT OUTER JOIN
Supplier ON...