The “AND” or “OR” in the Datatable.select is not working. dtMasterTable.Select("[Column5] = ‘var1’ AND [Column9] = ‘var2’ ").Count.ToString I am checking, if the particular combination of records from datatable 1(Iterating this Dt) is present in the datatable2 (dtMasterTable). If I select the con…

are var1 and var2 variables? if so it should be dtMasterTable.Select("[Column5] = '"+var1+"' AND [Column9] = '"+var2+"'").Count.ToString you can also print this line before the select statement to check your condition is correct "[Column5] = '"+var1+"' AND [Column9] = '"+var2+"'"

"And" is not working in datable.select

Help Activities

jack.chan (Jack Chan) September 29, 2022, 1:11am 2

@pk123
does it work if you change AND to OR?

and is there a row where Column5 = var1 and Column9 = var2?

Topic		Replies	Views
DT.SELECT not working properly with AND operator Help datatable , activities , error	28	2719	November 16, 2019
Multiple AND Condition in Select Statement on DataTable Help	5	10901	October 13, 2019
Select does not work Help	10	787	May 15, 2019
DataTable Select with both Variables and Contstants Help datatable , activities , variable	6	6775	March 23, 2018
Tutorial in using Select? Help datatable , excel , activities , question	8	922	November 12, 2019

"And" is not working in datable.select

Related topics