{"id":226193,"date":"2024-06-24T23:57:51","date_gmt":"2024-06-24T23:57:51","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=226193"},"modified":"2024-06-24T23:57:51","modified_gmt":"2024-06-24T23:57:51","slug":"how-to-color-row-from-column-value-in-datagridview-c","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-color-row-from-column-value-in-datagridview-c\/","title":{"rendered":"How to color row from column value in DataGridView C#?"},"content":{"rendered":"

**How to color row from column value in DataGridView C#?**<\/p>\n

The DataGridView control is a powerful tool in C# for displaying data in a tabular format. One common requirement is to highlight specific rows based on a certain column value. This can be achieved by leveraging the CellFormatting event and customizing the row’s appearance. In this article, we will explore the steps to accomplish this task.<\/p>\n

To begin with, let’s assume we have a DataGridView populated with some data, where one of the columns contains values that determine how the row should be colored. For the sake of this example, let’s consider a DataGridView with three columns: “Name,” “Age,” and “Salary.” We want to color rows that have a salary greater than a certain threshold, let’s say $5000.<\/p>\n

To implement this functionality, follow the steps below:<\/p>\n

1. **Handle the CellFormatting event:** The CellFormatting event is triggered whenever the DataGridView control requires a cell to be formatted. We can leverage this event to customize the row color based on the column value.<\/p>\n

“`csharp
\nprivate void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
\n{
\n if (e.RowIndex >= 0 && e.ColumnIndex == 2) \/\/ Assuming salary column index is 2
\n {
\n int salary = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[“Salary”].Value);<\/p>\n

if (salary > 5000)
\n {
\n e.CellStyle.BackColor = Color.LightGreen;
\n }
\n }
\n}
\n“`<\/p>\n

2. **Assign the event handler:** Assign the above CellFormatting event handler to the DataGridView’s CellFormatting event. This can be done in the form’s constructor or through the designer.<\/p>\n

“`csharp
\npublic Form1()
\n{
\n InitializeComponent();
\n dataGridView1.CellFormatting += dataGridView1_CellFormatting;
\n}
\n“`<\/p>\n

That’s it! Now, any row with a salary greater than $5000 will be highlighted with a light green background.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n