<asp:GridViewid="gridview"
runat="server" DataSourceID = "SqlDataSource1"
PageSize="30" EmptyDataText = "No Records Found" EmptyDataRowStyle-HorizontalAlign ="Center"
AllowPaging="true"
HorizontalAlign="Center" BorderColor ="Black" Width = "762" Font-Names="Calibri"
AllowSorting = "true" Visible= "false" >
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ appSettings:connString %>"
SelectCommandType ="StoredProcedure" SelectCommand = "All_Records" >
First time on page load
Sorting works fine
But if I done sorting on gridview column then its always the same , How to assign result of SQL query to my result
so that my sort will show result from sql query order not the order of grisview sort
Please help me