title: multiple resultsets in stored procedures
body: <p>I have a stored procedure that is a class in my project.  I gain the data returned by following:</p>
  
  <pre><code>EMTS.SPs.PrcEMTSDataLookup(so).GetDataSet().Tables[0].Copy()
  </code></pre>
  
  <p>This is placed in a <code>dataset</code>.  The issue is the stored procedure has several selects and each select needs to be placed in a separate grid.  </p>
  
  <p>I have tried <code>IDataReader</code> and <code>IDataAdapter</code> but have not had any luck pulling data from the stored procedure object.  I have research microsoft for information on <code>IDataAdapter</code> and the example they give uses <code>SqlDataAdapter</code> which is not necessary for me since the stored procedure is an object in the project.  </p>
  
  <p>So how do I get the different result sets in the <code>sp</code> and put them in separate grids?</p>