Hi, 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: Assign activity: row(“a”) = dt.AsEnumerable().Where(Function(key) key(“number”).ToSt…

Handling empty values with FirstOrDefault

Yoichi (Yoichi) July 24, 2022, 12:27pm 2

Hi,

How about the following expression?

dt.AsEnumerable().GroupBy(Function(r) r("number").ToString.Trim.Contains(row("id").ToString.Trim)).Select(Function(g) if(g.Key=True,g.First().Item("id").ToString,"")).OrderByDescending(Function(s) s).First()

Regards,

1 Like

Convert expression to conditional

Topic		Replies	Views
Convert expression to conditional Activities database , activities , question	2	695	July 24, 2022
Linq query group by rows and group the value Studio studio , question , activities_panel	5	2264	February 22, 2021
Linq object reference Activities system	5	666	April 13, 2022
LINQ error? Activities excel , activities , question	4	1002	February 1, 2022
Set the date with LINQ Activities datatable , excel , robot , activities , studio , question , activities_panel , linq	10	2652	February 16, 2022

Most Active Users - Yesterday
Anil_G
jast1631
yuichi
More details...

Handling empty values with FirstOrDefault

Related topics