I have a `GridView` which gets the data from a `SQL Server` database. 

The `GridView` binds when the user select the date from an `CalendarExtender`, because the data is different one day to another, also the rows quantity. 

E. G., in Saturdays the `GridView` is filled with 18 rows. In Tuesdays, with 58.

Concern:
--------

What I need to do is to split the `GridView` in 2 parts (2 `GridViews`). E. G., In tuesdays, 29 rows each `GridView`, in saturdays, 9 rows each.

I have tried:
-------------

To bring the daily data into a `GridView`, called "GVTotal": 

```
if (Weekday.Value == "Saturday")
            {
                GVTotal.DataSourceID = SaturdayData.ID;
                GVTotal.DataBind();
            }

```

To count the rows from GVTotal, and divide by 2.

```
int everything = GVTotal.Rows.Count;
            int half = everything / 2;

```

What I want to do now, is to "Copy" the rows from 0 to `half` to `GVPart1`, and from `half` to `everything` to `GVPart2`, in the exactly same order than in `GVTotal`.

I have read that maybe using a `DataTable` will made this possible.
I am not pretty sure how to do that. Could someone help me please?