DataTable's Row's First Column to String Array

Question

I have a DataTable. I want to get every rows first column value and append to a string array. I do not want to use foreach looping for every row and adding to string array. I tried this, but stuck at some point

DataRow[] dr = new DataRow[dtCampaignSubscriberLists.Rows.Count];
dtCampaignSubscriberLists.Rows.CopyTo(dr, 0);
string[] array = Array.ConvertAll(dr, new Converter<DataRow, String>(????));

Thanks

Anthony Pegram · Accepted Answer · 2011-05-25 15:43:11Z

32

string[] array = yourTable
                 .AsEnumerable()
                 .Select(row => row.Field<string>("ColumnName"))
                 .ToArray();

edited May 25, 2011 at 15:43

answered May 25, 2011 at 15:36

Anthony Pegram

128k28 gold badges229 silver badges252 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yagiz Ozturk Over a year ago

Thanks Alot, i guess you forgot parantheses after .AsEnumarable

Anthony Pegram Over a year ago

@Yagiz, indeed, I did. Was typing it directly in. Thanks for pointing it out.

James Michael Hare · Accepted Answer · 2011-05-25 15:39:24Z

5

You could do something like:

dtCampaignSubscriberLists.AsEnumerable().Select(r => r[0].ToString()).ToArray();

answered May 25, 2011 at 15:39

James Michael Hare

38.6k10 gold badges75 silver badges83 bronze badges

1 Comment

GabrielBB Over a year ago

I was going to pick the selected comment code but then i was too lazy to check the column's name in the database so im going with this one :D

Collectives™ on Stack Overflow

DataTable's Row's First Column to String Array

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related