About datagrid

[Chuen]

Hi,
If I use datagrid to operate dataset, my problems is how to display a column
value with its related other value.
I means: suppose there are two tables in dataset,
table1: id name
1 "IBM"
2 "Microsoft"
3 "ASUS"

Table2: id, Date, Qty, note
3 2003/01/01 56 dgsds
2 2004/02/01 35 dfgdfgfd

if displaying table2 in datagrid, How can I hide id and only display its
related value in table1?

Thanks in advance!

Chuen

 

[Rui Dias]

If I were you, I would create a third table with the data you want to show
and use that table to bind with datagrid.