How to limit the number of row using dataGridView and ultraGrid tool in openedge architect 10.2A... - Forum - OpenEdge General - Progress Community

How to limit the number of row using dataGridView and ultraGrid tool in openedge architect 10.2A...

 Forum

How to limit the number of row using dataGridView and ultraGrid tool in openedge architect 10.2A...

  • Hi....

        I have probblem using dataGridView and ultraGrid tool in openedge architect 10.2A...

        How can i limit the number of row when it display the data in a page...

        In case i got 20 record...but i want display 10 record per page...

        I try to find how to set the maximum row...but still didn't work...

       Anyone who know how to solve my problem either using  dataGridView or ultraGrid tool, please let me know...

    Thank  you..

  • Well I don't understand why you'd want to display only 10 records and not 20 and let the UltraGrid deal with the scrolling, but never mind (the ProBindingSource also does perfectly support batching).

    The UltraGrid's bindingSource (Progress.Data.BindingSource) should be bound to a query. I think you need to open your query in a way, that it just returns the first 10 records:

    OPEN QUERY qBindingSource FOR EACH record WHERE record.record_num 
  • Hii....

         Thank for your answer...

         Actually, i want display all record...but how can i limit to display the record in one page...

         So...in my case...if i got 20 retrieved record, i want display its in 2 page. 10 record will displayed in 1st page and next 10 record displayed in 2nd page....

         I don know how to setting maximum row if i using dataGridView or ultraGrid... That's is my problem... Let me know if got any idea....

  • I still don't understand the use case.

    Do you want to implement your own scrolling in the Grid? What's wrong with the build in ones?

  • Hi...

         Actually the problem is I want to display the records from the database in the datagrid where the display view of the database rows should be set to 10 rows.

         The next record should be displayed once the user click the next button..

  • I'm pretty sure you need to provide a solution based on the Query:

    FOR EACH table WHERE table.recordNum >= 1 AND table.recordNum 

    and

    FOR EACH table WHERE table.recordNum >= 11 AND table.recordNum 

    etc.

    If that does not work (because there is no matching selection criteria), look into ProDatasets and their batching mechanism or a simpler temp-table based solution. Or explain your users the use of the scrollbar on the grid.

  • muni schrieb:

         Actually, i want display all record...but how can i limit to display the record in one page...

    How can you know (and why would you want to know), that the display size is 10 rows? Aren't your screens resizable and the grids size is more or less randomly?

  • Hai Mike, I need to limit the number of rows to fullfill the user interface requirement as the one I attached below. Insteed of scrolling through datagrid we have the next and previous button. Therefore I want to know how to set the number of the rows in the datagrid and how to control record display using next and previous button. Any idea?

  • muni schrieb:

    Hai Mike, I need to limit the number of rows to fullfill the user interface requirement as the one I attached below.

    Not every requirement makes perfect sense or the author of the requirement knew what's standard for the target platform. A righ GUI application has different standards than a web application, a next page - previous page style of navigation is very much a mimic of a web application.

    Have you tried my previous suggestings using open query or a ProDataset batching mechanism?

    Another way might be trying with the Hidden property of Rows in the UltraGrid. Something like that may work:

    DO i = 0 TO ultraGrid1:DisplayLayout:Bands[0]:Rows:

       ultraGrid1:DisplayLayout:Bands[0]:Rows[i]:Hidden = (i

    END.

    But I'd try to solve the requirements issue first.

  • Hi Mike,
         Sorry for the late reply.... I was buzy with other stuff since few days and just wanna try the one u gave me. Let u knw the progress later once I tried.

    Thanks for your help.