title: SQL Command Result to Dictionary C# .NET 2.0
body: <p>I have a simple SQL query (using SqlCommand, SqlTransaction) in .NET 2.0 that returns a table of integer-string pairs (ID, Name).  I want to get this data into a dictionary like <code>Dictionary&lt;int, string&gt;</code>.</p>
  
  <p>I can get the result into a DataTable, but even iterating over it, I'm not sure how to do the typing and all that stuff.  I feel like this must be a common problem but I haven't found any good solutions.</p>
  
  <p>Thanks in advance.</p>