combobox and sqlite

[dennishea]

How do you load one col of sqlite into combobox. Any suggestions welcome.

:sign0085:

Thanks in advance.

 

[Erel]

Something like: (Reader is a DataReader object and cmb is a ComboBox)

cmd.CommandText = "SELECT col FROM table"
Reader.Value = cmd.ExecuteReader
Do While reader.ReadNextRow = True 
    cmb.Add(reader.GetValue(0))
Loop
Reader.Close

 

[dennishea]

Thanks Erel.

I was checking online and forgot about the help file in b4p. I've used commandtext and connection but not datareader yet. Thanks for reminding me about the 3rd object in sqldevice.dll.

:sign0188::sign0188: