Now I use code as below.
dt_Input = (
From inputrow In dt_Input
Join reportrow In dt_Report
On inputrow("SR").ToString Equals reportrow("sr1").ToString And inputrow("act").ToString Equals reportrow("act1").ToString
Where Not reportrow("Close").ToString.ToLower.Trim.Contains("working")
Select dt_Output.Rows.Add(inputrow.ItemArray)
).CopyToDatatable
I change to as below. (add condition or )
dt_Input = (
From inputrow In dt_Input
Join reportrow In dt_Report
On inputrow(“SR”).ToString Equals reportrow(“sr1”).ToString And inputrow(“act”).ToString Equals reportrow(“act1”).ToString
Or inputrow(“SR”).ToString Equals reportrow(“sr1”).ToString
Where Not reportrow(“Close”).ToString.ToLower.Trim.Contains(“working”)
Select dt_Output.Rows.Add(inputrow.ItemArray)
).CopyToDatatable
It error.
Please guide me for solve it.
Thank you.
