列表框中没有显示数据

Question

我试图让我的记分牌显示在mySQL DB的列表框中。

但是，所有我在列表框中得到的是 'System.Data.DataRowView'

这是代码：

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(); 

Answer 1

结合之前填写。

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