Retrieve and short mysql database

[ijan]

Hi experts, i have build a simple program and record the data to mysql database. Now i want to retrieve the table data and i add a combo box as a filter for when displaying data. is it possible to do with database connectivity toolkit? please see attachment

Thank you

[Himanshu_Goyal]

Hi Ijan,

You can use database toolkits to retrieve the data from the database.

Find some examples related with database in Help-Find Examples-search-database.

You can directly call your table or you can fire a query to fetch the data.

[Yamaeda]

Select Column1,Column2,Column3 from Table order by Column1,Column3;

Use Database toolkit to get column names and populate the combo boxes and an event to rerun the SQL-query whenever one of them changes. It shouldn't be too hard.

/Y