How to use DataTable.Select(filterExpression, SortExpression) method

[pinkpoppy]

I have a dropdownlist of names that I call from a web service. I need to select distinct, firstname, middlename, lastname, then order by lastname ASC. Can anyone help me on this? I am having some issues getting this to work.

Thanks, any help is appreciated!

 

[jbenson001]

To distinct:
newDataTable = origDatatable.DefaultView.ToTable(True, "Column you want to DISTINCT")
OR
newDataTable = origDatatable.DefaultView.ToTable(True)) //Will distinct on all columns in the datatable

Check out the overloads for the ToTable() method.

To sort, look into using a dataview