Hello Good People,
Am trying to filter out 0 for that column using the linq query below but it isn’t working and I’ve tried others but I have failed.
dTVariances.AsEnumerable.Where(Function(row) Not double.Parse(row("Variance (FCY)").ToString)=0).CopyToDataTable
dTVariances.AsEnumerable().Where(Function(row) Information.IsNumeric(row(8).ToString)).AsEnumerable().Where(function(row) Not double.Parse(row(8).ToString)=0).CopyToDataTable
Kindly advise on what I might be missing out on.
Thank you.
Kakooza Allan Klaus