Our Training Programs

All contents are copyright of their authors.

DataTable

DataTable

13yAsked Apr 11, 2013, 5:14 PM1.7kLearn iOS Programming

hello.Below I showed datatable.Which I get from sql.I need to add second row 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

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Vulpes13y ago
Accepted answer
If dt is your DataTable try:

dt.Rows[0]["NAME"] = dt.Rows[1]["NAME"];
dt.Rows.RemoveAt(1);
Vulpes13y ago
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);
}
13y ago
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