To elaborate on AstroDrabb's suggestion, the
SqlDataSourceEventArgs.AffectedRows property will return the accurate
RowCount (assuming that your DataSourceMode is not DataReader). The
ideal place to evaluate this property would be in the
SqlDataSource.Selected event.
---
int rowCount;
private void mySqlDataSource_Selected(Object source,
SqlDataSourceStatusEventArgs e)
{
rowCount = e.AffectedRows;
}
---
On Feb 15, 4:49 pm, AstroDrabb <[email protected]> wrote:
> On Fri, Feb 13, 2009 at 1:13 PM, R Tanner <[email protected]> wrote:
>
> > You can see in the following code I am trying to get a count for all
> > of the records in my gridview, which is called 'employee details'.
> > The problem is that it is only counting the records on the first
> > page. How can I get this code to count the records on all pages?
>
> > By the way, this gridview is updated via a sql data source object on
> > my form..
>
> > try
>
> <snip>
> Get the row count from your data binding source.
