[RESOLVED] Adding records to combobox

[Radjesh Klauke]

I'm trying to read the records into a combobox from the database without any success. There is no problem with the connection, but something seems wrong with my coding. Perhaps someone could tell me what I'm doing wrong.

Dim reader_combo_plaats As SqlCeDataReader
Dim cmd_Plaats As New SqlCeCommand("SELECT DISTINCT plaats FROM beslagdata", connStr)
 
reader_combo_plaats = cmd_Plaats.ExecuteReader
While reader_combo_plaats.Read
    mdi_beslag.ts_cbo_plaats.Items.Add(reader.Item("plaats").ToString)  ' <<< here is the problem
End While

[motil]

What is the error you get?

[motil]

Btw: if you look at this line in your code :

  mdi_beslag.ts_cbo_plaats.Items.Add(reader.Item("plaats").ToString)

you use "reader.item("plaats").tostring" while you declared your sqlDataReader as "reader_combo_plaats".

[Radjesh Klauke]

AAAAAAAAAAAAAAH!!!! SO... STUPID!!!! STUPID!!!! STUPID!!!! STUPID!!!!

Woke up 5.30 am this morning to do some work. Seems that it was to early for me. Thanks man. You saved my day. Very greatfull for that.

[Radjesh Klauke]

Hmm... Do you know how to add a progressbar while reading?