In my program I use a SQLite data base.
Now I want to show all content of my data base in a table (columns for the items, rows for the records). Every cell should show an item of the data base and by double-clicking the cell I should be able to edit the item.
How can I achieve this?
Is the built-in list box the best way to do this or are there 3rd party solutions to do this?
You can iterate through the contents of a recordset and populate the listbox that way. You can do this via the standard ListBox control.
Plus you need to decide when to update the database. Do you plan to update the record every time a cell is edited? Or only when the application is exited? Or when a different row is selected? Or when the listbox loses focus? Or when the user clicks on a “Save Changes” button?
Basically, you need to determine the typical workflow and decide what approach will be safest for the data while not introducing too much overhead that might affect performance.
Listbox is the way to go if you want to display a list of records.
Write yourself a global method to fill the recordset from the SQL. Parameters: recordset as input, name of listbox to fill
As Dale said, if you let the user update records, though you can use a listbox, this can be messy
It is better to let the user update one record at a time