title: How can I read multiple tables into a dataset?
body: <p>I have a stored procedure that returns multiple tables. How can I execute and read both tables?</p>
  
  <p>I have something like this:</p>
  
  <pre>
  <code>
  SqlConnection conn = new SqlConnection(CONNECTION_STRING);
  SqlCommand cmd = new SqlCommand("sp_mult_tables",conn);
  cmd.CommandType = CommandType.StoredProcedure);
  
  IDataReader rdr = cmd.ExecuteReader();
  </code>
  </pre>
  
  <p>I'm not sure how to read it...whats the best way to handle this type of query, I am guessing I should read the data into a DataSet? How is the best way to do this?</p>
  
  <p>Thanks.</p>