Sorting a DataTable

[tadd]

I wrote some code to sort my DataTable. Please refer to the code below:

// -------------------------------------------
// dsData is a DataSet containing a DataTable called "Table" that is loaded with unsorted data.
// I want the data in this DataTable to be sorted by PayeeName.

DataView dvData = new DataView(dsData.Tables[0]);
dvData.Sort = "PayeeName ASC";
dsData.Tables.Remove("Table");
dsData.Tables.Add(dvData.ToTable());
// -------------------------------------------

Is this an acceptable way to sort the DataTable, or is there a better way?

Thanks for any pointers.

 

[litton1]

Without actually answering the question directly because to be honest I am not actual sure if this a good way or not, only that if there where 5000+ records in there it may take a while.. Could it not be sorted at the data source, assuming it is a database of some type. With an Order By Clause? If not it may be quicker to put in one and take it back out...

Age is a consequence of experience