How to add items to the combobox in form design from the database? ?

Question

I want to retrive the items from the table which i already design in database.

Answer 1

if it is in oracle forms, create one item where do u want to show , go to property pallete change the item type as list item. Choose databaseitem to yes, and little bit down ,copy the column name of the table. Make sure that this field should be under the block which is built on the table that u want the data for list values.

Answer 2

Answer using visual studeo 2005 and database SQL:

1>Create database & table.

2>Take a combobox into your form.

3>Click on smart tag of combo box and tick mark on check box named "Use Data bound items".

Now it activates 4 Combobox.

4>In first combobox select data source,if it dosent display any datasource then create it for your database.

5>In 2nd combo box select colon from which u want to display data.

Run the form.

Answer 3

If ur using dot net Then

combobox1.items.add(ds.tables(0).rows(...