Two Way Sorting only

[Tariq]

Hi Support,

I have two Question: 
Q. 1 =>  I have a situation where I need only two way sorting that is Ascending OR Descending... 
In my grid if I click on column header it works like:

First Click : Ascending Order
Second Click: Descending Order
Third Click: Sorting Removed

I want on third click it should sort it again Ascending order and so on....
An example will be great help.

Q.2. =>  I saw  an example where you are handling 300,000 records in a grid that works at great speed. In that example you are binding data from some web service. 
http://demos.telerik.com/aspnet-ajax/grid/examples/client/caching/defaultcs.aspx

I have 700,000 records for a report and SQL Server 2008 as back-end. I am binding from code behind using DataSet. It is working but it is very slow... it took almost 45 seconds to retrieve data for one screen.

Can you suggest me how can I speed it up like your demo example.

Thanks

[Milena]

Hello Tariq,

To limit the sorting modes to two-way sorting (ascending and descending), set the MasterTableView.AllowNaturalSort property or the GridTableView.AllowNaturalSort property to False. When AllowNaturalSort is False, the automatic sequence of sort modes toggles between "Ascending" and "Descending", without allowing a mode of "NoSort".

Regarding your second question, I would suggest you to review this help article, where are listed different tips for grid performance optimization.

Greetings,
Milena
the Telerik team