title: Only get single value from list executereader
body: <p>I am trying to read values form my database. But why am I getting only values with no column name?
  this is my controller. that returns the values in JSON</p>
  
  <pre><code>            SqlCommand cmd = con.CreateCommand();
  
              cmd.CommandText = "SELECT DISTINCT State FROM MyDBtable";
  
              con.Open();
              List&lt;string&gt; StateList = new List&lt;string&gt;();
              SqlDataReader reader = cmd.ExecuteReader();
  
              while (reader.Read())
              {
                  StateList.Add(reader[0].ToString());
              }
  
              return Json(new
              {
                  myTable = StateList
              }, JsonRequestBehavior.AllowGet);
  </code></pre>
  
  <p>and this is my JSON</p>
  
  <pre><code>{"myTable":["VA","CA"]}
  </code></pre>
  
  <p>Where as, it's suppose to give me  </p>
  
  <pre><code>{"myTable":[{"State":"VA"},{"State":"CA"}]}
  </code></pre>
  
  <p>Why is it not reading and printing State</p>