title: Split a Gridview in two Grids in c#.net
body: <p>I have a <code>GridView</code> which gets the data from a <code>SQL Server</code> database. </p>
  
  <p>The <code>GridView</code> binds when the user select the date from an <code>CalendarExtender</code>, because the data is different one day to another, also the rows quantity. </p>
  
  <p>E. G., in Saturdays the <code>GridView</code> is filled with 18 rows. In Tuesdays, with 58.</p>
  
  <h2>Concern:</h2>
  
  <p>What I need to do is to split the <code>GridView</code> in 2 parts (2 <code>GridViews</code>). E. G., In tuesdays, 29 rows each <code>GridView</code>, in saturdays, 9 rows each.</p>
  
  <h2>I have tried:</h2>
  
  <p>To bring the daily data into a <code>GridView</code>, called "GVTotal": </p>
  
  <pre><code>if (Weekday.Value == "Saturday")
              {
                  GVTotal.DataSourceID = SaturdayData.ID;
                  GVTotal.DataBind();
              }
  </code></pre>
  
  <p>To count the rows from GVTotal, and divide by 2.</p>
  
  <pre><code>int everything = GVTotal.Rows.Count;
              int half = everything / 2;
  </code></pre>
  
  <p>What I want to do now, is to "Copy" the rows from 0 to <code>half</code> to <code>GVPart1</code>, and from <code>half</code> to <code>everything</code> to <code>GVPart2</code>, in the exactly same order than in <code>GVTotal</code>.</p>
  
  <p>I have read that maybe using a <code>DataTable</code> will made this possible.
  I am not pretty sure how to do that. Could someone help me please?</p>