Setting up the DataGrid
First, there are several things that must happen to a DataGrid before you can sort -
You must turn AutoGenerateColumns on (=true). This means that you will lose any special columns and lose the ability to edit the data. It is a wise idea to create one page for viewing and another for editing.
You must add the attribute AllowSorting and set it to true. This makes each column header a link that will reload the page when clicked.
You must add the attribute OnSortCommand and set it to the method that will sort the data (in this case dg_sort).
You must add the method dg_sort.
We will be using the same page that we have been using for the whole series to view the data. See part 6 for a complete listing of that page. After making these changes, your DataGrid will look like this -
|<asp:DataGrid id="dg" runat="server"|
(The changes are in red.)
Here is a picture of what the DataGrid should look like -