How to get value of all rows from a column in a DataTable?

diamond diamond

Hi,
I want to save all values of last name of this data table in list by linq

| ID | FirstName | LastName | Age | +----+-----------+----------+-----+ |  1 | Alice     | Wannabe  | 22  | |  2 | Bob       | Consumer | 27  | |  3 | Carol     | Detector | 25  |

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Try this:

using System;
using System.Data;
using System.Linq;

class Test
{
static void Main()
{
var dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("FirstName", typeof(string));
dt.Columns.Add("LastName", typeof(string));
dt.Columns.Add("Age", typeof(int));
dt.Rows.Add(1, "Alice", "Wannabe", 22);
dt.Rows.Add(2, "Bob", "Consumer", 27);
dt.Rows.Add(3, "Carol", "Detector", 25);

string[] lastNames = (from DataRow dr in dt.Rows select dr["LastName"].ToString
()).ToArray();

// check it worked
foreach(string lastName in lastNames) Console.WriteLine(lastName);
Console.ReadKey();
}
}

The output should be:

Wannabe
Consumer
Detector
diamond diamond13y ago
Thanksss