[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Intraweb DBGrid multi pages

Posted on 2008-10-07
2
Medium Priority
?
1,150 Views
Last Modified: 2013-11-23
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.
0
Comment
Question by:Motaz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 21

Accepted Solution

by:
developmentguru earned 2000 total points
ID: 22679025
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.
0
 
LVL 7

Author Closing Comment

by:Motaz
ID: 31503810
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question