title: Return Result from Select Query in stored procedure to a List
body: <p>I'm writing a stored procedure that currently contains only a <code>SELECT</code> query. It will be expanded to do a number of other things, which is why it has to be a stored procedure, but for now, it is a simple query. </p>
  
  <p>Something like this:</p>
  
  <pre><code>SELECT name, occupation, position 
  FROM jobs 
  WHERE ...
  </code></pre>
  
  <p>I'm looking to return the results of this query to be used in C#. I want to add it to a list so that I can bind it to a GridView component. </p>
  
  <p>I don't know how to go about this, though. If I have to insert it into a list after returning all selected data, then that's alright, I just need to know how to properly return the data so that I can do that. </p>
  
  <p>If I can return it in a format that can be popped right into a list, though, that would be ideal.</p>