Load a database column and its contents into ComboBox
Posted on 2013-01-19
First of all, I'm practicing on databases these days so expect further questions next days :p
I have a database and a couple of tables in it. In my application I placed a regular combobox and tried to fill it with a specific column's values.
Let's call the column for instance "products" and it gets updated by adding(inserting) new products to it.
I want to display all the products in the column in that combobox.
I'm almost there but with a lot of google search I got lost a little bit.
TStringList, TADOQuery, DBLookUpComboBox, TADOTable etc. << all of these techniques of achieving the result got me confused.
By the way, I have a TADOtable component placed on the form. If I can achieve the result without using the TQuery component that would be great. If DBcomboBoxes sets can solve the problem, I would be glad to hear your thoughts about them.
Added: The database is MS-Access