I have 2 datatables. datatable1 and datatable2.
datatable 1 contains receipt number and shop name only
datatable 2 contains receipt number and price
I need to put the price into datatable1 also.
Normally I would use for each row and row.item(“receiptnumber”).tostring.contains(“price”) to find it.
The problem is datatable 2 has 45,000 rows and it can take a really long time til it processes.
Is there another way that may be faster?