hi when iam use this query for gridview in asp.net AND gridPaging
when sorting by CountDevice then go next paging .
Incorrect syntax near 'COUNT'.
System.Data.SqlClient.SqlException: Incorrect syntax near 'COUNT'.
<asp:SqlDataSource ID="SQlD" runat="server" ConnectionString="<%$ ConnectionStrings:ICTPortalDBConnectionString %>"
SelectCommand="SELECT FDeviceOwnerID,FUserName, FFamily + ' ' + FName as [FullName] COUNT(*)CountDevice FROM [VDB_Device] GROUP BY FUserName ,FDeviceOwnerID ,FFamily,FName order by FullName"></asp:SqlDataSource