We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
|
//DividedValue that returns DivideByZero if any of the argument value is zero else returns divided value
private string DividedValue(string args)
{
// Get the list delimiter (for en-us, it is a comma).
char comma = Convert.ToChar(this.gridGroupingControl1.Culture.TextInfo.ListSeparator);
string[] arguments = args.Split(comma);
decimal arg1, arg2;
if (decimal.TryParse(arguments[0], System.Globalization.NumberStyles.Any, null, out arg1)
&& decimal.TryParse(arguments[1], System.Globalization.NumberStyles.Any, null, out arg2))
{
//returns DivideByZero if any of the column value is zero
if (arg1 == 0 || arg2 == 0)
{
return "DivideByZero";
}
else
return Math.Abs(arg1 / arg2).ToString();
}
return "Invalid input";
}
|
|
//Adding Custom function to Expression Field
this.gridGroupingControl1.TableDescriptor.ExpressionFieldEvaluator.AddFunction("Divide", new ExpressionFieldEvaluator.LibraryFunction(DividedValue));
// Adding the Expressions using DividedValue function.
ExpressionFieldDescriptor expField = new ExpressionFieldDescriptor("Divide", "Divide([CategoryName],[CategoryID])", typeof(System.String));
//Adding the custom ExpressionField to Grid
this.gridGroupingControl1.TableDescriptor.ExpressionFields.Add(expField); |
