Solved

Intraweb DBGrid multi pages

Posted on 2008-10-07
2
1,086 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now