Grid Displays "No Records to display" on Page Changed Event

[Abdul]

Dear Team,
I am using datareader to bind data with grid. Works fine for first page but when a page index is changed or page size is changed grid displays no records...
it shows the new page or resized page correctly when I reload the page this is serverside code please tell me if i am missing something

protected void NeedDataSource()
{
    grd_report.Visible = true;
    if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)
    {
        String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");
        String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");
        obj_sales.initConnection();
        obj_sales.nwideTotalSalesSummary(_todate, _fromdate);
        grd_report.DataSource = obj_sales.getResults();
        grd_report.DataBind();
    }
}
protected void PageSizeChanged(object source, Telerik.Web.UI.GridPageSizeChangedEventArgs e)
{
    NeedDataSource();
    grd_report.Rebind();
}

        protected void NeedDataSource()

        {

            grd_report.Visible = true;

            if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)

            {

                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                obj_sales.initConnection();

                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);

                grd_report.DataSource = obj_sales.getResults();

                grd_report.DataBind();

            }

        }

        protected void PageSizeChanged(object source, Telerik.Web.UI.GridPageSizeChangedEventArgs e)

        {

            NeedDataSource();

            grd_report.Rebind();

        }

        protected void NeedDataSource()

        {

            grd_report.Visible = true;

            if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)

            {

                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                obj_sales.initConnection();

                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);

                grd_report.DataSource = obj_sales.getResults();

                grd_report.DataBind();

            }

        }

        protected void NeedDataSource()

        {

            grd_report.Visible = true;

            if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)

            {

                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                obj_sales.initConnection();

                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);

                grd_report.DataSource = obj_sales.getResults();

                grd_report.DataBind();

            }

        }

        protected void NeedDataSource()

        {

            grd_report.Visible = true;

            if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)

            {

                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                obj_sales.initConnection();

                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);

                grd_report.DataSource = obj_sales.getResults();

                grd_report.DataBind();

            }

        }

        protected void NeedDataSource()

        {

            grd_report.Visible = true;

            if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)

            {

                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                obj_sales.initConnection();

                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);

                grd_report.DataSource = obj_sales.getResults();

                grd_report.DataBind();

            }

        }

        protected void NeedDataSource()

        {

  

protected void NeedDataSource()
{
    grd_report.Visible = true;
    if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)
    {
        String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");
        String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");
        obj_sales.initConnection();
        obj_sales.nwideTotalSalesSummary(_todate, _fromdate);
        grd_report.DataSource = obj_sales.getResults();
        grd_report.DataBind();
    }
}
protected void PageSizeChanged(object source, Telerik.Web.UI.GridPageSizeChangedEventArgs e)
{
    NeedDataSource();
    grd_report.Rebind();
}

         grd_report.Visible = true;

            if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)

            {

                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");

  

protected void NeedDataSource()
{
    grd_report.Visible = true;
    if (IsPostBack == true && txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null)
    {
        String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");
        String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");
        obj_sales.initConnection();
        obj_sales.nwideTotalSalesSummary(_todate, _fromdate);
        grd_report.DataSource = obj_sales.getResults();
        grd_report.DataBind();
    }
}

protected void PageSizeChanged(object source, Telerik.Web.UI.GridPageSizeChangedEventArgs e)
{
    NeedDataSource();
    grd_report.Rebind();
}

             String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");

                obj_sales.initConnection();

                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);

                grd_report.DataSource = obj_sales.getResults();

                grd_report.DataBind();

            }

        }

[Princy]

 Hello Abdul,

I guess you are using simple databinding to populate the grid. Since you enabled paging in grid, a better option is using Advanced Data-binding (using NeedDataSource event) to bind the grid. And RadGrid fires the NeedDataSource event each time it needs to be bound to a data source

Please go through the following documentation for more on binding a grid using NeedDataSource event.

http://www.telerik.com/help/aspnet-ajax/grdadvanceddatabinding.html

Thanks,
Princy.

[Abdul]

I am already using advanced binding

I have method for Need Data Source but when I insert break points on page event control does not go to the method however here is the method that i have

        protected void grd_report_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            grd_report.Visible = true;
            if (txt_todate.SelectedDate != null && txt_fromdate.SelectedDate != null && count == 0)
            {
                String _todate = txt_todate.SelectedDate.Value.ToString("dd-MMM-yyyy");
                String _fromdate = txt_fromdate.SelectedDate.Value.ToString("dd-MMM-yyyy");
                obj_sales.initConnection();
                obj_sales.nwideTotalSalesSummary(_todate, _fromdate);
                grd_report.DataSource = obj_sales.getResults();
               count = 1;
            }
        }

<telerik:RadGrid ID="grd_report" Width="97%" AllowPaging="true" Visible = false
            runat="server" Gridlines="None" Skin="Windows7" AutoGenerateColumns="true"
            ShowStatusBar="true" AllowSorting="true" ShowGroupPanel="true"
             OnNeedDataSource="grd_report_NeedDataSource">
        </telerik:RadGrid>

[Abdul]

it's not invoking onneeddatasource event on page change please tell me the reason

[Pavlina]

Hi Abdul,

Have in mind that when the Visible property of the RadGrid control is set to False, the NeedDataSource event does not fire.When you change the Visible property of the grid to True, you must call the grid's Rebind method so that it can bind to its data. Review this help article for more information.

I hope this helps.

Best wishes,
Pavlina
the Telerik team

[Abdul]

Thanks it's Helpful