title: How to use Stored Procedures w/ ASP.NET DataGrid
body: <p>Question can also be:</p>
  
  <p><em>What is your preferred way of invoking stored procedures to fill a DataGrid?</em></p>
  
  <p>I am currently developing an ASP.NET Page, and I would like to know if Linq is the right way to go for use with my SQL Server DB. </p>
  
  <p>ADO seems nice too, so I would just like to have feedback on what is the most appropriate in general terms..</p>
  
  <p>LINQ sure makes it easy to call a stored procedure, but I am kind of stuck in trying to find out the right way to put the result set from the stored procedure to a datagrid.</p>
  
  <blockquote>
    <p>Don't think I want to do a foreach
    there..but all examples seem to point that way.. or I'm just confused</p>
  </blockquote>
  
  <p><a href="http://blogs.interfacett.com/dan-wahlins-blog/2008/2/17/linq-and-lambdas-and-sprocsoh-my.html" rel="nofollow noreferrer">I have read this blog post</a>, and <a href="http://msdn.microsoft.com/en-us/library/bb546186.aspx" rel="nofollow noreferrer">this one</a>, it seems the ways to go are foreach and Ienumerable methods.. and I am a bit confused about the whole thing.</p>
  
  <p>I am also thinking about the <a href="http://www.asp.net/learn/mvc/tutorial-21-cs.aspx" rel="nofollow noreferrer">tutorial for creating a Movie DataBase</a> where the DataGrid simply became unnecessary in that case.</p>
  
  <blockquote>
    <p>What is the simplest, most to the
    point way of accessing a simple SQL
    Procedure and returning a populated datagrid, or datagrid like data presentation model?</p>
  </blockquote>