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

hi,
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 vb.net code. See djalonsoc’s reply on post https://stackoverflow.com/questions/12472913/sorting-a-data-table .

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.