I am facing an issue about I need to fill a table from another one based in some condition, and I have to do it with linq queries.
I am doing a for each row from dt_main and assign:
For each row in dt_Main:
row(“a”) = dt.AsEnumerable().Where(Function(key) key(“number”).ToString.Trim.ToLower.Contains(row(“ID”).ToString.Trim)).FirstOrDefault()(“id”)
The issue is when “id” is empty it gives the message error: Object reference not set to an instance of an object.
Do you know how can I handle this issue?