Browse by Tags

Related Posts

  • 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
  • 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: Datalist, paging custom control, paging, sqldatasource, datalist paging database, datasource, T-SQL, SQL Datasource TransactSQL JOIN SELECT, sql, SQL Datasets, ADO.NET, Pagination for Datalist, SELECT
  • 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
  • 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
Page 1 of 1 (4 items)