using System;

using System.Data;

using System.Linq;

using System.Text;

using System.Collections.Generic;

public class Program

{

    public static void Main()

    {

        DataTable dt = InitDataTable();

        List<string> emails = new List<string>();

​

        // Solution 1

        foreach (DataRow row in dt.Rows)

        {

            emails.Add(row["Email"].ToString());

        }

        Console.WriteLine(String.Join(";", emails));

        // Solution 2

        Console.WriteLine(String.Join(";", dt.AsEnumerable()

                                      .Select(x => x["Email"].ToString())

                                      .ToList()));

    }

    public static DataTable InitDataTable()

    {

        DataTable dt = new DataTable();

        dt.Columns.Add("Email", typeof(string));

        dt.Columns.Add("name", typeof(string));

        dt.Columns.Add("phone", typeof(string));

        DataRow row1 = dt.NewRow();

        row1["Email"] = "Why@aol.com";

        row1["name"] = "frank";

        row1["phone"] = "213-444-1911";

        dt.Rows.Add(row1);

        DataRow row2 = dt.NewRow();

        row2["Email"] = "Why@aol.com";

        row2["name"] = "shawn";

        row2["phone"] = "213-444-1092";

        dt.Rows.Add(row2);

        DataRow row3 = dt.NewRow();

        row3["Email"] = "Sit@aol.com";

        row3["name"] = "Wow@aol.com";

        row3["phone"] = "213-444-1229";

        dt.Rows.Add(row3);

        DataRow row4 = dt.NewRow();

        row4["Email"] = "Who@aol.com";

        row4["name"] = "shane";

        row4["phone"] = "213-444-1769";

        dt.Rows.Add(row4);

        return dt;

    }

}