CODEWITHSUNDEEP
linqilist
Rhonda
Rhonda

Reputation: 985

Convert a DataTable to IList

I am updating some legacy that has a Table that only contains one row. I want to convert it to an IList. The idea is that the first property of IFoo is Name which would be the column name from the Table and the second if Value which is the value of the column. 

/// <summary>
/// Name = Column Name
/// </summary>
String Name { get; set; }
/// <summary>
/// Value = Column Value
/// </summary>
String Value { get; set; }

The data may look something this 

Foo1     Foo2     Foo3    Foo4     Foo5

xyz      zyx      abc     def      ghi

And would be:

Foo1, xyz

Foo2, zyx

Foo3, abc

Foo4, def

Foo5, ghi

I am not really sure how to accomplish this. Seems like there could be a linq query to do it. Any help would be appreciated.

Rhonda

Upvotes: 3

Views: 2571

Answers (2)

roman
roman

Reputation: 117540

Looks like classic SQL columns to rows task. I've added column ID so you can use this query for more than one row:

var dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Foo1");
dt.Columns.Add("Foo2");
dt.Rows.Add(1, "xyz", "abc");
dt.Rows.Add(2, "cds", "tgf");

var q = from row in dt.Rows.Cast<DataRow>()
        from col in dt.Columns.Cast<DataColumn>()
        select new {
            ID = row["ID"],
            Name = col.ColumnName,
            Value = row.IsNull(col) ? null : row[col]
        };
q.ToList()

ID, Name, Value
1   Foo1  xyz
1   Foo2  abc
2   Foo1  cds
2   Foo2  tgf

or, if you want to create a Dictionary

q.ToDictionary(x => new { x.ID, x.Name}, x => x.Value)

Upvotes: 0

Tim Schmelter
Tim Schmelter

Reputation: 460238

Perhaps (works also if the table contains more rows):

IList<Foo> data = table.AsEnumerable()
    .SelectMany(r => table.Columns.Cast<DataColumn>()
        .Select(col => new Foo
        {
            Name = col.ColumnName,
            Value = r.IsNull(col) ? null : r[col].ToString()
        }))
    .ToList();

Upvotes: 4

Related Questions