DataTable

Question

hello.Below I showed datatable.Which I get from sql.I need to add second row <Name > value to first NULL row and remove second row programmatically.

So, they are same rows.Only name and surname showed on different rows.I need join them in one row.Help please.

ID | NAME | SURNAME |

--------------------------------

1 | null | MIKE

-------------------------------

1 | JON | null

Thanks in advance

Vulpes · Answer

If dt is your DataTable try: dt.Rows[0][NAME] = dt.Rows[1][NAME]; dt.Rows.RemoveAt(1);

Vulpes · Answer

If you had a series of pairs of lines such as this then yes you could combine them into one row by looping though you'd need to iterate backwards through the Rows collection given that multiple deletions are taking place: for(int i = dt.Rows.Count - 1; i >= 0; i -= 2) { dt.Rows[i - 1][NAME] = dt.Rows[i][NAME]; dt.Rows.RemoveAt(i); }

Ilkin Turk · Answer

Hello Vulpes. if there are a lot of columns which need to combine in one row if it possible to make this with looping?Not one by one. Thanks