I am a newbie for vb.net. I am trying to related two tables in a DataSet. I have looked through a lot of threads but could not find the answer I want. Say, I have two tables:
table1 : "ID", "ID in table 2"
table2 : "ID"...
I have 2 tables in my dataset:
The Items table contains a column named 'WarehouseID'. It tells me which warehouse this item belongs to.
The Warehouse table contains an 'ID' column and a 'Name' column.
Now if I display the contents of Items table in a datagridview I will...