custom paging in datagrid

From: Mong (mongphong28_at_yahoo.com.au)
Date: 03/29/04 

Date: 28 Mar 2004 21:32:33 -0800

Hi,

Does anyone have a "real" example of using custom paging with a
datagrid that retrieves data from a db? The online example just
inserts sample data each time which doesn't really illustrate how you
go about it, not sure why they bothered!

It says that your query should only return enough data to fill one
page which is obvious, but how do you tell a query to do that without
first getting all the data then working out where to jump in?

Currently I have an sql stored procedure which returns all rows to an
SqlClient.SqlDataReader. Can you jump into this kind of dataset using
an index?

Thanks for any insight,

Mong

Relevant Pages

  • Re: Reading google groups, 101. [was: Unangband questions]
    ... requires payments, you mean. ... the jump from $0 to $1 ... news reading service or similar online thing the "shipping" ... I certainly will refuse if the only available ...
    (rec.games.roguelike.angband)
  • Re: UDF and SQL2000 - Why doesnt this work?
    ... Basically This is what I want to do - I have created a query ... as DDL (i.e. CREATE TABLE statements; ... Sample data that illustrates the problem, ... Expected output from the sample data supplied; ...
    (microsoft.public.sqlserver.programming)
  • Re: New to SQL and trying multiple table joins
    ... > Can't be certain of how to write this query for you without DDL (CREATE ... Previous msg edited plus added in keys, and sample data at end. ... EmpAvailID (Primary Key), EmpID, EAMonthID(Foreign ... AbilityID, EmpID, MainAbility ...
    (microsoft.public.sqlserver.programming)
  • Re: find missing time periods
    ... User and UserShiftStart in sample data, ... I believe your unmatched query actually ... FROM [Time Periods], Splits; ...
    (microsoft.public.access.queries)
  • Re: calculated field - Access 2003
    ... When I asked for sample data, I meant for you to show me ... I would normally use "criteria" filters for this type of application, ... lookup table containing site names and the PDx ... This will allow you to do a query like ...
    (microsoft.public.access.queries)