Hello.

How can I know by which column a datagrid is sorted? I mean, when I do paging, I have to run a SQL query to get the next new rows to show the next page. And say the grid originally is sorted by ComumnA - to keep the grid sorted by ColumnA on the next page, this ColumnA must be passed to the new SQL query when the GridItemReports_PageIndexChanged event is fired.

Is this sorted-by-column information available from the grid?

Regards,
HT

Hi

I was wanting to do the same thing. Detect which column is sorted and then use the associated datafield for processing.

however when i spin through the grids columns i do not get the sortorder of other than "none"...although its sorted.


here is what i am doing:

Dim thisC As EO.Web.GridColumn
Dim myKeyFld As String
For Each thisC In EOgrdSizeSummary.Columns
If thisC.SortOrder <> EO.Web.SortOrder.None Then
myKeyFld = thisC.DataField
End If
Next

would you be so kind as to point me to what i am doing wrong?

Thanks for your quick response:

1. i call this first (after i fill the grid, also tried before i fill)

Private Sub initGridColumns()
Dim thisC As EO.Web.GridColumn

For Each thisC In EOgrdSizeSummary.Columns
thisC.SortOrder = EO.Web.SortOrder.None
Next
End Sub

which should set all the columns right?

2. then i click a column and sort it
3. i then click a button which checks the column.sortorder (previous post code snippet)

still does not ever change from sortorder.none

is there something else that could be wrong?

Would you happen to have a nice little code snippet on how to get that to work?

thanks!

i see the problem i have run mode set to client not server...is there anyway to do this same thing functionally with run mode set to client?

i should have mentioned that i tried that earlier.

i added a button to the "Client running mode demo" traced the button event and it only comes back with the first column which it (the demo) originally set to ascending - on
btnSorting_CheckedChanged event.

So you are saying there is a way that you can have running mode set to client. sort by a column. then click another button and interogate that column for its sortorder?


---
here is my code to see which column i sorted by...dont work


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim sortColumn As EO.Web.GridColumn = Nothing
Dim column As EO.Web.GridColumn
For Each column In Grid1.Columns
If column.SortOrder <> EO.Web.SortOrder.None Then
sortColumn = column
'this only gets the first - columns(1) but if i sort any other columns no good..
i sorted by topic.

from the debugger: DataField "PostedAt" String

End If
Next column
End Sub

thanks so much...

hey dont you ever stop...its quiting time...btw i am up the road from you guys - ocean ridge.

Hi,

We have posted a new build (2008.0.68) that addressed this issue. Please see your private message for download location.

Thanks!