c# - How do I populate a combo box with a column from my sql database -

c# - How do I populate a combo box with a column from my sql database -

how populate combobox column mysql database?

private void comboboxsender_selectedindexchanged(object sender, eventargs e) { string query = "select sender messages"; seek { sqlcommand cmd = new sqlcommand(query, conn); sqldataadapter sda = new sqldataadapter(query, conn); dataset ds = new dataset(); sda.fill(ds); cmd.executenonquery(); comboboxsender.displaymember = "sender"; comboboxsender.valuemember = "sender"; comboboxsender.datasource = ds.tables[1]; } grab (exception combo) { console.writeline(combo.tostring()); } conn.close(); }

this code have @ moment; none of info showing up. can please help i'm still quite new this.

try this

using (sqlconnection conn = new sqlconnection(connstring)) { conn.open(); using (sqldataadapter sda = new sqldataadapter("select sender messages", conn)) { datatable dt = new datatable(); sda.fill(dt); comboboxsender.valuemember = "sender"; comboboxsender.displaymember = "sender"; comboboxsender.datasource = dt; } }

c# sql sql-server