Friendly paging of large data

[Duncan Welch]

I am in the process of developing a site that will, on completion, be quite
high profile. I have successfully used the Datagrid to display paged data
from a database of around 10k records, but the standard paging techniques
use a linkbutton, which runs a small piece of client-side javascript.

To my understanding, this means that when I get "spidered" by a search
engine, it won't follow the javascript links, thereby my database won't get
indexed.

Has anyone seen an example whereby a) I'm using standard HTML links, and b)
I'm not loading all 10k records into a dataset every time someone hits the
server? Even classic ASP had it's objRecordset.Pa geSize and
objRecordset.Ab solutePage

Thanks in advance.

[Ignacio Machin]

Hi Duncam,

You can do the same thing in ASP.NET :)

The datagrid have a PageSize and a CurrentPageInde x properties, that you can
use for that matter.

This is what I would do:
1- Read the dataset and keep it in memory on a session variable, ASP.NET has
no thread affinity ( I don't know if that is the correct spelling ; )
therefore you are no compromising the performance of the app.

2- Set the PageSize as needed.

3- Now setting the CurrentPageInde x is the core thing, if you want to get
spider then you need to use GET instead of POST , later you will see how
you can get this from the HTML code using links.
in the Load event you should do something like this:

if ( Request["CurrentPag e"]!="" )
CurrentPageInde x = Convert.ToInt32 ( Request["CurrentPag e"] );
else
CurrentPageInde x = 0;

datagrid.DataBi nd(); /// You have to rebind it after changing the page !!!

this is ALL the code you need in the server side to get to the correct page,
now how to get to the correct page?
Very easy in fact :)
1- Disable the grid default paging , I think remember this is done by
setting the ShowFooter to false
2- Include two asp:LinkButtons in the page these will work like the previous
and next
I will show you only the next, the previous is similar
<asp:HyperLin k NavigateUrl=<%# NextPageUrl()%> "
Visible="<%#Exi stNextPage()%>" ></asp:HyperLink>

This is the code for the methods:
protected string NextPageUrl()
{
return "pagename.aspx? CurrentPage=" + Convert.ToStrin g(
datagrid.Curren tPageIndex + 1);
}
protected bool ExistNextPage()
{
return datagrid.Curren tPageIndex< datagrid.PageCo unt;
}
This should solve your problem, but please remember that I just wrote the
code above, I haven't test it and you may have to fine tuning it.

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Duncan Welch" <du**@ntpcl.f9. co.uk> wrote in message
news:ev******** *****@TK2MSFTNG P10.phx.gbl...

I am in the process of developing a site that will, on completion, be quite high profile. I have successfully used the Datagrid to display paged data
from a database of around 10k records, but the standard paging techniques
use a linkbutton, which runs a small piece of client-side javascript.

To my understanding, this means that when I get "spidered" by a search
engine, it won't follow the javascript links, thereby my database won't get indexed.

Has anyone seen an example whereby a) I'm using standard HTML links, and b) I'm not loading all 10k records into a dataset every time someone hits the
server? Even classic ASP had it's objRecordset.Pa geSize and
objRecordset.Ab solutePage

Thanks in advance.