title: How to fill List<String> with SqlDataAdapter?
body: <p>I am trying to fill List with SqlDataAdapter. But i am not able to do it.Is there any other method to fill List of string apart from Data Adapter. Please help me out to solve this problem.Thanks in advance.</p>
  
  <p>This is my code:</p>
  
  <pre><code>public List&lt;String&gt; JSONDataAll()
          {
              List&lt;String&gt; Users = new List&lt;String&gt;();
              con.Open();
              SqlCommand cmd = new SqlCommand("sp_sample_Proc", con);
              cmd.CommandType = CommandType.StoredProcedure;
              SqlDataAdapter da = new SqlDataAdapter(cmd);
              da.Fill(Users);
          }
  </code></pre>