Using ASP.NET 3.5 / VS 2008 / C#.

I decided to finally try to use the SqlDataSource - after hearing about how it handles paging / sorting automatically (albeit with some efficiency issues).

The GridView displays initially, then no paging or sorting happens. Just a page postback.

I assign the connectionstring and SelectCommand in a Button click event.

If the GridView supposed to be DataBound on each Page Load when using a SqlDataSource? I have tried all sorts of combnations with no luck.

scptech:

I assign the connectionstring and SelectCommand in a Button click event.

If the GridView supposed to be DataBound on each Page Load when using a SqlDataSource?

IF you do specify the connection and SelectCommand declaratively, you won't need any additional code on each postback (page load)...all you'd do is specify the AllowPaging and AllowSorting properties on the GridView.

check out the links for some examples.

Thank you for responding.

I do not assign connection or SelectCommand declaratively. 

it (SqlDataSource) doesn't store the SelectCommand in the ViewState. you'll need to set up a ViewState variable in the button click and restore it to the SDS on page load.

        protected void Page_Load(object sender, EventArgs e)
        {
            if (ViewState["Select"] != null)
            {
                SqlDataSource1.ConnectionString = @"your connection string here";
                SqlDataSource1.ProviderName = "System.Data.SqlClient";
                SqlDataSource1.SelectCommand = ViewState["Select"].ToString();
                GridView1.DataSourceID = "SqlDataSource1";
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string sqlSelect = "SELECT statement here";
            ViewState["Select"] = sqlSelect;
            SqlDataSource1.ConnectionString = @"your connection string here";
            SqlDataSource1.ProviderName = "System.Data.SqlClient";
            SqlDataSource1.SelectCommand = sqlSelect;
            GridView1.DataSourceID = "SqlDataSource1";
            GridView1.DataBind();
        }