Static data is easily populated in a List control Editor using the 'user defined settings' to store the options for a field. If the data in the List control needs to be populated from a SQL table, however, the values to display in the List need to be fetched from the server before you can show them. This can be done when the server-side onDialogInitialize event is executed. The data fetched from the SQL table can be cached client-side. The List control can then be populated with the cached data when the Editor's set value event is executed.
Watch the video below to learn more.
List Control Editor - Dynamically Populate with SQL Data
Video Link: http://www.alphasoftware.com/video-library/?v=4942
Prerequisite Knowledge Base
See these other great videos on using List controls as an editor:
- Editors: Cascading List Control: Discover how to use a List control as a cascading editor - choices for a city field are filtered based on the value in a state field.
Bookmarks