March 2, 2022, 4:00pm
I am trying to joint two tables, but I can not get it to work. After some investigation I found that the two variables are not equal even though they are the same visually as well as types of said variables are the same as well.
output for dt_SQL.Rows(0)(23).ToString - 95049482
output for dt_vagonas.Rows(0)(0).ToString - 95049482
output for (dt_SQL.Rows(0)(23).ToString = dt_vagonas.Rows(0)(0).ToString).ToString - False
Any idea on how to fix this?
Could you try trimming it as well and then compare the two?
(dt_SQL.Rows(0)(23).ToString.Trim = dt_vagonas.Rows(0)(0).ToString.Trim)
March 2, 2022, 4:05pm
we can check for Using LINQ
(From d1 in dt1.AsEnumerable
Join d2 in dt2.AsEnumerable
On d1(0).toString.Trim Equals d2(23).toString.Trim
On which output from Join are interested in detail?
March 5, 2022, 7:39pm
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.