Paging Problem

25 Feb 2005 10:17 PM

Jeff Thur

I have a SQL Stored Procedure returning a dataset. When
paging is turned off I get the entire dataset on one long
page. However when paging is turned on, I get the first
page and when I go to the next page I get the same data
on page 2. In other words paging is not working for me.
Thanks in advance for any suggestions.

This is my code:

DS = new DataSet()
              MyCommand.Fill(DS, "Results")

       DataGrid1.DataSource=DS.Tables
("Results").DefaultView
                   DataGrid1.DataBind()

27 Feb 2005 6:02 PM

Elton Wang

Check out following url

http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/dv_vbCode/html/vbtskcodepagingindatagridwebcontrolvisual
basic.asp

HTH

Elton Wang
elton_w***@hotmail.com

Show quoteHide quote

>-----Original Message-----
>I have a SQL Stored Procedure returning a dataset. When
>paging is turned off I get the entire dataset on one long
>page. However when paging is turned on, I get the first
>page and when I go to the next page I get the same data
>on page 2. In other words paging is not working for me.
>Thanks in advance for any suggestions.
>
>
>This is my code:
>
> DS = new DataSet()
>              MyCommand.Fill(DS, "Results")
>
>
>
>
>
>       DataGrid1.DataSource=DS.Tables
>("Results").DefaultView
>                   DataGrid1.DataBind()
>
>.
>