CustomFiltering and default FilterRow together

Hi Dimitar

I have a question about the customFiltering.

I have a bound Gridview and the MasterTemplate has two child template. I created GridViewRelation, everything works perfectly.

Now I would like to use a CustomFiltering. I initialized these properties of my GridView :

    SchoolStudentDGV.EnableHotTracking = true;
    SchoolStudentDGV.ShowFilteringRow = false;
    SchoolStudentDGV.EnableFiltering= true;
    SchoolStudentDGV.EnableCustomFiltering = true;

I handled the "CustomFiltering" event and the "TextChanged" of the filter TextBox.

In the TextChanged method, I have this code : this.SchoolStudentDGV.MasterTemplate.Refresh();

In the CustomFiltering method, I have this :

            if (string.IsNullOrEmpty(this.filterTextBox.Text))
            {
                this.SchoolStudentDGV.BeginUpdate();
                e.Visible = true;
                e.Row.IsVisible = true;

                for (int i = 0; i < e.Row.ViewTemplate.ColumnCount; i++)
                {
                    e.Row.Cells[i].Style.Reset();
                }

                this.SchoolStudentDGV.EndUpdate(false);
                return;
            }

            this.SchoolStudentDGV.BeginUpdate();
            e.Visible = false;
            e.Row.IsVisible = false;

            for (int i = 0; i < e.Row.ViewTemplate.ColumnCount; i++)
            {
                string text = e.Row.Cells[i].Value?.ToString() ?? "";

                if (e.Row.Cells[i].ColumnInfo.IsVisible &&
                    text.IndexOf(this.filterTextBox.Text, 0, StringComparison.InvariantCultureIgnoreCase) >= 0)
                {
                    e.Visible = true;
                    e.Row.IsVisible = true;
                    e.Row.Cells[i].Style.CustomizeFill = true;
                    e.Row.Cells[i].Style.DrawFill = true;
                    e.Row.Cells[i].Style.BackColor = Color.FromArgb(201, 252, 254);
                }
                else
                {
                    e.Row.Cells[i].Style.Reset();
                }
            }

            this.SchoolStudentDGV.EndUpdate(false);

It works, rows of the MasterTemplate are filtered but I would like to apply the same filter to children template. Can you tell me if is it possible ?

Thank you

Hi,

I did that however if the parent row doesn't match to the filter, is not visible and all children rows of this parent row are hidden and the filter is not applied to those children row.

Thanks

Good morning Dimitar

I will test.

I have another question about a radgridview bound. I have two GridViewComboBoxColumn and I can add new row. I handle the "CellEditorInitialized" event.

private void CoteDGV_CellEditorInitialized(object sender, GridViewCellEventArgs e)

{
            RadDropDownListEditor editor = e.ActiveEditor as RadDropDownListEditor;
            RadDropDownListEditorElement editorElement = editor?.EditorElement as RadDropDownListEditorElement;
            if (editorElement == null)
                return;

            GridViewComboBoxColumn cbc = e.Column as GridViewComboBoxColumn;

            switch (e.Column.Name)
            {
                case "PeriodeColumn":
                    editorElement.ListElement.SelectedIndexChanged -= CoteDGVDropdownEditor_SelectedIndexChanged;
                    editorElement.DataSource = _allControlsToAddCote
                        .Select(x => x.Period)
                        .Distinct()
                        .OrderBy(x => x);
                    editorElement.ListElement.SelectedIndexChanged += CoteDGVDropdownEditor_SelectedIndexChanged;
                    break;

                case "DisciplineColumn":
                    (e.Column as GridViewComboBoxColumn).DataSource = _disciplinesFound;
                    editorElement.ListElement.SelectedIndexChanged -= CoteDGVDropdownEditor_SelectedIndexChanged;
                    editorElement.Filter = FilterWrapperDiscipline;
                    editorElement.ListElement.SelectedIndexChanged += CoteDGVDropdownEditor_SelectedIndexChanged;
                    break;

          }

}

When I choose in the first ComboBoxColumn, I want to intialize my second ComboBoxColumn, so I handle the "SelectedIndexChanged" event for each column.

However I have a problem with this event. If I click on the New Row to start a new row, my first column is initialized, if I select an item in the first ComboBoxColumn, the "SelectedIndexChanged" event is fired, perfect. Next I click on the second ComboBoxColumn to enter in edition. The "OnMouseDown" event fires "SelectedIndexChanged" event several times for the first column with the selected value, next null value, next the selected value ...

I try to replace the "SelectedIndexChanged" event by 'SelectedValueChanged" or "SelectedItemsChanged" bu I have the same problem. So I do not know how to distinguish when the "SelectedIndexChanged" event is invoked with the null value when it is the user who selected the empty item  or if it is the "OnMouseDown".

Thank you

Hello Dimitar

Can you tell me if is it possible to re-evaluate a summary item of a gridview ?

I have 3 bound gridviews. 

When I insert a new row in the first gridview, when update is commited, I must update also the datasource of the two others gridview. The second and the thirth gridview are updated but summary rows are not re-evaluate.

So can you tell me how I can re-evaluate them ?

Thank you

Best regards

Hello,

It does not work.

It's the datasource of a child view of my gridview that I want to update.

Thank you

Hi,

In a bound RadGridView control, I enabled filtering.

Can you tell me if is it possible to add a new item in the list of filter operators ?

My goal is to have a new custom filter that allows to display rows by comparing the value of 2 columns 

Thank you

Hello

Thanks I saw this post and I implemented it. However, I didn't find how to do what I wanted ...

I added item in the filter context menu but I would like to filter my gridview comparing value of 2 columns

Thank you