data not showing in listbox

Question

I am trying to get a scoreboard to show up in my listbox from a mySQL DB.

However all i get in the list box is 'System.Data.DataRowView'

this is the code:

MySqlConnection myConn = new MySqlConnection(connStr);

string sqlStr = "SELECT CONCAT(Name, ' ', Score) as NameAndScore " + "FROM highscore ORDER BY Score DESC";

MySqlDataAdapter dAdapter = new MySqlDataAdapter(sqlStr, myConn);

DataTable dTable = new DataTable();
lstNames.DisplayMember = "NameAndScore";
lstNames.DataSource = dTable;
dAdapter.Fill(dTable);
dAdapter.Dispose();

score 0 · Answer 1 · answered Mar 14 '13 at 22:38

0

Fill before binding.

 dAdapter.Fill(dTable);
 lstNames.DataSource = dTable;
 lstNames.DisplayMember = "NameAndScore";

answered Mar 14 '13 at 22:38

Hamlet Hakobyan

32,965
6
52
68

This is how i had it previously but still get the same error. – Cain Neal Mar 14 '13 at 22:44
@CainNeal Check, does datatable populated after fill in debug mode. – Hamlet Hakobyan Mar 14 '13 at 22:50
Very important detail: You must set `DisplayMember` *after* `DataSource`. – tgolisch Nov 27 '18 at 14:30

data not showing in listbox

1 Answers1