LLBLGen 2.0
Self Servicing
ASP.NET v2.0
I'm using custom paging in a web page. My data source comes from a method that uses the GetMultiAsDataTable and I pass in the PageNumber and PageSize. I want to display a label that says "Page x of y", but since I'm using the PageNumber and PageSize parameters, my DataTable.Rows.Count is only PageSize. Is there a way to get the total number of rows in the resultset BEFORE the paging is applied? Obviously, I could hit the database again, but I'd like to refrain from that if possible.