I have a GridView and a datasource. The only properties i set to datasource are the ConnectionStrings, ProviderName, runat and ID as shown below. And according to a criteria i set SelectCommand property of my datasource on my .cs file of .aspx on which exists my gidview. My problem is that; although i set AllowPaging and AllowSorting properties of my gridview to true, it nor sorts or pages the gridview but just disappears. I just wonder how i could get over this?

<asp:SqlDataSource ID="DSourceSirketSec" runat="server" ConnectionString="<%$ ConnectionStrings:Constring %>"

ProviderName="<%$ ConnectionStrings:Constring .ProviderName %>">

</asp:SqlDataSource>

Thanks...

are u setting the select command in the page load inside if(!Ispostback) condition. if yes than that is the problem

vik20000in:

are u setting the select command in the page load inside if(!Ispostback) condition. if yes than that is the problem

No actually, i set the selectcommand in click event of a button.

Hi,

Try this,

In aspx file,

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>"

<asp:Button ID="Button1" runat="server" OnClick="BtnSelect_Click" Text="Button" /><br />

<asp:GridView ID="GridView1" runat="server" AllowPaging="true" AllowSorting="true" OnPageIndexChanging="GridView1_PageIndexChanging" OnSorting="GridView1_Sorting">

</asp:GridView>

In code behind,

if (ViewState["sortExpr"] + "" != "") sort = "order by " + ViewState["sortExpr"] + " " + ViewState["sortDir"];

if(ViewState["sortDir"] + "" == "Asc")

Check this

http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/GridViewSorting.src 

Thanks hspharic, it works fine...