Browse by Tags

Home ›

All Tags » sql » paging (RSS)

Paging with Datalist

Hi, Can anyone point me in the direction of a good method for creating paging with a datalist? I would like to display 2 records from my SQL database at a time and have a next and previous button to page through the records. I am working in VB. Many thanks,

Posted to Data Presentation Controls (Forum) by magicjoef on 01-04-2009, 12:00 AM
Filed under: paging, SQL, datalist
Enable paging after using a 'where' clause

Hi, I am creating a small picture album. I have a datalist to show a grid of my images populated from my database. I have configured it so that when an image is clicked a querystring carries it's url through to the next page where a larger version is displayed. I am using a formview to show the larger...

Posted to Data Presentation Controls (Forum) by magicjoef on 08-10-2008, 12:00 AM
Filed under: paging, sql, FormView, where, Datalist
Re: Custom Paging in a Gridview - Runtime Error When Filtering

hopeful bump After some more investigating I can see that the error is occuring here: //return how many rows are in the total recordset public int GetTransactionCount( int fkToOrgID) { try { return ( int )Adapter.usp_GetTransactionCount(fkToOrgID); } catch ( Exception err) { //Catch the error here and...

Posted to Data Presentation Controls (Forum) by glosrob on 11-30-2007, 12:00 AM
Filed under: paging, sql, ASP.NET, database, SELECT, GridView, Filtering GridView
Unable to get GridView custom paging to work....

I've implemented custom paging, though unsuccessfully. Using VS2005 Pro w/SQL server 2005 Enterprise; sole programmer at a small company; Visited over 258 web pages with no success. In the GridView (GV) the PageSize = 10. In the ObjectDataSource (ODS) the default for SelectParameters:maximumRows is 10...

Posted to Data Presentation Controls (Forum) by Knoter on 03-09-2007, 12:00 AM
Filed under: paging, paging custom control, sql, stored procedure, custom paging, database, GridView
Unable to run complex SQL in DataList Data Source Config?

Hi guys, I've written a SQL query that allows me to do paging (10 records per page view or as required), which I want to control using query strings. I've tested this in the SQL Server Management Studio and it seems to be working great. Just when I go into my DataList control's data source config and...

Posted to Data Presentation Controls (Forum) by ziggy_911 on 03-05-2007, 12:00 AM
Filed under: Pagination for Datalist, paging, paging custom control, sql, SQL Datasets, SQL Datasource TransactSQL JOIN SELECT, sqldatasource, T-SQL, ADO.NET, Datalist, datalist paging database, datasource, SELECT
New Paging Alternative....

While working with the Gridview control enhancements I decided to see if there was some new features of SQL 2005 I could use... Check out my latest article on Http://tech-review.org which covers how to use SQL optional paramaters, Row_Number(), and how to dynamically control whether or not you bring...

Posted to Community Starter Kit (Forum) by jodywbcb on 09-20-2006, 12:00 AM
Filed under: optional parameters, Paging, ROW_NUMBER(), SQL, custom, Datasets, GridView