title: Put the Query result of MySql in to a C# list or array?
body: <p>I've done some searching for the answer, but only find a lot of PHP answers. I need this for a C# application. Can any one point me in the right direction?      </p>
  
  <p>I'm doing this, but this only returns the first row into my variable:</p>
  
  <pre><code>    Query("SELECT SaksNummer FROM casetracking")
  
      public static string Query(string query)
      {
          string x;
          mysqlCon.Open();
          cmd = new MySqlCommand(query, mysqlCon);
          x = cmd.ExecuteScalar().ToString();
          mysqlCon.Close();
          return x;
      }       
  </code></pre>