RowFormatting Event Unreliable?

[Greg]

We are using a RadGridView to display data in a small area, only two rows are visible at any given time with the third row partially visible.  Using the RowFormatting event handler, we set the forecolor to reflect rows that contain 'inactive' or 'invalid' records based on columns in the underlying data.  Generally this works fine.  But when there are more than three rows in the grid and some of those rows are not visible, the forecolor change is not reliable.  For example, if the first three rows are 'valid' and the fourth row is 'invalid', all appears correct when the grid is initially displayed and the user scrolls down to the fourth row.  The 'invalid' row has the forecolor changed to gray.  But when the fourth is selected and the user then scrolls back to the first row, the first row now shows as 'invalid' (forecolor = gray) even though the data has not changed and the other rows still display the same as before.  From that point on the first row displays incorrectly until the data is refreshed.  Sometimes this occurs even if the last row is not selected, just scrolling from top to bottom and back.

        private void grdEFT_RowFormatting(object sender, RowFormattingEventArgs e)
        {
                if (e != null &&
                    e.RowElement.RowInfo != null &&
                    e.RowElement.RowInfo.DataBoundItem is DataRowView)
                {
                    DataRow drEFT = ((DataRowView)e.RowElement.RowInfo.DataBoundItem).Row;
                    DataRow drAPM = drEFT.GetParentRow(this.rAutopayDS.Relations["AssociatePaymentMethodEFTPaymentMethodInfo"]);

                    if (drAPM != null)
                    {
                        // Show the row as inactive if it is not active.
                        if (!(bool)drAPM["Active"] ||
                            !(bool)drEFT["Valid"])
                        {
                            e.RowElement.ForeColor = System.Drawing.SystemColors.ControlDark;
                        }
                        else
                        {
                            e.RowElement.ResetValue(LightVisualElement.FontProperty, ValueResetFlags.Local);
                        }
                    }
                    else
                    {
                        e.RowElement.ResetValue(LightVisualElement.FontProperty, ValueResetFlags.Local);
                    }
                }
        }

Thanks,
Greg Swope

[Greg]

Never mind.  After much trial and error, we found the cause.  Resetting the font property would have no effect since it had not changed.  Altered the code to reset the forecolor property instead and now all is well.

 e.RowElement.ResetValue(LightVisualElement.FontProperty, ValueResetFlags.Local);

changed to

 e.RowElement.ResetValue(LightVisualElement.ForeColor, ValueResetFlags.Local);

[Greg]

Sorry, that last line should have been;

e.RowElement.ResetValue(LightVisualElement.ForeColorProperty, ValueResetFlags.Local);

[Dess | Tech Support Engineer, Principal]

Hello Greg,

Thank you for writing.

I am glad that the issue you were facing is now resolved. In addition, I suppose that our Formatting Rows help article would be quite useful about this topic.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik