You should not use the Finalize() method of your class to close
a database connection or a DataReader instance due to the non- nondeterministic
nature of finalization in Microsoft .NET. To learn more on Microsoft .NET. To learn more on
. when and how you can use Dispose() and Finalize() efficiently,
refer to my article at:
http://www.devx.com/dotnet/Article/33167
The GetSortedEmployees() method needs to be called in place of the
GetEmployees() method for displaying the sorted employee data in the user
interface based on the sort column selected by the user.
Now we have to make the following change in the BindPagedData() method to
incorporate the sorting functionality:
if(sortColumn == String.Empty)
pagedDataSource.DataSource = dataManager.GetEmployees();
else
pagedDataSource.DataSource = dataManager.GetSortedEmployees(sortColum
n);
We are done! You can now click on any of the links on the header (those that
correspond to the respective columns in the employee result set) and see the data
being displayed in the Repeater control in a sorted manner.
Chapter 3
[ 81 ]
Filtering Data Using the Repeater Control
This section discusses how we can implement custom filtering of the data displayed
in the Repeater control. For filtering data from the employee result set, we will use a
DropDownList that is populated with the department names and, depending on
the user's selection, the employee records for the selected department will be
displayed in the Repeater control.
Pages:
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92