Is there a way to use the DataTable.Compute Method with 2 or more filters, i have googled a bit and cant seem to come up with answer?
If not perhpas there is another way to accomplish
Thanks for any help and or insight
Current code Code:
Dim Dt As Decimal = NumericUpDown1.Value dtlist.Rows(i)("Value") = dtsold.Compute("Max(ClosePrice)", "Distance <=" & Dt & "")
I want something like this
psuedo code Code:
Dim Dt As Decimal = NumericUpDown1.Value dtlist.Rows(i)("Value") = dtsold.Compute("Max(ClosePrice)", "Distance <=" & Dt & " and "BuildingSize<= MAXGla"")
in other words DT.Compute(Max(Col1), where Col2<=? and Col3 <=?




Reply With Quote