Need help/advice in resolving a select from datatable

Hi,

I think it’s simple and better to use LINQ as the following.

mydatatablevariable.AsEnumerable.Where(Function(r) r("columnname1").ToString = stringvariable1 AndAlso r("columnname2").ToString=stringvariable2 AndAlso Double.Parse(r("columnname3containingInt").ToString)>=Double.Parse(stringvariable3containingInt) AndAlso Double.Parse(r("columnname4containingInt").ToString)>=Double.Parse(stringvariable4containingInt)).ToArray

Regards,

1 Like