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
Printable View
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
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?
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:will crash the server! Check your code!Code:objRS.Open "SELECT * FROM MyTable"
While Not objRS.EOF
Response.Write objRS("myfield").Value
Wend
objRS.Close
thanks for the paging site...
as for the code - :eek:
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?
you can always response.write and go through the data set or datareader.
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