Using the Default Sort Algorithm

If you want to sort the DataRowView objects in your DataView based on the primary key of your DataTable, you can use a shortcut. Instead of setting the Sort property of your DataView, you set the PrimaryKey property of your DataTable and then set the ApplyDefaultSort property of your DataView to true.

The Sort property of your DataView is then automatically set to the primary key of your DataTable. This causes the DataRowView objects in your DataView to be sorted in ascending order based on the primary key column values.

Let's take a look at an example. The following code sets the PrimaryKey property of the customersDT DataTable to the CustomerID DataColumn:

 customersDT.PrimaryKey =   new DataColumn[]   {     customersDT.Columns["CustomerID"]   }; 

The next example sets the ApplyDefaultSort property of customersDV to true:

 customersDV.ApplyDefaultSort = true; 

The Sort property of customersDV is then set to CustomerID, which causes the DataRowView objects to be sorted by the ascending CustomerID values.

Note 

You'll find the code examples in this section in the UsingDefaultSort.cs program. The listing is omitted from this book for brevity.




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net