Hi all,
When I debug the file it show the error: Assign: The source contains no DataRows. I know because no row was found. How can I check row>0 before copytodatatable. Thank you
(From d1 In dtDeposit2.AsEnumerable()
Let lid = d1(0).ToString().Trim()
Where dtCustomer1.AsEnumerable.Any(Function (d2) d2(0).ToString().Trim().Equals(lid))
Select r = d1).CopyToDataTable