How to split the data table using C#?

Question

0.00/5 (No votes)

See more:

I use the ASEnumerable() funtion, but dataset.datatable is invalid argument error occur. i include System.linq; namespace and system.data.extensions.dll and the needed dll to my project but still show this error

i will try this code

C#

List<datatable> result = DTHead.AsEnumerable()
            .GroupBy(row => row.Field<int>("MIVID"))
            .Select(g => g.CopyToDataTable())
            .ToList();

Posted 18-Aug-16 19:49pm

Raja Ganapathy

Updated 19-Aug-16 1:45am

Maciej Los

v2

Add a Solution

Comments

Karthik_Mahalingam 19-Aug-16 1:52am

DTHead is datatable or dataset?

Raja Ganapathy 19-Aug-16 1:57am

Datatable

Karthik_Mahalingam 19-Aug-16 2:22am

Always use Reply button, to post Comments/query to the user, so that the user gets notified and responds to your text.

Raja Ganapathy 19-Aug-16 3:05am

DS_test.Tables[0].Columns.Count;

how to split column count wise.

Karthik_Mahalingam 19-Aug-16 2:27am

tested the code, its not throwing any exception, might be you are missing something and you are not telling.

Maciej Los 19-Aug-16 2:32am

Agree!

Raja Ganapathy 19-Aug-16 3:07am

i have n numbers of columns i want to split first 24 columns and rows from the data table.How to do it.

Karthik_Mahalingam 19-Aug-16 3:16am

after split what you have to do

Raja Ganapathy 19-Aug-16 3:22am

