Count from Datatable with different filters linq

Help Studio
1

Hi all, I have found a Linq function in the forum that gives me the number of a certain value, that works so far. Now I am faced with the challenge of having to set another filter for the value, as in the example, but this does not work as hoped, who can help me with this?

inputDT.AsEnumerable.Count(Function(r) r(“Date”).ToString=“”) and inputDT.AsEnumerable.Count(Function(r) r(“ANR”).ToString="Test)

2

Hi @NHoe ,

Could you try this instead?

inputDT.AsEnumerable.Count(Function(r) r(“Date”).ToString="" and r(“ANR”).ToString="Test")

Kind Regards,
Ashwin A.K

3

so easy, thank you it works!

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.