Home / Community & Support / Developer Productivity Tools Forums / WinForms > GridView > Conditionally format cell value based on value of another cell

• Roberto Wenzel

  Posted on Sep 1, 2008 (permalink)

  Hello,
  I want to format a cell value in a GridView for WinForms. The format style depends on the value of another column cell.
  I tried something like this:
  

  Private

  Sub gvMessages_CellFormatting(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.CellFormattingEventArgs) Handles gvMessages.CellFormatting

  For Each row In Me.gvMessages.Rows
  If row.Cells("Type").Value = "S" Then
  row.Cells("Element").CellElement.BackColor = Color.Aqua
  Else
  End If
  Next
  
  But it did not work. Could you please give me a hint or a link for a solution.
  Thnak you very much
  Roberto

  Reply

• Roberto Wenzel

  Posted on Sep 2, 2008 (permalink)

  Hi guys,

  a possible solution in VB might look like this (this solution is based on another posting in this forum):

  Private Sub gvMessages_CellFormatting(ByVal sender As Object, ByVal e As Telerik.WinControls.UI.CellFormattingEventArgs) Handles gvMessages.CellFormatting

          If TypeOf (e.CellElement.ColumnInfo) Is GridViewDataColumn AndAlso Not TypeOf (e.CellElement.RowElement) Is GridTableHeaderRowElement Then

              Dim column As GridViewDataColumn

              column = e.CellElement.ColumnInfo

              If column.FieldName = "Element" Then

                  If e.CellElement.RowInfo.Cells("Type").Value = "S" Then

                      If Not e.CellElement.RowInfo.IsCurrent AndAlso Not e.CellElement.RowInfo.IsSelected Then

                          e.CellElement.BackColor = Color.LightSalmon

                          e.CellElement.TextAlignment = ContentAlignment.TopLeft

                          e.CellElement.Font = New Font(SystemFonts.DefaultFont, FontStyle.Bold)

                          e.CellElement.DrawFill = True

                      Else

                          e.CellElement.DrawFill = False

                          e.CellElement.Font = New Font(SystemFonts.DefaultFont, FontStyle.Regular)

                      End If

                  ElseIf e.CellElement.RowInfo.Cells("Type").Value = "C" Then

                      If Not e.CellElement.RowInfo.IsCurrent AndAlso Not e.CellElement.RowInfo.IsSelected Then

                          e.CellElement.BackColor = Color.Khaki

                          e.CellElement.TextAlignment = ContentAlignment.TopLeft

                          e.CellElement.Font = New Font(SystemFonts.DefaultFont, FontStyle.Regular)

                          e.CellElement.DrawFill = True

                      Else

                      End If

                  ElseIf e.CellElement.RowInfo.Cells("Type").Value = "E" Then

                      If Not e.CellElement.RowInfo.IsCurrent AndAlso Not e.CellElement.RowInfo.IsSelected Then

                          e.CellElement.BackColor = Color.LemonChiffon

                          e.CellElement.TextAlignment = ContentAlignment.TopRight

                          e.CellElement.Font = New Font(SystemFonts.DefaultFont, FontStyle.Regular)

                          e.CellElement.DrawFill = True

                      Else

                      End If

                  End If

              End If

          End If

      End Sub

  Reply

• Jack Jack

  Posted on Sep 2, 2008 (permalink)

  Hi Roberto,
  
  Thank you for contacting us.
  
  You don't need to iterate through all rows. The current row can be obtained through the RowInfo property of the CellElement. You should also reset all properties when your condition is not true. Consider the code snippet below:
  
  

  Private Sub radGridView1_CellFormatting(ByVal sender As Object, ByVal e As CellFormattingEventArgs)

  Dim column As GridViewDataColumn = TryCast(e.CellElement.ColumnInfo, GridViewDataColumn)

  If column IsNot Nothing AndAlso column.FieldName = "Element" Then

  If e.CellElement.RowInfo.Cells("Type").Value.ToString() = "S" Then

  e.CellElement.BackColor = Color.Aqua

  e.CellElement.DrawFill = True

  Else

  e.CellElement.DrawFill = False

  End If

  End If

  End Sub

  
  I hope this helps. Please let me know if you need further assistance.
  
  Kind regards,
  Jack
  the Telerik team

  
  Check out Telerik Trainer, the state of the art learning tool for Telerik products.

  Reply

• Roberto Wenzel

  Posted on Sep 2, 2008 (permalink)

  Yes, this approach is better. It works fine. Thank you very much.
  Roberto

  Reply

• george mcnitt

  Posted on Jun 23, 2010 (permalink)

  Has any of this changed in Q1 2010 SP2?
  
  I am trying to use this exact example and it keeps throwing a nullfeferenceexception on this line of code.
  
  

   

   

  If e.CellElement.RowInfo.Cells("played").Value.ToString = "1" Then

   

  
  
  the played column is last column in my column collection.

  Reply

• Svett Svett

  Posted on Jun 24, 2010 (permalink)

  Hello george mcnitt,
  
  The exception is caused by the NULL value of GridViewCellInfo's Value property. You should check it for NULL or DBNull values before its string conversion. You can use the following code snippet as sample:
  

  Dim value As Object = e.CellElement.RowInfo.Cells("played").Value

   

  If (Not Convert.IsDBNull(value)) AndAlso value IsNot Nothing AndAlso value.ToString() = "1" Then

      ' TO DO

  End If

  
  I hope this helps.
  
  Greetings,
  Svett
  the Telerik team

  Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply

• george mcnitt

  Posted on Jun 24, 2010 (permalink)

   

  That seems to have fixed the problem. Thanks.

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / WinForms > GridView > Conditionally format cell value based on value of another cell