Load Distinct .sdf-database column into a ComboBox

[RadjeshNL]

Trying to achieve this and I think that I'm almost there, but I can't get the values itself from the column(s). The connection works perfectly, I can get all the values into a listview, but the combo...

Dim connStr As New SqlCeConnection("Data Source=" & Application.StartupPath & "\DATABASE_NAME.sdf; Password =")

Dim cmd As New SqlCeCommand("SELECT DISTINCT item FROM tablename", connStr)

connStr.Open()
reader_combo1 = cmd_Plaats.ExecuteReader

While reader_combo1.Read
    mdi_beslag.ts_cbo_plaats.Items.Add("field1") ' <<<<
End While

What am I dong wrong?

(The combobox is btw a combobox in the toostrip)

 

[RadjeshNL]

reader_combo1 = cmd_Plaats.ExecuteReader

should be cmd.ExecuteReader btw. Sorry for that.

 

[RadjeshNL]

Found it...

Used the wrong command.