number of rows in a gridview with pagesize?

[Vincent]

Hi,

i want to know the number of rows in a gridview bound to a sqldatasource.
I tried this:

Protected Sub grv_DataBound(ByVal sender As Object, ByVal e As
System.EventArgs) Handles grv.DataBound
Label1.Text = gridview1.Rows.Count
End Sub

and this:

Protected Sub grv_RowDataBound(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.GridViewRowEventArgs) Handles grv.RowDataBound
Label1.Text = gridview1.Rows.Count
End Sub

There are 120 rows and the pagingsize=10.
This gives in both cases: 10 (=pagesize).

How can i get all rows (120)?
Thanks
Vincent

 

[Vincent]

I found it:
Protected Sub SqlDataSource2_Selected(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
SqlDataSource2.Selected
e.AffectedRows

 

[Mike]

Thanks for following yourself up Vincent because if you hadn't I'd still be
looking for an answer to the same question. Mike