Linq query to sort

Help Studio
1

DTRawReport.AsEnumerable.Where(Function (x) x(str_CurrentVC).ToString.Equals(str_CurrentSCValue)).Toarray …how can i get only even number of records like only fst matches

2

Hi @Amrutha.mg

Do you want to Sort or you want to get the rows at even numbers.
Please explain by providing the input and output example.

3

i just want only the first matches…like if there are 4 rows that matches the same criteria i want only fst match

4

@Amrutha.mg

Use index 0 for first match like below.

DTRawReport.AsEnumerable.Where(Function (x) x(str_CurrentVC).ToString.Equals(str_CurrentSCValue)).Toarray(0)