How to get total rows count of Radgrid

[jeevitha]

Hi i need to display the count of rows of the grid in the top of my page. I used the follg code. but it shows the count of that page alone. i want all the rows irrespective of the pages. and i also need to display the pages co9unt. pls help me
  protected void gridViewPograms_ItemDataBound(object sender, GridItemEventArgs e)
        {
            int i = gridViewPograms.Items.Count;
            labelCount.Text = i.ToString();
        }

Thanks,
Jeevitha

[Shinu]

Hello Jeevitha,

Try the following code in order to get the total number of items.

CS:

    protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.AllowPaging = false;
        RadGrid1.Rebind();
        Label1.Text = RadGrid1.MasterTableView.Items.Count.ToString();
        RadGrid1.MasterTableView.AllowPaging = true;
        RadGrid1.Rebind();
    }

-Shinu.

[Richard]

I'm joining the discussion a little late, but here goes:

On the server side I want to get the total number of rows/items in the grid without having to do an extra rebind. 

As it currently stands. <grid>.Items.Count and <grid>.MasterTableView.Items.Count both return the number of items in the current page, not the total for the grid.

Rich Sorensen

[Shinu]

Hi Richard,

Please try the following code snippet to get the total count of items irrespective of paging.

C#:

protected void RadGrid1_ItemEvent(object sender, GridItemEventArgs e)
{
    if (e.EventInfo is GridInitializePagerItem)
    {
        int rowCount = (e.EventInfo as GridInitializePagerItem).PagingManager.DataSourceCount;
    }
}

Thanks,
Shinu.

[Richard]

Thanks - the logic works. 

However, it would be nice to have a property on the grid control that could be accessed after a rebind operation rather then implementing more event code which would be called repeatedly.

[Justin]

Try this:

int i = gridViewPograms.MasterTableView.VirtualItemCount

[Mark]

Hi Justin,

That wont do im afraid, that will give you the limit of what you set your virtual count at

[Allen]

SO why can't you just set VirtualItemCount to the number of rows in the DataTable in Needs_DataSource ??? 

 It's just a statistic in this case.

[Allen]

and this seems to work for a grid with 20K rows...

 

[Eyup]

Hi All,

You can also give this approach a try:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridPagerItem)
    {
        GridPagerItem pagerItem = e.Item as GridPagerItem;
        int itemsCount = pagerItem.Paging.DataSourceCount;
        Label1.Text = "Total items count: " + itemsCount;
    }
}

Hope this helps.

Regards,
Eyup
Telerik