Hello Eric,

Our hierachical sample, you should be able to do sorting in their child. Same result should show in LoadOnDemand scenario.
At least we need to replicate your issue. Is it possible for you to send me a simple sample that replicates your issue?
FYI, you can also apply a customSort. Please open our WebGrid documentation and search about "CustomSort".
Hope this helps.

Regards,
Handy

Hi Handy,

I know how the CustomSort works. Thanks for this suggestion anyway. But my problem is that it doesn't sort at all, not even alphabetically.

I'm not sure which sample you mean. I cannot find samples on your homepage. So I went to search on what was installed with your product. There is no installation, but I found a tutorial with some samples. In the folder C:\Program Files\Intersoft Solutions\WebGrid.NET 6.0\Tutorials\WG60TutorialsVB\V5.0 I found a sample called SelectSelfRefChildRow.aspx, which would be the most closest to what I want. But that sample has sorting disabled.

The other three samples there that begin all with Hierarchical_... all have sub-tables with separate titles. This is not what I need.

If you look at my sample here:

http://www.intersoftpt.com/Community/WebGrid/Design-question-How-to-add-OnClick-Handler-on-a-field-in-WebGrid/

and take the MergeButtonSample_v3.zip, and open the file DBCalls.vb and in Sub AddRow add this code:

r("R_a") = Rnd()
r("R_b") = Rnd()
r("V_a") = Rnd()
r("V_b") = Rnd()

just before the If Not ParentBlockId...

Then run the sample and try sorting on any field. You can see that the sort-triangels appear in the header, but nothing gets sorted. This is what I meant.

Does this work with a newer WebGrid or do I have to write code for this? If code, then how?

Thanks,

Eric

Hello Eric,

Your issue is under investigation. I will let you know asap.

Regards,
Handy

Any updates yet?

Hello Eric,

I am sorry for the late response. I think you were missing to apply sorting for the child level.
In selfReference, you could not apply the normal sorting. You would need to ApplyChildSorting properties in selfReference scenario.

e.g in grdResult_Init, please add this following settings.

  grdResult.RootTable.SelfReferencingSettings.ApplyChildSorting = True

Hope this helps.

Regards,
Handy

Yes! This is what was missing. Thanks a lot!