title: how to collect multiple dataset data into one dataset?
body: <p>I need to show multiple records together in a gridview in c# with SQL.</p>
  
  <p>i have an array of Id's using those id's i need to get all details correspond to those id's.</p>
  
  <p>i have an array <code>ID[]</code> <code>Dataset ds</code></p>
  
  <pre><code>for(int i=0; i&lt;=ID.Length-1; i++)
  {
     dss = fill_DS("select Client_id, F_name, L_name, Ph, Alt_ph, Time_date, Plan_duration, Brand, Email from Client_detail where Client_id='" + ID[i]+ "'");
  }
  </code></pre>
  
  <p>Second method</p>
  
  <pre><code>public static DataSet fill_DS(string query)
  {
      DataSet ds=null; 
      try
      {
          SqlDataAdapter da = new SqlDataAdapter(query, con);
          ds = new DataSet();
          da.Fill(ds);
      }
      catch (Exception ex)
      {
      }
      return ds;
  }
  </code></pre>
  
  <p>It only returns me the result of the last row only or for last id only. i need to combine the rows for all id's and show them in a gridview.</p>
  
  <p>How to do this?</p>