Filter data table column sort with use .select or any other method

i have excel file,in that column names like “name and city.”
i want filter data to use .select method
how can filter data table with .select method sort by ascend or descend order column name like 'city"

This can be achieved through code. See djalonsoc’s reply on post .

Hey @Anand_Designer

In order to sort ascending:
dtInput = dtInput.AsEnumerable.OrderBy(function(x) x(“City”).ToString).CopyToDatatable()

In order to sort descending:
dtInput = dtInput.AsEnumerable.OrderByDescending(function(x) x(“City”).ToString).CopyToDatatable()

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