Linq how to exclude OrderID from a other Datatable

Help Studio
,
8

@Yoichi many thanks for your Solution

Linq_Filter_Report.zip (14,1 KB)

In Case if ‘Rate’ = IsNullOrEmpty i would be use the integer value = 0

# Rate NULL is a exception (don't output the Row)
Where Int32.TryParse(d("Rate").ToString,New Int32) AndAlso Int32.Parse(d("Rate").ToString) > 47

# Rate = NULL use int32 = 0

	Let v = d("Rate")
	Let chk1 = Not ( isNothing(v) OrElse String.IsNullOrEmpty(v.ToString.Trim))
	Let chk2 = If(chk1, Double.TryParse(v.ToString, Nothing), False)
	Let x = If(chk2, Double.Parse(v.ToString()), 0)
Where x <= 47

@ashwin.ashok thanks for your Support

1 Like