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

Question

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:;mso-padding-alt:0mm 5.4pt 0mm 5.4pt;mso-para-margin-top:0mm;mso-para-margin-right:0mm;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0mm;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;} c# winforms I have to following string: 107191907 219070719 308200820 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.

Vulpes · 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 
 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[] {
  
 } StringSplitOptions.None); // line 1 string[] items1 = lines[0].Split(''); dgv1.RowCount++; //create new row in DGV for(int i = 0; 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 { dgv2.Rows[dgv2.RowCount - 1].Cells[i].Value = items2[i]; } // line 3 string[] items3 = lines[2].Split(''); dgv3.RowCount++; for(int i = 0; i { dgv3.Rows[dgv3.RowCount - 1].Cells[i].Value = items3[i]; }

Vulpes · Answer

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 :)

Vulpes · Answer

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[] {
  
 } 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 { dgv.Rows[dgv.RowCount - 1].Cells[j].Value = items[j]; } i++; }

Memento · Answer

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); } }

Memento · Answer

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.

Vulpes · Answer

Is it just one multi-line string you have or an array of three strings?