purplehaze1
Programmer
Suppose I have two tables: customers and orders. I created two class,
customer and orders.
tbl customer
-----------
custid
custname
tbl orders
----------
orderid
custid
orderName
orderAmt
I want to display customer orders in datagrid.
So, I created orders collection and binded to the datagrid, but it doesn't have customer name, only custid. How can I get custname included in the collection and display in datagrid?
(My actual program has more than 20 tables. If user selects particular order id, I have to display related information for that order from all tables. i.e. address from address table for that customer, email from email table, phone from phone table, etc..., what's the best method to do this?) Thanks.
customer and orders.
tbl customer
-----------
custid
custname
tbl orders
----------
orderid
custid
orderName
orderAmt
I want to display customer orders in datagrid.
So, I created orders collection and binded to the datagrid, but it doesn't have customer name, only custid. How can I get custname included in the collection and display in datagrid?
(My actual program has more than 20 tables. If user selects particular order id, I have to display related information for that order from all tables. i.e. address from address table for that customer, email from email table, phone from phone table, etc..., what's the best method to do this?) Thanks.
