Question
EY
BR
Last activity: 3 Jan 2018 9:56 EST
Populating a listbox from sql
Hi Pega community!
Im having some problems on how to populate a listbox from a sql table, using a Pega Form.
Edit: Just adding some info, i cant "add item" to these listboxes, as you can see i dont even have this method.
So in this form, we have two lists. The first one i will populate itens from SQL table, and the second one will only receive data from the first list.
Basically I have two problems, first is populating a listbox from SQL Server and move itens between two different list boxes.
Thanks for the help!
***Edited by Moderator to update categories***
Pegasystems Inc.
US
To get the Add method, you need to first click the Explore Component Properties button in the upper right of the Object Explorer window. From here you can locate the Items property and select its Add method.
What you want to do in this case though is to add a TableView to your Windows Form. Then you can set its TableProvider property to that of your SQL Query component. You can then set the DataSource property of your ListBox to the TableView.
Pegasystems Inc.
US
To move items between the list, you'll need to Add() the SelectedItems to the second listbox. Basically, pass the SelectedItems property from the first listbox into a ForLoop and call the Add() method on the second listbox for each of the items (or you may want to use the Insert() method to preserve order).