Hello,

I have a problem with Grid and its callback running mode.
I made a function LoadGridData, as you present in your sample, but SQL command doesn't work on MS SQL Server 2005.

The part of the code of SQL command constuction:

string sql1 = string.Format(
"SELECT TOP {0} * FROM KDO ORDER BY {1} {2}",
recordsTillCurrentPage, sortField, sortOrder);

string sql2 = string.Format(
"SELECT TOP {0} * FROM ({1}) ORDER BY {2} {3}",
recordsForCurrentPage, sql1, sortField, sortOrderReverse);

string sql3 = string.Format(
"SELECT * FROM ({0}) ORDER BY {1} {2}",
sql2, sortField, sortOrder);

Please, could you help me?

Thank you.

Best regards,

Milan KOTASKA