IWDBAdvWebGrid Sort

How the sort working in the IWDBAdvWebGrid? In the sort settings show is true and hyperlink is coming in the column header. When click on it the column header it is not sorting. In the Grid i have multiple pages and when click on the column header it should sort the entire records. I enabled AsyncSorting and put the below code in the AsysncSortclick then also it didnt work.

 TIWDBAdvWebGrid1.SortSettings.Column := ColumnIndex;



For the sorting to work in the TIWDBAdvWebGrid you will need to customize the SQL property value of the TADOQuery control based on the SortSettings.Column value.