CODEWITHSUNDEEP
c#linqdatatable
Chris
Chris

Reputation: 934

C# Linq get values from column B if column A matches

Based on the table below, I'd like to use Linq to get all of the device names associated with Test ID 1a and store them in a list, is this possible? Assuming that is not always known which Test ID will be listed more than once. 

Test ID    DeviceName
1a         dev1
1b         dev2
1a         dev2
1c         dev1

Upvotes: 0

Views: 2728

Answers (1)

ChrisF
ChrisF

Reputation: 137158

If all you want to do is read all the values from column B then the following query is all you should need:

string testID;
// set testID from somewhere (user input, config file, another query etc.)

var results = dataTable.Where(t => t.Id == testID).Select(t => t.DeviceName).ToList();

results will be of type List<string>.

Upvotes: 2

Related Questions