🚀 go-pugleaf

John Mace wrote:

> Hi,
> 
> Using D2006E, I'm having a problem sorting a DBWebGrid. When I set
> AllowSorting to True, the header is underlined and makes a round trip
> to the server when clicked as expected. Althought the Sort Expression
> is properly set through the Property Builder, the grid is not sorted.
> 
> It seems to me that there is sufficient information in the property
> settings to perform the sort. What am I missing?
> 
> John

Hi John,

You need to add a SortCommand event handler and perform the sorting
yourself.

A couple of things to be aware of with the dbwebgrid. When you postback
it applies any changes you have made on the client into the dataset.
You therefore have to make sure that the selected row is the same
before and after you have applied the sort. Something like

SortCommand(source:TObject;e:DataGridSortCommandEventArgs)
begin
selectedIndex:=dbWebGrid1.SelectedIndex
{get the primary key value for that row
{perform the sort}
{find the index of the row with the primary key value}
(dbWebDataSource1 as Borland.Data.Web.IDBPostStateManager).SetCurrentRow


end

The other thing you need to be aware of that the dbwebdatasource is
caching the dataset and I think this interferes with the sorting so set
AutoRefresh to true and do the caching yourself.


Cheers,
John
--