Count total rows of gridview with pagination

by

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;

More Related Contents:

  1. Sql: Incorrect syntax near ‘(‘ [closed]
  2. How to find Control in TemplateField of GridView?
  3. Create thumbnail image
  4. How to implement full row selecting in GridView without select button?
  5. How can I export a GridView.DataSource to a datatable or dataset?
  6. how to find control in edit item template?
  7. GridView bound with Properties of nested class
  8. Get Row Index on Asp.net Rowcommand event
  9. How to hide a column (GridView) but still access its value?
  10. The data source does not support server-side data paging
  11. ASP.NET GridView RowIndex As CommandArgument
  12. Full postback triggered by LinkButton inside GridView inside UpdatePanel
  13. GridView with merged cells
  14. Change cell color on different values – Gridview
  15. How to add TemplateField programmatically
  16. Looping through GridView rows and Checking Checkbox Control
  17. Making an entire row clickable in a gridview
  18. How to reorder columns in gridview dynamically
  19. Reset scroll position after Async postback – ASP.NET
  20. In C#, what is the difference between public, private, protected, and having no access modifier?
  21. Entering keys manually with Entity Framework
  22. Dynamically Created Controls losing data after postback
  23. “Could not load type [Namespace].Global” causing me grief
  24. OutOfMemoryException while populating MemoryStream: 256MB allocation on 16GB system
  25. Passing data to Master Page in ASP.NET MVC
  26. How to enable cross origin requests in ASP.NET MVC [duplicate]
  27. How to implement GZip compression in ASP.NET?
  28. How do I display the DisplayAttribute.Description attribute value?
  29. ASP.NET MVC – Slow initial load
  30. IIS Request.UserHostAddress returning IPV6 (::1), even when IPV6 disabled

Leave a Comment