Converting DataTable to anonymous two-dimensional array

Question

I'm struggling a little bit with this and can't seem to find an answer here. I am using the SautinSoft Document plug-in to create a mail merge in MS Word. The data source is my issue. My data in a DataTable, whereas the function they have coded to pass the data is in an anonymous array:

        var dataSource = new[] 
        { new { FirstName = "Hector", LastName = "Stupid", Age = "40" },  
          new { FirstName = "Penelope ", LastName = "Plank", Age = "25" }
        };

So, I need to iterate through my DataTable populating the fields into this format with their values.

Then, I execute the Mail Merge thus:

        dc.MailMerge.Execute(dataSource);

The question is how? Since the array is being statically populated. I've tried many solutions, passing either the DataTable, converting to a Dictionary, and .ToArray() over Ienumerable, but nothing seems to replicate this format.

Many thanks in advance.

Why is datasource.Select(row => new { FirstName = row.whatever, LastName = row.whateverelse, Age = row.whatever }).ToArray() not working for you? — Tanveer Badar
– Tanveer Badar, Commented Oct 4, 2018 at 18:43

D-Shih · Accepted Answer · 2018-10-04 18:47:54Z

2

If I understand correctly you can try to use AsEnumerable method let DataTable to IEnumerable<Row> then use select fill data.

datasource
    .AsEnumerable()
    .Select(row => new {
        FirstName = row["FirstName"],
        LastName = row["LastName"],
        Age = row["Age"]
    }).ToArray()

answered Oct 4, 2018 at 18:47

D-Shih

46.5k6 gold badges37 silver badges56 bronze badges

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

2 Comments

Davy C Over a year ago

Thank you! Works perfectly.

D-Shih Over a year ago

@DavyC No problem glad to help you can mark this answer if that help you :)

Collectives™ on Stack Overflow

Converting DataTable to anonymous two-dimensional array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related