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

keerthi3595 (Keerthana M ) November 1, 2022, 2:18am 11

Hi @RajKumar_DC,

Can you try below expression instead

(from row in dt where row(“Col1”).tostring=“Ma Do’na” and row(“col2”).tostring=“yourfilter2” select row).copytodatatable

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