relation

Hi 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" 1 3 2 4 table2 : "ID"...

I have 2 tables in my dataset: - Items - Warehouse 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...