hi steps 1.read and excel saved in dt 2.now status is a datarow type when i add single condition where dt.select(“name = ‘tom’”) this works but when i add second condition its showing error i want check for both condition and get all rows as per that

Hi @RajKumar_DC , Just double the quotes that comes in between the filter Dt_Table.select(“Col1=‘Man Do’‘na’”) if you want to add it dynamic Dt_Table.select(“Col1=”+str_youfilter.replace(“'”,“‘’”)+“'”)

Getting error when adding two conditions

Help Studio

Rahul_Unnikrishnan (Rahul Unnikrishnan) October 31, 2022, 10:43am 5

OutDatatable = dt.Select(“name = ‘tom’ AND call = ‘2’”).CopyToDataTable

OutDatatable is a datatable variable

dt is the input variable(Datatable variable)

Topic		Replies	Views
Linq error condition Activities excel , activities , question	4	163	April 12, 2024
I met a problem when I was using select() to search Datatable Help	5	1077	October 4, 2019
Select method using where condition Help	12	3646	February 1, 2020
How to handle this Studio studio , question , designer_canvas	10	1057	April 26, 2022
How to use filter DT for 2 conditions Studio datatable , studio , question , activities_panel , linq	4	770	August 15, 2021

Getting error when adding two conditions

Related topics