And sorting rows in a datatable

[ Team LiB ] Recipe 3.2 Using Expression Columns to Display Calculated Values Problem You need to display a calculated value for each row in a DataTable and to filter and sort the table on this value. Solution Add an expression column to the table and display it.

4p luvpro 04-08-2010 72 7   Download

[ Team LiB ] Recipe 3.9 Finding Rows in a DataView Problem You need to find a row or group of rows in a DataView meeting certain criteria. Solution Use a sorted DataView to find rows using columns that are not part of the primary key. The sample code contains two event handlers: Form.Load Sets up the sample by creating a DataTable containing the Orders table from the Northwind database. A DataView of the table sorted by the CustomerID and EmployeeID is created. Find Button.Click Uses the FindRows( ) method of the DataView to retrieve the array of DataRowView objects...

4p luvpro 04-08-2010 119 5   Download

Finding, Filtering, and Sorting Rows in a DataTable Each row in a DataTable is stored in a DataRow object, and in this section you'll learn how to find, filter

7p daisuphu 29-07-2010 95 10   Download