c# - How to split a DataTable in two separate by columns -

i have datatable has many columns , 1 row:

... dataset mydataset = new dataset(); da.fill(mydataset);  mydatatable = new datatable(); mydatatable = mydataset.tables[0]; ... 

how can split dataset/datatable have equal amount of columns (if odd number, split columns first datatable has column).

scenario #1:

main datatable:

col1    col2    col3    col4    col5    col6    col7    col8 9       0       9       5       7       4       9       3 

datatable1:

col1    col3    col3    col4 9       0       9       5 

datatable2:

col5    col6    col7    col8 7       4       9       3 

scenario #2:

main datatable:

col1    col2    col3    col4    col5    col6    col7 9       0       9       5       7       4       9 

datatable1:

col1    col3    col3    col4 9       0       9       5 

datatable2:

col5    col6    col7 7       4       9 

you can copy whole data table , remove columns don't want.

so first example, following code return first 4 columns in datatable1 , remaining columns in datatable 2.

you can modify code per number of columns

datatable datatable1; datatable1 = mydatatable.copy(); datatable1.columns.removeat(4); datatable1.columns.removeat(5); datatable1.columns.removeat(6); datatable1.columns.removeat(7);  datatable datatable2; datatable2 = mydatatable.copy(); datatable2.columns.removeat(0); datatable2.columns.removeat(1); datatable2.columns.removeat(2); datatable2.columns.removeat(3);