title: Get the players name and score
body: <p>What I want to do is use a Data Table to get data from my <code>mySQL</code> to show in a <code>Listbox</code> on my form.</p>
  
  <p>How can I get a players name and score to show up in order of highest score?</p>
  
  <p>So far i managed to get a players name or a players score to show up.</p>
  
  <pre><code>MySqlConnection myConn = new MySqlConnection(connStr);
  
  string sqlStr = "SELECT * FROM highscore";
  
  MySqlDataAdapter dAdapter = new MySqlDataAdapter(sqlStr, myConn);
  
  DataTable dTable = new DataTable();
  dAdapter.Fill(dTable);
  dAdapter.Dispose();
  lstNames.DataSource = dTable;
  lstScores.DataSource = dTable;
  lstNames.DisplayMember = "Name";
  </code></pre>
  
  <p>I did try to use two separate list boxes out of ease, but realized i wouldn't be able to arrange them in any order.</p>
  
  <p>Below is after the changes Paul</p>
  
  <pre><code>                 MySqlConnection myConn = new MySqlConnection(connStr);
  
               string sqlStr = "SELECT Name + ' ' + Score as NameAndScore " + "FROM highscore ORDER BY Score DESC";
  
               MySqlDataAdapter dAdapter = new MySqlDataAdapter(sqlStr, myConn);
  
               DataTable dTable = new DataTable();
               dAdapter.Fill(dTable);
               dAdapter.Dispose();
               lstNames.DisplayMember = "NameAndScore";
               lstNames.DataSource = dTable;
  </code></pre>