Linq query to sort

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


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

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

Use index 0 for first match like below.

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