Datatable select with multiple conditions

c# select datatable
Arnkrishn picture Arnkrishn · Jan 2, 2010 · Viewed 424.4k times · Source

I have a datatable with 4 columns A, B, C and D such that a particular combination of values for column A, B and C is unique in the datatable.

Objective: To find the value of column D, for a given combination of values for column A, B and C.

I guess looping over the set of data rows should do it. Is there a way to use Datatable.Select() to accomplish this? To be more specific - can I have multiple conditions in the select filter i.e. a logical AND operator connecting conditions for each of the columns A, B and C.

Answer

Michael Petrotta picture Michael Petrotta · Jan 2, 2010

Yes, the DataTable.Select method supports boolean operators in the same way that you would use them in a "real" SQL statement:

DataRow[] results = table.Select("A = 'foo' AND B = 'bar' AND C = 'baz'");

See DataColumn.Expression in MSDN for the syntax supported by DataTable's Select method.

Related questions

How to select distinct rows in a datatable and store into an array

I have a dataset objds. objds contains a table named Table1. Table1 contains column named ProcessName. This ProcessName contains repeated names.So i want to select only distinct names.Is this possible. intUniqId[i] = (objds.Tables[0].Rows[i]["ProcessName"].ToString());

Read More
How to select min and max values of a column in a datatable?

For the following datatable column, what is the fastest way to get the min and max values? AccountLevel 0 1 2 3

Read More
Select and updating data from datatable

I select data from my datatable, by using following code: DataRow[] result = table.Select("Size >= 230 AND Sex = 'm'"); Now I change the data in the datarow-array result and I want to update my datatable (datatable should get the changes). …

Read More