Turning off sorting

[Jason Southgate]

Hi,

Do you know any way to turn off sorting, i.e. clicking the column headers? Thanks.

Jason Southgate.

[Administrator]

Try setting:

this.grid.TableOptions.AllowSortColumns = false;

[Jason Southgate]

Thanks Clay, Perfect.

Jason.

[Administrator]

Clay,

Is there any way to turn off an already existing sorting and also which is already sorted.

For example, if I have a sequence column, and it is sorted ascending/descending, when I want to update this column(all rows from top to bottom, but in a different order), I don''t want the rows moving around, while I am updating each and every row. So, I want to turn the sorting off, before updating.

Help me!

Thanks,
Bits.

[Administrator]

Hi Bits,

The records always have to be in the exact sort order specified by the sorting criteria. Otherwise the engine will get confused about the position of records since it assumes that records are sorted in the sort order specified.

If you have lots of updates and do not want records to be rearranged while the updates are coming in you can set grid.Table.TableDirty = true;

When you set TableDirty = true no further updates will be handled until you access records in the engine or redraw the grid.

However, you should also then avoid accessing records through the engine.Table.Records collection. Instead you should modify the underlying dataset directly.

Stefan

>Clay,
>
>Is there any way to turn off an already existing sorting and also which is already sorted.
>
>For example, if I have a sequence column, and it is sorted ascending/descending, when I want to update this column(all rows from top to bottom, but in a different order), I don''t want the rows moving around, while I am updating each and every row. So, I want to turn the sorting off, before updating.
>
>Help me!
>
>Thanks,
>Bits.

[Administrator]

What is the equivalent of gird.table.tabledirty = true in GDBG.

[Administrator]

SuspendBinding, ResumeBinding and then Refresh().

Stefan

[[e-mail]]

Hi Expert,

I am using GridDataBoundGrid. I try to turn off the sorting but I can not do it. Please help me!. I can not see the property ''TableOptions.AllowSortColumns'' in GridDataboundGrid.

Thanks,
Len.

>Try setting:
>

>this.grid.TableOptions.AllowSortColumns = false;
>

[Administrator]

In GridDataBoundGrid, try:

this.gridDataBoundGrid1.SortBehavior = = GridSortBehavior.None;