Combobox

[veledrom]

Hi,

Create table myTable(
title ENUM ('Mr', 'Mrs', 'Miss') NOT NULL DEFAULT 'Mr'
);

How can i load ('Mr', 'Mrs', 'Miss') into a combobox in VB6.

Thanks

[selvaganapathy]

Hi,
Draw a Combobox(ComboBox1)

ComboBox1.AddItem "Mr"
  ComboBox1.AddItem "Mrs"
  ComboBox1.AddItem "Miss"

[veledrom]

I know your solution but, I have to bring ENUM ('Mr', 'Mrs', 'Miss') from table.

[QVeen72]

Hi,

You mean, you want both Enum and ComboBox to be filled with data from the database table...?

Regards
Veena

[veledrom]

Hi,

I have a comboBox in my Form1. When Form1.Load then, comboBox must have those ENUM values from that Table. Because, some people always add new values. They don't tell me to add it in my VB6 code.

Thanks

[QVeen72]

Hi,

If you are using VB6, open the recordset to the table, loop thru and populate the combo box, Check this :

Dim RST As New ADODB.RecordSet
Combo1.Clear
RST.Open "Select Distinct Title From MyTable",Conn
If Not RST.EOF  Then
    RST.MoveFirst
   Do While Not RST.EOF
       Combo1.AddItem RST(0) & ""
       RST.MoveNext
   Loop
End If

Regards
Veena

[veledrom]

Hi,

I doesn't list all the values. Jumps on some values. Example; 1,2,3,4,5 this is listed as 1,3,5 or doesn't list one or two of them

Thanks