- Joined
- May 6, 2011
- Messages
- 13
- Reaction score
- 0
Hi, I am currently using vb.net to try and populate a datagridview
The issue i am having is with the below;
I have 1 dataset, and in the dataset i have 2 tables
table 1
JobNo StockCode Qty
1 a 2
2 b 3
3 c 2
4 d 3
5 e 2
6 f 3
table2
JOB StockCode DeliveryDate
1 a 01/01/2017
2 b 01/02/2017
3 c 05/03/2017
i will need to join the above and view in a datagridview as shown below
JobNumber StockCode Qty DeliveryDate
1 a 2 01/01/2017
2 b 3 01/02/2017
3 c 2 05/03/2017
How would i go about doing this? I have already set the relation using the following
dsJoin.Relations.Add("JobNumber", dtFlightScreen2.Columns("Job"), dtFlightScreen.Columns("JOBNO"), False)
any help would be greatly appreciated.
The issue i am having is with the below;
I have 1 dataset, and in the dataset i have 2 tables
table 1
JobNo StockCode Qty
1 a 2
2 b 3
3 c 2
4 d 3
5 e 2
6 f 3
table2
JOB StockCode DeliveryDate
1 a 01/01/2017
2 b 01/02/2017
3 c 05/03/2017
i will need to join the above and view in a datagridview as shown below
JobNumber StockCode Qty DeliveryDate
1 a 2 01/01/2017
2 b 3 01/02/2017
3 c 2 05/03/2017
How would i go about doing this? I have already set the relation using the following
dsJoin.Relations.Add("JobNumber", dtFlightScreen2.Columns("Job"), dtFlightScreen.Columns("JOBNO"), False)
any help would be greatly appreciated.