Data Paging

<i><b>Originally posted by : Jill (jillrhyme@yahoo.com)</b></i><br />I have a stored procedure that returns a subset of a list of data. To clarify, suppose i have 100 records that match my query and I will display 4 pages with 25 records each, the subset of data i return from my stored procedure will be records 1 to 25, 26 to 50, etc. In addition to returning the subset, I also need to return the total number of records that match the query (i.e. 100).<br /><br />I am using a tier'd architecture, so once i retrieve the subset, I will pass it on to the ASP.NET page for use with a reader server control. The problem is how can I get the returned parameter that contains the total number of records?<br /><br />Parameters cannot be retrieved while the connection is still open and i cannot close the connection because it is needed by the server control...<br /><br />Any answers will be appreciated,<br /><br />Thanks<br />Jill Rhyme<br /><br /><br />

<i><b>Originally posted by : </b></i><br />I'm not sure if this is what you are refering to if you are using a stored procedure but I'm using:<br /><br />Dim Source As DataView = DS.Tables(0).DefaultView<br />Dim rowCountFilter As Integer = Source.Count<br /><br />------------<br />Jill at 4/8/2002 9:19:18 PM<br /><br />I have a stored procedure that returns a subset of a list of data. To clarify, suppose i have 100 records that match my query and I will display 4 pages with 25 records each, the subset of data i return from my stored procedure will be records 1 to 25, 26 to 50, etc. In addition to returning the subset, I also need to return the total number of records that match the query (i.e. 100).<br /><br />I am using a tier'd architecture, so once i retrieve the subset, I will pass it on to the ASP.NET page for use with a reader server control. The problem is how can I get the returned parameter that contains the total number of records?<br /><br />Parameters cannot be retrieved while the connection is still open and i cannot close the connection because it is needed by the server control...<br /><br />Any answers will be appreciated,<br /><br />Thanks<br />Jill Rhyme<br /><br /><br />