Override pinned columns color with the RowFormatting event

[Cernat]

Hello!

Why does RowFormating event does not override the color for the pinned columns?

It only formats the unpinned columns of the GridView. The RowFormatting code bellow.

Can someone point me in the right direction?

Thank you very much!

Private Sub RadGridView1_RowFormatting(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.RowFormattingEventArgs) Handles RadGridView1.RowFormatting

        If e.RowElement.RowInfo.Cells("Status").Value = "Finalizata" Then
            e.RowElement.DrawFill = True
            e.RowElement.GradientStyle = Telerik.WinControls.GradientStyles.Solid
            e.RowElement.BackColor = Color.DimGray
        Else
            e.RowElement.ResetValue(LightVisualElement.BackColorProperty, Telerik.WinControls.ValueResetFlags.Local)
            e.RowElement.ResetValue(LightVisualElement.GradientStyleProperty, Telerik.WinControls.ValueResetFlags.Local)
            e.RowElement.ResetValue(LightVisualElement.DrawFillProperty, Telerik.WinControls.ValueResetFlags.Local)
        End If
    End Sub

 

[Dess | Tech Support Engineer, Principal]

Hello Cernat,

Thank you for writing.  

Depending on the specific theme, RadGridView's style may be applied the row or cell level. For the pinned rows in ControlDefault theme, it is applied at the cell level. That is why in order to achieve the desired style, it is suitable to use the CellFormatting event:  

Private Sub RadGridView1_CellFormatting(sender As Object, e As CellFormattingEventArgs) Handles RadGridView1.CellFormatting
    If (e.CellElement.RowInfo.Cells("Name").Value & "").Contains("1") Then
        e.CellElement.DrawFill = True
        e.CellElement.GradientStyle = Telerik.WinControls.GradientStyles.Solid
        e.CellElement.BackColor = Color.DimGray
    Else
        e.CellElement.ResetValue(LightVisualElement.BackColorProperty, Telerik.WinControls.ValueResetFlags.Local)
        e.CellElement.ResetValue(LightVisualElement.GradientStyleProperty, Telerik.WinControls.ValueResetFlags.Local)
        e.CellElement.ResetValue(LightVisualElement.DrawFillProperty, Telerik.WinControls.ValueResetFlags.Local)
    End If
End Sub

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

Regards,
Dess
Telerik by Progress

[Cernat]

Hello! Thanks for answering. The CellFormatting event fires for another rules that I setup. Below the code from the event. How can I squeeze the painting of the row in gray if cell value of Status column = "Finalizata"? Cant figure it out.

 

Private Sub RadGridView1_CellFormatting2(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.CellFormattingEventArgs) Handles RadGridView1.CellFormatting
       If e.CellElement.ColumnInfo.HeaderText = "Intarziere" Then
           If e.CellElement.RowInfo.Cells("Diferenta").Value + 5 > 0 Then
               e.CellElement.DrawFill = True
               e.CellElement.ForeColor = Color.White
               e.CellElement.NumberOfColors = 1
               e.CellElement.BackColor = Color.Red
           Else
               e.CellElement.DrawFill = True
               e.CellElement.ForeColor = Color.Black
               e.CellElement.NumberOfColors = 1
               e.CellElement.BackColor = Color.LightGreen
           End If
       Else
           e.CellElement.ResetValue(LightVisualElement.DrawFillProperty, ValueResetFlags.Local)
           e.CellElement.ResetValue(LightVisualElement.ForeColorProperty, ValueResetFlags.Local)
           e.CellElement.ResetValue(LightVisualElement.NumberOfColorsProperty, ValueResetFlags.Local)
           e.CellElement.ResetValue(LightVisualElement.BackColorProperty, ValueResetFlags.Local)
       End If
   End Sub

[Dess | Tech Support Engineer, Principal]

Hello Cernat, 

Thank you for writing back. 

It is necessary to combine the different formatting rules in different "if" statements. However, don't forget to reset the applied settings in the default "else" clause in order to avoid applying incorrect styles to the other cells. In other words, each "if" statement that applies a certain style should have an "else" clause for resetting the options or applying some other style. Here is a sample code snippet which result is illustrated in the attached screenshot:

Note that this is just a sample approach and it may not cover all possible cases.

I hope this information helps. If you have any additional questions, please let me know. 

Regards,
Dess
Telerik by Progress

[Ras Ran]

how to change the given Pinned Row Back Color ?
dgvReturn.Rows[0].IsPinned = true;
dgvReturn.Rows[0].PinPosition = PinnedRowPosition.Bottom;

[Nadya | Tech Support Engineer]

Hello,

You can change the BackColor of the pinned rows by handling the CellFormatting event:

this.radGridView1.Rows[3].IsPinned = true;

private void RadGridView1_CellFormatting(object sender, CellFormattingEventArgs e)
{
    if (e.RowIndex == 3)
    {
        e.CellElement.BackColor = Color.Red;
        e.CellElement.GradientStyle = GradientStyles.Solid;
    }
    else
    {
        e.CellElement.ResetValue(LightVisualElement.BackColorProperty);
        e.CellElement.ResetValue(LightVisualElement.GradientStyleProperty);
    }
}

I hope this helps. Do not hesitate to contact us if you have other questions.

Regards,
Nadya
Progress Telerik

[Ras Ran]

 
thank you so much Nadya...its worked perfectly