title: How many tables a dataset can return using stored procedure
body: <p>I am using a stored procedure wich contains 6 select queries and I am executing this stored procedure from C#. I am getting the tables in dataset of only first 3 queries. i.e. the data is retrieved from first 3 queries I used. The dataset contains only 3 tables.</p>
  
  <p>I am unable to understand what's wrong or whether executing the stored procedure from C# can retrieve a maximum of only 3 tables </p>
  
  <p>UPDATE:</p>
  
  <pre><code>Create Procedure myTest
      @paraID as bigint
  AS
  </code></pre>
  
  <p>Here I have written 6 select queries using the parameter <code>@paraid</code> in <code>where</code> clause</p>
  
  <p>In C#:</p>
  
  <pre><code>SqlConnection con = new SQLConnection();
  SqlCommand cmd = new SQLCommand();
  SqlDAtaadpter adpt = new SqlDataadapter();
  
  DataSet ds = new DataSet();
  
  con.ConnectionString = "MyConnectionString";
  
  con.Open();
  cmd.CommandType= CommandType.StoredProcedure;
  cmd.CommandText ="mytest";
  cmd.Parameters.Add("@paraID", SqlDbType.Bigint).value = 1;
  
  cmd.Connection = con;
  
  adpt.SelectCommant = cmd;
  adpt.Fill(ds);
  
  con.Close();
  </code></pre>
  
  <p>This is my c# code. Now tell me what has to be done</p>