how do I resort colums after databound grid refresh?

[Patrick Rumery]

I know the column and the listsortdirection before I refresh the data in the grid, but the column only sorts ascending even when I tag it like the code below.
If _SortType = 0 Then
Me.dgSales(0, _SortCol).Tag = ListSortDirection.Ascending
Else
Me.dgSales(0, _SortCol).Tag = ListSortDirection.Descending
End If
dgSales.SortColumn(_SortCol). I'm using
Public WithEvents dgSales As GridHierDataBoundGrid as my grid.

thanks

[Administrator]

Hi Prumery,

In DataBoundGrid, you can set these tag properties only through the Model.QueryCellInfo event handler. One way you can acheive this would be to set a flag in the your sort module and check this flag in order to enable the sorting icon for the header cell in the Model.QueryCellInfo.

//Or

You can use the DefaultView.Sort property of the underlying datasource in a grid to control the sort direction. Here is a code snippet to show this

DataTable dt = this.gridDataBoundGrid1.DataSource as DataTable;

//Ascending order.
//dt.DefaultView.Sort = "[ColumnName] ASC"; // or //dt.DefaultView.Sort = "[ColumnName]"

//descending order
//dt.DefaultView.Sort = "[ColumnName] DESC";

//Cancel the Sorting...
//dt.DefaultView.Sort = "";

this.gridDataBoundGrid1.Refresh();

Best Regards,
Haneef