Solved

Intraweb DBGrid multi pages

Posted on 2008-10-07
2
1,094 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
2 Comments
 
LVL 21

Accepted Solution

by:
developmentguru earned 500 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

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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