Data view and pagination

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using FrontPage 2003 to edit Sharepoint Services 2.0 web sites. I want
to connect to an SQL Server 2000 database (running on a different server)
through a data view web part.

I can obtain the data connection and return results with no problem.
However, the query could return over 10000 rows, which makes Frontpage
ridiculously slow.

When I try to limit the number of results returned or enable paging through
the Data View Details taskpane, I still get all rows displayed in the
FrontPage design view, and after publishing, when browsing the Sharepoint
site as well.

Any ideas what is causing this, or how to work around it?

Thanks,
jason.
 
You might also try asking this in the WSS support newsgroup at
news://msnews.microsoft.com/microsoft.public.sharepoint.windowsservices

--




| I'm using FrontPage 2003 to edit Sharepoint Services 2.0 web sites. I want
| to connect to an SQL Server 2000 database (running on a different server)
| through a data view web part.
|
| I can obtain the data connection and return results with no problem.
| However, the query could return over 10000 rows, which makes Frontpage
| ridiculously slow.
|
| When I try to limit the number of results returned or enable paging through
| the Data View Details taskpane, I still get all rows displayed in the
| FrontPage design view, and after publishing, when browsing the Sharepoint
| site as well.
|
| Any ideas what is causing this, or how to work around it?
|
| Thanks,
| jason.
 
Back
Top