根据条件更改datagridview单元格颜色 [英] Changing datagridview cell color based on condition

问题描述

我已将数据从数据库加载到datagridview，并具有两列目标值和卷，其中volume>目标值该单元格应为绿色和卷<目标值，则音量应为红色。我试过了，但我不能这样做。

  private void dataGridView1_DataBindingComplete（object sender，DataGridViewBindingCompleteEventArgs e）
 {
 if（dataGridView1.Rows.Count> 0&&  dataGridView1.Columns.Count> 0）
 {
 foreach（DataGridViewRow r in dataGridView1.Rows）
 {
 if（Volume> target value）
 {
 cell.Style.BackColor = Color.AliceBlue; 
} 
  

解决方案

你需要这样做

  private void dataGridView1_CellFormatting（object sender，DataGridViewCellFormattingEventArgs e）
 {
 foreach（DataGridViewRow Myrow in dataGridView1.Rows ）
 {//这里2单元格是目标值，1个单元格是Volume 
 if（Convert.ToInt32（Myrow .Cells [2] .Value）&Convert.ToInt32（Myrow .Cells [1] .Value））//或者你的条件
 {
 Myrow .DefaultCellStyle.BackColor = Color.Red; 
} 
 else 
 {
 Myrow .DefaultCellStyle.BackColor = Color.Green; 
} 
} 
} 
  

同时还要看看单元格格式

I have loaded the data from database to datagridview and have two columns target value and volume where volume >target value that volume cell should be in green color and volume < target value then volume should be in red color. I tried it but I am not able to do it.

private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
    if (dataGridView1.Rows.Count > 0 && dataGridView1.Columns.Count > 0)
    {
        foreach (DataGridViewRow r in dataGridView1.Rows)
        {
            if (Volume > target value)
            {
                cell.Style.BackColor = Color.AliceBlue;
            } 

解决方案

You need to do this

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    foreach (DataGridViewRow Myrow in dataGridView1.Rows) 
    {            //Here 2 cell is target value and 1 cell is Volume
        if (Convert.ToInt32(Myrow .Cells[2].Value)<Convert.ToInt32(Myrow .Cells[1].Value))// Or your condition 
        {
            Myrow .DefaultCellStyle.BackColor = Color.Red; 
        }
        else
        {
            Myrow .DefaultCellStyle.BackColor = Color.Green; 
        }
    }
}

Meanwhile also take a look at Cell Formatting

这篇关于根据条件更改datagridview单元格颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！