How can I populate a generic list of string with the results from a single-column DataTable?

Question

I see a lot of complex examples for converting a DataTable with multiple-member rows here but in my case, the query simply returns one column from a table, that is to say 0..N strings/varchars, such as:

bbfinaleofseem@wallacestevens.org
eyenoy@dunbar.com

I thought something like this should work:

DataTable UnitReportPairEmailValsDT = new DataTable();
string qry = string.Format(SQL.UnitReportPairEmailQuery, unit, rptId);
UnitReportPairEmailValsDT = SQL.ExecuteSQLReturnDataTable(
    qry,
    CommandType.Text,
    null
    );

List<String> emailAddresses = new List<string>();
foreach (string emailaddr in UnitReportPairEmailValsDT)
{
    emailAddresses.Add(emailaddr);
}

...but it won't compile ("foreach statement cannot operate on variables of type 'System.Data.DataTable' because 'System.Data.DataTable' does not contain a public definition for 'GetEnumerator'")

I tried appending ".AsEnumerable" to "in UnitReportPairEmailValsDT" too, but that also provoked the wrath of the compiler.

`List dbNames = myDT.AsEnumerable().Select(n => n.Field("Name")).ToList();` — Ňɏssa Pøngjǣrdenlarp, Apr 22 '16 at 17:37

score 2 · Accepted Answer · answered Apr 22 '16 at 17:10

Error says you cannot loop through DataTable object itself, probably what you need is looping through DataRows.

Use this.

foreach(DataRow row in UnitReportPairEmailValsDT.Rows)
{
     emailAddresses.Add(row["emailaddr"].ToString()); // assuming you have emailaddr column.
}

Other option, use Linq

emailAddresses = UnitReportPairEmailValsDT
                         .AsEnumerable()
                         .Select(row=> row.Field<string>("emailaddr"))
                         .ToList();

Benjamin Racette · Answer 2 · 2016-04-22T18:19:00.023

2

try something like this:

List<String> emailAddresses = new List<string>();
foreach (DataRow row in UnitReportPairEmailValsDT.Rows)
{
    emailAddresses.Add(row.Item(0));
}

edited Apr 22 '16 at 18:19

answered Apr 22 '16 at 17:15

Benjamin Racette

172
6

You mean "row.Item(0)" instead of "dr.Item(0)" right? – B. Clay Shannon-B. Crow Raven Apr 22 '16 at 17:24
This works (compiles, anyway): emailAddresses.Add(dr[0].ToString()); – B. Clay Shannon-B. Crow Raven Apr 22 '16 at 17:24

score 1 · Answer 3 · answered Apr 22 '16 at 17:39

Suppose dt is your data table then using Linq: dt.Rows.Select(x=> x[0]+"").ToList() will give you List. Beware of using Select(x=>xToString()) as it is prone to error if column value is null. x[0]+"" makes sure that in case of null empty string is returned.

How can I populate a generic list of string with the results from a single-column DataTable?

3 Answers3