Split a muliline string by comma and place string parts into DataGridView

Memento

c# winforms

I have to following string:
1,07,19,19,07
2,19,07,07,19
3,08,20,08,20

I need each line to place into separate DataGridViewRow, and each part of line (split by comma) into separate DataGridViewColumn:
1 07 19 19 07
2 19 07 07 19
3 08 20 08 20

Please, help.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
This code assumes that you have a single multi-line string, 'line' ,where each row is separated by one of the standard line separators - usually "\r\n" in Windows.

If instead you have an array of 3 strings, 'lines', then just ignore the first line of code:

string[] lines = line.Split(new string[] {"\r\n", "\r", "\n" }, StringSplitOptions.None);

// line 1
string[] items1 = lines[0].Split(',');
dgv1.RowCount++; //create new row in DGV
for(int i = 0; i < items1.Length; i++)
{
dgv1.Rows[dgv1.RowCount - 1].Cells[i].Value = items1[i];
}

// line 2
string[] items2 = lines[1].Split(',');
dgv2.RowCount++;
for(int i = 0; i < items2.Length; i++)
{
dgv2.Rows[dgv2.RowCount - 1].Cells[i].Value = items2[i];
}

// line 3
string[] items3 = lines[2].Split(',');
dgv3.RowCount++;
for(int i = 0; i < items3.Length; i++)
{
dgv3.Rows[dgv3.RowCount - 1].Cells[i].Value = items3[i];
}
Vulpes14y ago
Yes, that code's fine if you only have one DGV.

I'd forgotten that the Rows.Add method has an overload which allows you to populate all cells from an array so that's a nice touch too :)
Memento14y ago
The number of lines could vary, but dgv is allways one - the same.
I found that these code also works. Could you, please give me your opinion:

    object val = dgvObs.Rows[0].Cells[2].Value;
    if (val == null) return;
    string text = val.ToString();
    using (StringReader sr = new StringReader(text))
    {
    string line;
    while ((line = sr.ReadLine()) != null)
    {
    string[] divLine = line.Split(',');
    dgvSm.Rows.Add(divLine);
    }
    }
Vulpes14y ago
Yes, you can do it using foreach if the number of lines (and dgvs) could vary. The following is untested:

string[] lines = line.Split(new string[] {"\r\n", "\r", "\n" }, StringSplitOptions.None);

DataGridView[] dgvs = new DataGridView[]{dgv1, dgv2, dgv3}; // add others as needed

int i = 0;

foreach(DataGridView dgv in dgvs)
{
string[] items = lines[i].Split(',');
dgv.RowCount++; //create new row in DGV

for(int j = 0; j < items.Length; j++)
{
dgv.Rows[dgv.RowCount - 1].Cells[j].Value = items[j];
}

i++;
}
Memento14y ago
Yes, Vulpes, it's a single multiline string and - it works perfectly. ThankYou, so much. !!!

I'm just interesting - is here possible to write foreach line loop ?
If it is - please give me just a first line or two.
Because, next time maybe starting string could have more lines.
And congratulations for new forum design, especially for the "accepted" tape. Very nice.
Vulpes14y ago
Is it just one multi-line string you have or an array of three strings?