C# – Total row count in GridView control using LinqDataSource and paging

asp.netcgridviewlinq

I'm having a problem obtaining the total row count for items displayed in a Gridview using Paging and with a LinqDataSource as the source of data.

I've tried several approaches:

protected void GridDataSource_Selected(object sender, LinqDataSourceStatusEventArgs e)  
{  
    totalLabel.Text = e.TotalRowCount.ToString();  
}

returns -1 every time.

protected void LinqDataSource1_Selected(object sender, LinqDataSourceStatusEventArgs e)  
{  
    System.Collections.Generic.List<country> lst  = e.Result as System.Collections.Generic.List<country>;  
    int count = lst.Count;  
}

only gives me the count for the current page, and not the total.

Any other suggestions?

Best Answer

The LinqDataSourceEventArgs returned in those events return -1 on these occasions:

-1 if the LinqDataSourceStatusEventArgs object was created during a data modification operation; -1 if you enabled customized paging by setting AutoPage to true and by setting RetrieveTotalRowCount to false.

Check here for more information - the table towards the bottom, shows different properties to set to get the rowcount back, but it looks like you either have to set AutoPage and AllowPage properties to either both true or both false.

Judging by the table in the link above and the example you provide you have Autopage set to false, but AllowPaging set to true, therefore it is returning the amount of rows in the page.

HTH

Related Solutions

How to get total row count and why is the GridView’s DataSource property null in the DataBound event handler

In VS, you can debug this by putting a breakpoint there and mousing over DataSource, but I think it's because the GridView extracts a DataView from the DataTable that it binds to, so it isn't looking at the DataSet...

Debugging will find out.

HTH.

C# – Count total rows of gridview with pagination

if you're using sqldatasource or objectdatasource You need to use the ReturnValue of the ObjectDataSourceStatusEventArgs or SqlDataSourceStatusEventArgs while handling the datasource's Selected event.

If you are using sqldatasource, you can count the total rows using the 'Selected' event which gets fired after the select operation has been completed.

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
  int rowCount = e.AffectedRows;
}

If you're using object data source, it's important to note that the Selected event on the ODS gets called twice, once returning the data set, and again to call the method you specified in the SelectCountMethod property. Simply test to see if the return is an Int32 in the event.

protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
    if (e.ReturnValue.GetType() == typeof(System.Int32))
        int rowCount = (Int32)e.ReturnValue;
}

You can find a working example at: http://www.webswapp.com/codesamples/aspnet20/dropdownlist_gridview/default.aspx

if your GridView is being filled by a DataSet or DataTable:

int rowCount=((DataTable)Customer).Rows.Count;

If you are binding the list or array of objects then you can do the following:

int rowCount = ((Customer[])gv.DataSource).Count;

Best Answer

Related Solutions

How to get total row count and why is the GridView’s DataSource property null in the DataBound event handler

C# – Count total rows of gridview with pagination

Related Topic