dataset1.table[0].Rows.Count should do the trick
--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET - MS Press
Professional VSTO 2005 - Wrox/Wiley
OWC Black Book
www.lulu.com/owc
"Paulo Roberto" <> wrote in message
news:...
> Hi, how can I return the total of records returned from a DataSet? Because
> if I use the grdview.row.count it will show just the page total... I would
> like the whole...
>
> How can I do that? or must I execute another sql statement: "count(*)"
> instruction on db ?
>
> Thanks a lot!
>