• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1190
  • Last Modified:

Intraweb DBGrid multi pages

I have a query result that I should display it in an Intraweb DBGrid. Can I split the result to be displayed in a multi page. For example maximum is 100, but you can click next to see next 100 and so on.
1 Solution
Generally I have seen the page get passed parameters for where it should start displaying records and how many it should display.  This can then be used in the database query (if your database supports it).  SQL Server supports

select top 100 * from MyTable

Inventive use of the select statement may allow you to select just the records you want.  You may need to do a database stored procedure to come up with a list of the IDs that would be in the list of 100 records, then do a select statement where the ID is in the list of returned IDs.

I believe that ADO datasets support paging as well... something else you can look into.
MotazAuthor Commented:
Very nice idea, thanks, but it will hide for me real records (Total). Anyway I can call two different queries to know Total, and how many pages.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now