what's the deal with this datagrid?

[Cander]

I havent used it yet, but Paging is built into the Dataset/Datagrid stuff. TRy looking up some info here on it

http://www.gotdotnet.com

[ac11965]

hi there

when you look at the property page there is an option where you can select if you want to do it automatically or still manually.

but as i'm a first time asp programmer (and so also asp.net) i would like to do it automatically. but it does'nt seem to work...

my datagrid is binded to a dataset...

any ideas?

[weijian]

There are a few things you need to include to make paging work, even if it's automatic. Check out this:

http://www.4guysfromrolla.com/webtech/072101-1.2.shtml

boy you should search online... ASP .NET is new and resources are scarce but still I did learn paging from that page.

oh by the way your code:

objRS.Open "SELECT * FROM MyTable" 

While Not objRS.EOF 
Response.Write objRS("myfield").Value 
Wend 

objRS.Close

will crash the server! Check your code!

[ac11965]

thanks for the paging site...

as for the code -

[ac11965]

ok, i got the automatic paging to work...

but like the article says, the dataset gets reloaded from the database each time you page thru the grid.

to not reload it, i must now manually go and look for the next 10 records and load it into my grid.

my datagrid is binded to a dataset.
is it easier to bind it to a dataview and read thru it? or can i just read thru my dataset?

[Spacedinosaur]

you can always response.write and go through the data set or datareader.

[Spacedinosaur]

Yes there is an old way to do the make the table in html you use the data reader and loop through the results using response.write to make your html table and having the data displayed

get datareader

loop through data reader
response.write(html table data i)
next