After Split I store the table to one table and store another columns and rows in another table.
And the first table to transpose.after transpose merge the two tables and generate xml. :(

Karthik_Mahalingam 19-Aug-16 3:29am

:(

Raja Ganapathy 19-Aug-16 3:33am

i will use this code also but the table is split two part. i don't know how to split the data tables using columns count :(

var totalRows = DS_test.Tables[0].Rows.Count;
DataTable halfway = new DataTable();
halfway = DS_test.Tables[0].Columns(24);
var firstHalf = DS_test.Tables[0].AsEnumerable().Take(halfway).CopyToDataTable();
var secondHalf = DS_test.Tables[0].AsEnumerable().Skip(halfway).Take(totalRows - halfway).CopyToDataTable();

Raja Ganapathy 19-Aug-16 4:19am

i am little bit confused how to split based on count of columns and row from data table.remaining work is finished by another way?

Karthik_Mahalingam 19-Aug-16 4:43am

split is fine, but transpose?

Raja Ganapathy 19-Aug-16 4:45am

:( horizontal split only possible means row wise.

Karthik_Mahalingam 19-Aug-16 4:45am

give some example

Raja Ganapathy 19-Aug-16 4:53am

i will use the manish code.the table have 47 columns 45 rows i give the index range 24 but the table split in row wise means 47 columns and 24 rows.and another table 21 rows 47 columns

Karthik_Mahalingam 19-Aug-16 5:01am

so how do u want to split

Raja Ganapathy 19-Aug-16 5:01am

i want to split 24 columns and 45 rows.

Karthik_Mahalingam 19-Aug-16 5:02am

and store in 2 datatble?

Raja Ganapathy 19-Aug-16 5:04am

s

Karthik_Mahalingam 19-Aug-16 5:05am

ok.

Karthik_Mahalingam 19-Aug-16 5:51am

how is the column names organised?

Raja Ganapathy 19-Aug-16 8:36am

F1,F2,F3.... upto finished.

Karthik_Mahalingam 19-Aug-16 8:40am

Check my solution

Raja Ganapathy 22-Aug-16 1:48am

Working success fully thank you!

Karthik_Mahalingam 22-Aug-16 1:49am

good

4 solutions

Solution 3

C#

<pre lang="C#">DataTable tbl = new DataTable();
            tbl.Columns.Add("Column");
            for (int i = 0; i < 61; i++)
                tbl.Rows.Add(i.ToString());



            DataTable[] splittedtables = tbl.AsEnumerable()
                .Select((row, index) => new { row, index })
                .GroupBy(x => x.index / 12)  // integer division, the fractional part is truncated
                .Select(g => g.Select(x => x.row).CopyToDataTable())
                .ToArray();

DataTable dtarr1 = splittedtables[0];

Posted 18-Aug-16 22:01pm

manishbg

Updated 24-Aug-16 0:55am

v2

Comments

Richard Deeming 19-Aug-16 10:22am

If you want to update your answer, click "Improve solution". DO NOT post your update as a new solution!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2016-08-18T20:30:00

Well... Your code looks good. I tested above query and it works as expected. See:

C#

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ID", typeof(int)));
dt.Columns.Add(new DataColumn("Note", typeof(string)));

dt.Rows.Add(new object[]{1, "A"});
dt.Rows.Add(new object[]{1, "B"});
dt.Rows.Add(new object[]{1, "C"});
dt.Rows.Add(new object[]{2, "D"});
dt.Rows.Add(new object[]{2, "E"});
dt.Rows.Add(new object[]{2, "F"});
dt.Rows.Add(new object[]{3, "G"});
dt.Rows.Add(new object[]{3, "H"});
dt.Rows.Add(new object[]{3, "I"});
dt.Rows.Add(new object[]{4, "J"});
dt.Rows.Add(new object[]{4, "K"});
dt.Rows.Add(new object[]{4, "L"});

//1. method
List<datatable> result = dt.AsEnumerable()
		.GroupBy(x=>x.Field<int>("ID"))
		.Select(grp=>grp.CopyToDataTable())
		.ToList();


////2. method
//var result = dt.AsEnumerable()
//		.GroupBy(x=>x.Field<int>("ID"))
//		.ToList();
//
//List<datatable> dts = new List<datatable>();
//foreach(var d in result)
//{
//	dts.Add(d.CopyToDataTable());
//}</datatable></datatable></int></int></datatable>

"Invalid agument" error is easy to resolve. So, you have to debug your programme to find out where the error occur.
In the meanwhile, please read this: Invalid procedure call or argument (Error 5)[^]

[EDIT]

Raja Ganapathy wrote:

[in the comment to the solution1]
i go through your code sir.i have n numbers of columns i want to split first 24 columns and rows from the data table.How to do it.

If you want to get only few columns, replace:

C#

.Select(grp=>grp.CopyToDataTable())

with

C#

.Select(grp=>grp.Select(a=>new{ 
    Col1 = a.Field<Type>("Name1"),
    Col2 = a.Field<Type>("Name2"),
    ...
    ColN = a.Field<Type>("NameN")
    }).CopyToDataTable())

[/EDIT]

manishbg · Accepted Answer · 2016-08-18T20:16:00

Solution 1

C#

//this is datatable demo

DataTable  tbl = new DataTable();
tbl.Columns.Add("Column");
for(int i=0; i < 61; i++)
    tbl.Rows.Add(i.ToString());



DataTable[] splittedtables = tbl.AsEnumerable()
    .Select((row, index) => new { row, index })
    .GroupBy(x => x.index / 12)  // integer division, the fractional part is truncated
    .Select(g => g.Select(x => x.row).CopyToDataTable())
    .ToArray();

Posted 18-Aug-16 20:16pm

manishbg

Updated 6-Sep-16 21:08pm

Comments

Maciej Los 19-Aug-16 2:31am

In my opinion, that piece of code won't help. Please, read my answer.

Raja Ganapathy 19-Aug-16 3:07am

i go through your code sir.i have n numbers of columns i want to split first 24 columns and rows from the data table.How to do it.

Maciej Los 19-Aug-16 3:14am

Please, see updated answer (solution 2)

manishbg 19-Aug-16 3:09am

DataTable[] splittedtables = tbl.AsEnumerable()
.Select((row, index) => new { row, index })
.GroupBy(x => x.index / 24) // integer division, the fractional part is truncated
.Select(g => g.Select(x => x.row).CopyToDataTable())
.ToArray();

use this

Raja Ganapathy 19-Aug-16 3:34am

How to store the split columns and rows.

manishbg 19-Aug-16 3:50am

data store in array

Raja Ganapathy 19-Aug-16 4:34am

Thank you manish this is split on horizontally. how to do that vertically.

Karthik_Mahalingam · Accepted Answer · 2016-08-19T01:45:00

refer this example and split the columns to a separate tables inside dataset.

C#

DataTable dtMain = new DataTable();
       for (int i = 1; i <= 10; i++)
           dtMain.Columns.Add("col" + i);
       dtMain.Rows.Add(1);


       string[] columnNames = dtMain.Columns.OfType<DataColumn>().Select(k => k.ColumnName).ToArray();
       List<List<string>> lst = new List<List<string>>();


       int splitby = 3;

       int colCount = dtMain.Columns.Count;
       int splitCount = (colCount / splitby) + ((colCount % splitby) > 0 ? 1 : 0);

       for (int i = 0; i < splitCount; i++)
           lst.Add(columnNames.Skip(i * splitby).Take(splitby).ToList()); ;




       DataSet dsFinal = new DataSet();
       for (int i = 0; i < lst.Count; i++)
       {
           DataTable dtTemp = dtMain.Copy();
           dtTemp.TableName = "split" + i.ToString();
           columnNames.Except(lst[i]).ToList().ForEach(col => dtTemp.Columns.Remove(col));
           dtTemp.AcceptChanges();
           dsFinal.Tables.Add(dtTemp);

       }

How to split the data table using C#?

4 solutions

Solution 2

Solution 1

Solution 4

Solution 3

Add your solution here

Preview 0