🚀 go-pugleaf

Hi,

for your EMPTY problem, try something like this :

private void buildComboWithTable(JdbComboBox theCombo, String tableName,
String columnName) {
    try {
      stmt = conn.createStatement();
      rset = stmt.executeQuery("select distinct " + columnName + " from " +
tableName + " order by " + columnName);
      while(rset.next()) {
        theCombo.addItem(rset.getString(1));
      }
      stmt.close();
    }
    catch(Exception e) {
       e.printStackTrace();
    }
  }

where :

Connection conn;
Statment stmt;
ResultSet rset;

Hope it helps.
Alain LACOUR

Jeroen Zwartepoorte wrote:

> Hi,
>
> How do i use a JdbComboBox????
>
> I added it to my app, i set the dataset property and the columnname
> property. But NOTHING HAPPENS when i run the app. The combobox is EMPTY!
>
> I also can't seem to find an example on how to use it.
>
> I remember someone else also having trouble making it work.
>
> And second: let's say the data that i want to show in a JdbComboBox is
> of the form: data1;data2;data3
> (the data is in one field, with the values separated by ;)
>
> Now, when i want to show this in a JdbComboBox, what do i have to do?
>
> Do i need to write my own ComboBoxModel?
>
> I looked at the JdbComboBox source, but i didn't understand how it get's
> the data from the dataset.
>
> Hope you can help me,
>
> Jeroen Zwartepoorte
> Jeroen@xs4all.nl