🚀 go-pugleaf

Hi James,

> I am trying to use a datagrid control and enable paging. No matter what I do I get the following errror: 
> Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.
> even though if I step through and debug I see that the pageindex I am attempting to set (1) is less than the page count (2). 

But when you call DataBind on the DataGrid again, does the DataGrid's 
DataSource still contain the data? Did you re-execute the query, or 
obtain the data from a cache (like the session for example?).

Note that if you use BdpDataAdapter, then leaving the Active property 
set to True will do the trick (it's not as efficient as storing the 
result in the session, but at least ensures the query will always be 
re-executed).

> I have searched for this message in the newsgroups and cannot find any answer that applies. Has anyone had this problem and been able to resolve it? 

See 
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0401swart/ 
for an example how to do it using BdpDataAdapter.

> Thanks,
> James

Groetjes,
           Bob Swart

-- 
Bob Swart Training & Consultancy (eBob42.com)  Forever Loyal to Delphi
Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware