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!

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:OFVaLBU3HHA.2312@TK2MSFTNGP06.phx.gbl...

> 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!
>