Telerik Winforms RadGridView未过滤

Question

我正在尝试让Telerik RadGridview控件进行过滤，但没有任何运气。我正在找回数据，排序也在起作用。FilterExpressionChanged正在启动。有人能发现我做错了什么吗？

数据检索：

public void LoadData()
{
    DataSet oDataSet = new DataSet();
    using (SqlConnection oConnection = new SqlConnection(frm_Main.GetConnectionString()))
    {
        using (SqlCommand oCommand = new SqlCommand())
        {
            oConnection.Open();
            oCommand.Connection = oConnection;
            oCommand.CommandText = "SELECT * FROM ip.t_Dataload UNION ALL SELECT * FROM ip.t_Dataload_his ORDER BY Started DESC";

            using (SqlDataAdapter oDataAdapter = new SqlDataAdapter(oCommand))
            {
                oDataAdapter.Fill(oDataSet);
                radGridView1.DataSource = oDataSet.Tables[0];
            }
        }
    }
}

Form.designer.cs：

    // 
    // radGridView1
    // 
    this.radGridView1.BackColor = System.Drawing.SystemColors.Desktop;
    this.radGridView1.CausesValidation = false;
    this.radGridView1.Cursor = System.Windows.Forms.Cursors.Default;
    this.radGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
    this.radGridView1.EnableCustomFiltering = true;
    this.radGridView1.Font = new System.Drawing.Font("Segoe UI", 8.25F);
    this.radGridView1.ForeColor = System.Drawing.SystemColors.ControlText;
    this.radGridView1.ImeMode = System.Windows.Forms.ImeMode.NoControl;
    this.radGridView1.Location = new System.Drawing.Point(0, 24);
    // 
    // radGridView1
    // 
    this.radGridView1.MasterTemplate.AllowAddNewRow = false;
    this.radGridView1.MasterTemplate.AllowDeleteRow = false;
    this.radGridView1.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;
    this.radGridView1.MasterTemplate.EnableCustomFiltering = true;
    this.radGridView1.MasterTemplate.EnableFiltering = true;
    this.radGridView1.MasterTemplate.SelectionMode = Telerik.WinControls.UI.GridViewSelectionMode.CellSelect;
    this.radGridView1.Name = "radGridView1";
    this.radGridView1.NewRowEnterKeyMode = Telerik.WinControls.UI.RadGridViewNewRowEnterKeyMode.None;
    this.radGridView1.ReadOnly = true;
    this.radGridView1.RightToLeft = System.Windows.Forms.RightToLeft.No;
    this.radGridView1.ShowGroupPanel = false;
    this.radGridView1.Size = new System.Drawing.Size(1277, 746);
    this.radGridView1.TabIndex = 2;
    this.radGridView1.Text = "radGridView1";
    this.radGridView1.EnableFiltering = true;
    this.radGridView1.RowFormatting += new Telerik.WinControls.UI.RowFormattingEventHandler(this.radGridView1_RowFormatting);
    this.radGridView1.CellFormatting += new Telerik.WinControls.UI.CellFormattingEventHandler(this.radGridView1_CellFormatting);
    this.radGridView1.CellDoubleClick += new Telerik.WinControls.UI.GridViewCellEventHandler(this.radGridView1_CellDoubleClick);
    this.radGridView1.DataBindingComplete += new Telerik.WinControls.UI.GridViewBindingCompleteEventHandler(this.radGridView1_DataBindingComplete);
    this.radGridView1.FilterExpressionChanged += new Telerik.WinControls.UI.GridViewFilterExpressionChangedEventHandler(this.radGridView1_FilterExpressionChanged);
    // 

Answer 1

如果您设置了

EnableCustomFiltering = true

和

EnableFiltering = true

过滤不起作用。

Answer 2

要使过滤起作用，请设置EnableCustomFiltering = false和EnableFiltering = true。