How can I convert DataRow to string Array?

Question

I have some values in a DataGridRow (item Array) and I want to fetch all these values into a string array. How can I achieve this?

DataGridRow row = (DataGridRow)Lst.ItemContainerGenerator.ContainerFromIndex(k);
            DataRowView Drv = (DataRowView)row.Item;
            DataRow dr = (DataRow)Drv.Row;

What is the content of you data rows? The answer depends on that. — Rune Grimstad, Sep 20 '10 at 07:05

score 32 · Answer 1 · edited Apr 18 '12 at 15:09

32

var rowAsString = string.Join(", ", dataTable.Rows[0].ItemArray);

No need of any lambda expresion as above.

edited Apr 18 '12 at 15:09

Xharze

2,703
2
17
30

answered Apr 18 '12 at 06:54

Jiss

321
1
3
3

score 17 · Accepted Answer · answered Sep 20 '10 at 07:03

17

One possibility is to call dr.ItemArray; This will get you a object[]. Then you have to cast each object to string before you use it.

answered Sep 20 '10 at 07:03

Øyvind Bråthen

59,338
27
124
151

score 10 · Answer 3 · answered Jun 10 '12 at 13:19

10

LINQ adds some sugar:

var stringArray = dr.ItemArray.Cast<string>().ToArray()

answered Jun 10 '12 at 13:19

cyrotello

757
9
26

Rune Grimstad · Answer 4 · 2017-07-29T21:55:29.980

7

var rowAsString = string.Join(", ", dr.ItemArray.Select(c => c.ToString()).ToArray());

This should give you a string with each item in your data row separated by a comma.

edited Jul 29 '17 at 21:55

answered Sep 20 '10 at 07:06

Rune Grimstad

35,612
10
61
76

2

Only acceptable answer. Other answers will throw error if and of item aren't string type. – nelek Oct 09 '15 at 05:58
How does this work?! DataRow (dr) has no Select (and definately no Selct ;-) ) – Xan-Kun Clark-Davis Jul 28 '17 at 23:43
:-) Oops! There was two typos in the answer. First, i had forgotten to access the ItemArray and second the method name should of course be Select ;-) – Rune Grimstad Jul 29 '17 at 21:56

score 1 · Answer 5 · answered Mar 29 '18 at 19:11

1

This one worked for me:

string[] months = string.Join(",", dataTable.Rows[0].ItemArray).Split(',').ToArray();

answered Mar 29 '18 at 19:11

olleh

1,915
18
21

How can I convert DataRow to string Array?

5 Answers5