Member Avatar for monching

Hello there,
How to add items in combo box from mysql database?

'mySQL statement
'tryCatch method

ComboBox1._______ = myReader.GetValue(myReader.GetOrdinal("Uname"))

I'm trying use this:

ComboBox1.items = myReader.GetValue(myReader.GetOrdinal("Uname"))

but an error occured.

Edited by monching
  • 2 Contributors
  • 3 Replies
  • 302 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

It helps if you post the error message, but to add items to a combobox the syntax is

ComboBox1.Items.Add(string value)

in your case

ComboBox1.Items.Add(myReader("Uname"))
Member Avatar for monching

I did not use yet the Items.Add systax. Instead, I use this:

ComboBox1.Text = myReader.GetValue(myReader.GetOrdinal("Uname"))

just for comparizon.

Member Avatar for Reverend Jim

ComboBox1.Text is the text from the currently selected item.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.