title: Store Result of a Query in a Dictionary
body: <p>I have problem to develop Windows mobile app using C#, I trying to work with 3 query.
  I want to collect all result query into Dictionary.</p>
  
  <p>can i collect it without looping?</p>
  
  <p>like this my code:</p>
  
  <pre><code>string query= "select distinct nameProduct, price from product";
  SqlCeCommand cmd = new SqlCeCommand(sql, dbConn);
  Dictionary production = new Dictionary&lt;string, int&gt;();
  </code></pre>
  
  <p>How can i set this production from my query, becausei have 3 query like this in one process and the data is more than 10.000. </p>
  
  <p>@John Saunders:
  when i try this, i get error"{"No data exists for the row/column."}" but actually when i try the query in sql server still running well. the error in the line: production[(string)reader["nameProduct"]] = (int)reader["price"];</p>
  
  <p>@Johnny:
  unfortunatelly this project build in VS2005 and not support union and join statement.</p>