🚀 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
-- 

Hi John,

What, then, do you suppose is the purpose of the Sort Expresson on the 
Columns tab of the Property Builder?

I notice that neither the Data Member nor the Data Key Field on the General 
tab of the Property Builder are persisted. Since both of these values would 
be required for the DBWebGrid to perform a sort, I suspect that this is 
related to the problem. Would you agree?


John

"John Moshakis" <john@moshakis.com> wrote in message 
news:43e18447@newsgroups.borland.com...
> 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
> -- 
>