CriteriaOperator.ToBasicStyleString(CriteriaOperator, out OperandValue[]) Method
Converts the specified expression into its equivalent string in VB style.
Namespace: DevExpress.Data.Filtering
Assembly: DevExpress.Data.v25.1.dll
NuGet Package: DevExpress.Data
Declaration
public static string ToBasicStyleString(
CriteriaOperator criteria,
out OperandValue[] criteriaParametersList
)
Parameters
| Name | Type | Description |
|---|---|---|
| criteria | CriteriaOperator | A CriteriaOperator object that represents the expression to convert. |
| criteriaParametersList | OperandValue[] | [out] Receives the values that are marked by a question mark character in the result string. |
Returns
| Type | Description |
|---|---|
| String | A string representation of the specified expression. |
Remarks
This example demonstrate how to use the ToBasicStyleString method:
OperandValue[] parameters;
CriteriaOperator filterCriteria =
CriteriaOperator.Parse("[Category] == ? && [Price] < ?", out parameters);
parameters[0].Value = "Saloon";
parameters[1].Value = 100000;
// Returns "[Category] = ? AND [Price] < ?"
string filterString = CriteriaOperator.ToBasicStyleString(filterCriteria, out parameters);
To convert the string representation of an expression to its CriteriaOperator equivalent, use the CriteriaOperator.Parse method.
Note
The ToBasicStyleString method returns a string representation of the criteria which can be displayed in a UI or saved in application log. However, this string is actually not SQL and cannot be considered as such.