Sort the DataGrid content using the DataGrid column header

Private void mdb_dealer_sortcommand (Object source, system. Web. UI. webcontrols. datagridsortcommandeventargs E)
{
If (viewstate ["sortfield"]! = NULL & viewstate ["sortfield"]. tostring (). indexof (E. sortexpression) = 0)
{
If (viewstate ["sortfield"]. tostring (). indexof ("DESC")> 0)
Viewstate ["sortfield"] = viewstate ["sortfield"]. tostring (). Replace ("DESC", "ASC ");
Else
Viewstate ["sortfield"] = viewstate ["sortfield"]. tostring (). Replace ("ASC", "DESC ");
}
Else
Viewstate ["sortfield"] = E. sortexpression + "ASC ";
Call the DataGrid binding event;
}
When writing SQL statements in the DataGrid binding event, make sure to judge whether viewstate ["sortfield"] is null at the end! Order by sorting is required if it is not empty!