Color DataGridView Cells Based On Data

H o m e

F R E E

Color DataGridView Cells Based On Data

10/19/2006 ColorDataGridViewCellsBasedOnData.zip

This article, and the source code it provides, demonstrate how to handle the Windows Forms DataGridView CellFormatting event to set the BackColor of a cell based on the cell's value.

The example application in the source code provides users a way to mark inactive customers and/or customers who have not placed an order in the last 30 days.

The CellFormatting event occurs when the contents of a cell in a Windows Forms DataGridView control needs to be formatted for display.

To set the BackColor of a cells based on their values, create a CellFormatting event handler. Within the handler add code to set the BackColor of individual cells based on their value.

Code Example

				    1 Private
				Sub 
				customerDataGridView_CellFormatting(ByVal 
				sender As
				Object,
				ByVal e
				As 
				DataGridViewCellFormattingEventArgs) 
				Handles customerDataGridView.CellFormatting

				    2 

				    3    
				' If the column being formatted is 
				the column named 'Status' ..

				    4    
				If 
				Me.customerDataGridView.Columns(e.ColumnIndex).Name =
				"Status"
				Then

				    5        
				If e.Value
				IsNot
				Nothing
				Then

				    6            
				' If the value of the cell is 
				"Inactive" AND this form's inactiveCustomersCheckBox control is 
				checked..

				    7            
				If e.Value.ToString =
				"Inactive"
				And 
				Me.inactiveCustomersCheckBox.Checked
				Then

				    8                
				' Set the BackColor of the cell to 
				yellow.

				    9                 
				e.CellStyle.BackColor = Color.Yellow

				   10            
				End 
				If

				   11        
				End 
				If

				   12    
				End 
				If

				   13 

				   14    
				' If the column being formatted is 
				the column named 'LastOrderDate'..

				   15    
				If 
				Me.customerDataGridView.Columns(e.ColumnIndex).Name =
				"LastOrderDate"
				Then

				   16        
				If e.Value
				IsNot
				Nothing
				Then

				   17            
				' If LastOrderDate was more than 30 
				days ago AND this form's ordersOverdueCheckBox control is 
				checked..

				   18            
				If 
				Date.Now.Subtract(CType(e.Value,
				Date)).Days > 30
				And 
				Me.orderOverdueCheckBox.Checked
				Then

				   19                
				' Set the BackColor of the cell to 
				yellow-green.

				   20                 
				e.CellStyle.BackColor = Color.YellowGreen

				   21            
				End 
				If

				   22        
				End 
				If

				   23    
				End 
				If

				   24 End
				Sub

The CellFormatting event occurs every time each cell is painted, so you should avoid lengthy processing when handling this event.

For more information visit the link below:

DataGridView.CellFormatting Event

Click the link above to download Visual Basic source code in a Visual Studio 2005 solution which demonstrates how to handle the Windows Forms DataGridView CellFormatting event to set the BackColor of a cell based on the cell's value.

Get Dot Net Code is a web site full of free and pay for use Visual Basic source code for Visual Basic programmers.