Tbgridview Problem Sorting And Paging

Hello everyone, i have a tbgridview in my aplication with the following error:

The grid has ID, NAME, SURNAME, COMPANY, ROL columns, and when the user click to sort in some column it run well, except if click to sort in ROL column. In this case when the pagination is in avanced number, the data of the grid is the same and doesn’t change.

I use Sqlserver 2008.

I have investigated it and i think that the problem is what the ROL column has only 3 differents values and the internal query fails when try make the limit pagination using order by that column.

I must to say that the same problem i have it in all tbgridviews of the aplication when the column has few differents values.

Sorry for my bad english.

Could you helpme?