C# Convert a DataTable to List<string>

Question

I have a 1 row DataTable that I'd like to convert to the following format:

Column1Name : value

Column2Name : value

Column3Name : value

etc...

How can this be accomplished with LINQ??

Thanks!

Ani · Accepted Answer · 2011-09-19 14:17:14Z

3

How about something like:

DataTable table = ...

// Overlays the columns over the only row's items
// and combines each column-item pair as required.
var items = table.Columns
                 .Cast<DataColumn>()
                 .Zip(table.AsEnumerable().Single().ItemArray, 
                      (column, value) => column.ColumnName + " : " + value);

var result = string.Join(Environment.NewLine, items);

Here's another (IMO better) approach:

// Uses the DataRow's column-indexer to match a column with 
// the corresponding row-item.
var items = from DataColumn column in table.Columns
            select column.ColumnName  + " : " + table.Rows[0][column];

var result = string.Join(Environment.NewLine, items);

edited Sep 19, 2011 at 14:17

answered Sep 19, 2011 at 14:11

Ani

114k27 gold badges269 silver badges313 bronze badges

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

1 Comment

user259286 Over a year ago

Thanks! I have tweaked it so it can work for any number of rows. 'var xxx = from DataRow row in table.Rows from DataColumn column in row.Table.Columns select column.ColumnName + " : " + row[column];'

Collectives™ on Stack Overflow

C# Convert a DataTable to List<string>

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related