[Solved] q2 2009 radgrid: index [pagesize] is either negative or above rows count.

[Terry Hoiness]

After sorting with the radgrid then changing pages (or the reverse), I get: "index [pagesize] is either negative or above rows count."

The code is quite simple

    protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
    {
        DataTable dt = dm.GetDtFromSQL(string.Format(SQLTemplate, ViewState["showID"]), "", ViewState["showID"].ToString(), false);
        if (dt.Rows.Count > 0)
        {
            DataView dv = dt.DefaultView;
            dv.RowFilter = ViewState["filter"].ToString();
            dv.Sort = string.Format("{0} {1}", ViewState["sort"], ViewState["order"]);
            RadGrid1.DataSource = dv;
        }
        else
        {
            RadGrid1.DataSource = null;
        }
    }

[Terry Hoiness]

DISREGARD.  I was sorting the datatable on every NeedDataSource() call... 

[Nick]

Hi Terry Hoiness,

Thank you for sharing with the community the solution.

Best wishes,
Nick
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.