For the UI to a database application it makes sense to use a widget that
allows entry and viewing of multiple rows. There are no spreadsheet-like
calculations on the data.
A simple example is for air quality data. The columns are: 'Emission
Unit,' 'Date,' 'Time,' 'PM,' 'PM10,' 'PM2.5,' and 'Opacity.'
However, some columns have content restricted to a fixed list; e.g., a
26-item list why data are missing or otherwise need special attention. This
list would be presented in a combobox in a scenario that uses individual
widgets for each column. Can I implement such a pick list with a grid or
listctrl?
Another requirement with either widget is the ability to dynamically add
rows as more data are entered and present a vertical scroll bar along the
frame.
What criteria should be applied to chose between an editable list control
and a simple grid? Or, is there a better solution for this situation?
Rich