Browse by Tags

Home ›

All Tags » sql » paging » GridView (RSS)

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: GridView, database, paging, sql, SELECT, ASP.NET, 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: GridView, paging custom control, database, paging, stored procedure, custom paging, sql
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: SQL, optional parameters, Paging, Datasets, ROW_NUMBER(), custom, GridView