CriteriaOperator.LegacyToString() Method

Returns the string representation of the criteria specified by the current CriteriaOperator instance.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v18.2.dll

Declaration

C#

public string LegacyToString()

VB.NET

Public Function LegacyToString As String

Returns

Type	Description
String	A string equivalent of the current CriteriaOperator instance.

Remarks

Unlike the CriteriaOperator.ToString method, the LegacyToString method removes value suffixes (such as ‘m’, ‘M’, ‘l’, ‘L’, ‘f’, ‘F’, etc.) used to specify types of numeric literals in criteria operands. You can call the LegacyToString method to display the returned string in a UI, or save it to an application log. However, this string is actually not in SQL format and cannot be considered as such. If you want to use the string for building SQL queries or for filtering DataView, use the approach described in the How to convert the CriteriaOperator to the corresponding filter string in order to use it for building SQL queries or for filtering the DataView Knowledge Base article.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the LegacyToString() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-use-the-filtercontrol-in-unbound-mode-e597/CS/Form1.cs#L28

private void filterControl1_FilterChanged(object sender, DevExpress.XtraEditors.FilterChangedEventArgs e) {
    labelControl1.Text = filterControl1.FilterCriteria.LegacyToString(); // SQL-like filter
}

VB.NET

how-to-use-the-filtercontrol-in-unbound-mode-e597/VB/Form1.vb#L30

Private Sub filterControl1_FilterChanged(ByVal sender As Object, ByVal e As DevExpress.XtraEditors.FilterChangedEventArgs) Handles filterControl1.FilterChanged
    labelControl1.Text = filterControl1.FilterCriteria.LegacyToString() ' SQL-like filter
End Sub