String array to datatable

Question

In my resources I have a string that looks like this: One,Two;Three,Four;Five,Six etc.

And I need that string to be converted to a DataTable that would look like this:

| Col 1 | Col 2 |

| One   | Two   |

| Three | Four  |

| Five  | Six   |

Is there an elegant(not having to write many lines of code) way to convert that string into a DataTable without having to use 2 splits and a for loop to accomplish it?

Edit I've found the following code: Array.ForEach(input, c => dataTable.Rows.Add()[0] = c); but from what I see it can only be used if you want the DataTable to have just one column.

"Elegant" is pretty subjective. Short answer: No. You're going to have to slice and dice that string somehow to get the different elements in it. There are many ways to do it, however...and none of them are particularly difficult. — Idle_Mind
– Idle_Mind, Commented Jan 29, 2015 at 19:35

A. Abramov · Accepted Answer · 2015-01-29 19:35:07Z

You pretty much named it; what you need to do is split the strings, and insert them in couples. If you have 1 extra string (The amount of substrings is not-odd), insert the last one in the end of the database in it's own row.

string yourString = "insert your string"
string[] Splits = yourString.split(",");// Dividing your string by "," chars.
int i=0;// declaring it here for using it later to check if the number is odd
for(int i=0; i < Splits.Length-1; i+=2)
{
InsertIntoDatabase(Splits[i,i+1]); //Inserting two strings into the database
}
//if i is odd, i will be equal exacly to the Length here. Otherwise...
if(i<Splits.Length)
{
InsertIntoDatabase(Splits[i]); // Insert the last string in it's own row.
}

InsertIntoDatabase has to insert 2 strings ( i can't implement it myself for you since i dont really know what DB& Settings you are using) and go one line down. Overload it with a function that recieves a single string, and you got yourself a good way to go. :)

EDIT: Elegant.. Just saw from the comments. I am not sure what you really mean by that, But i guess you could override the string.Split and send the string to the DB each time you split it - might make it slightly more "elegant", but that's up to your defintion. Good luck

mybirthname · Accepted Answer · 2015-01-29 19:39:35Z

0

            DataTable tbl = new DataTable();
            tbl.Columns.Add("Col1");
            tbl.Columns.Add("Col2");

            string numbers ="One,Two;Three,Four;Five,Six";

            string[] array = numbers.Split(';');

            foreach(string s in array)
            {
                DataRow row = tbl.NewRow();
                string[] numb = s.Split(',');
                row["Col1"] = numb[0];
                row["Col2"] = numb[1];

                tbl.Rows.Add(row);
            }

Here is the code which you need. Next time do something from your side first and show your effort.

answered Jan 29, 2015 at 19:39

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

Comments

Habib · Accepted Answer · 2015-01-29 19:39:45Z

0

You will need multiple split and a loop.

You can use DataTable.LoadDataRow method like:

string str = "One,Two;Three,Four;Five,Six";
DataTable dt = new DataTable();
dt.Columns.Add("Col1", typeof(string));
dt.Columns.Add("Col2", typeof(string));
str.Split(';').ForEach(r => dt.LoadDataRow(
                                r.Split(',').Select(t => (object)t).ToArray()
                                , LoadOption.OverwriteChanges));

That will populate DataTable with the string values as you want.

Now, if this is elegant enough, that depends!.

answered Jan 29, 2015 at 19:39

Habib

224k30 gold badges420 silver badges446 bronze badges

Comments

void · Accepted Answer · 2015-01-29 20:08:16Z

0

if you don't want to split it two times with using for loop then one way is to extract the string into a 2D array and then:

DataTable table = new DataTable();
table.Columns.Add("col1", typeof(string));
table.Columns.Add("col2", typeof(string));

String val="One,Two;Three,Four;Five,Six";
string[][] values=val.Split(';').Select(x => x.Split(',')).ToArray();

for (int i= 0; i< values.Length; i++)
   {
       DataRow newRow = table.NewRow();
       for (int j= 0; j< 2; j++)
        {
           newRow[i] = values[i,j];
        }
       table.Rows.Add(newRow);
    }

edited Jan 29, 2015 at 20:08

answered Jan 29, 2015 at 19:58

void

7,9403 gold badges29 silver badges47 bronze badges

Collectives™ on Stack Overflow

String array to datatable

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related