C# 迭代 DataGridView 并更改行颜色

C# Iterate Over DataGridView & Change Row Color

提问by Goober

I have a datagridview made up of multiple rows and columns. I want to iterate through each row and check the contents of a specific column. If that column contains the word "NO", I want to change the forecolor of the entire row to Red. Here is an attempt at some code so far but It's certainly not working, starting to wonder If I need to iterate over every cell?

我有一个由多行和多列组成的数据网格视图。我想遍历每一行并检查特定列的内容。如果该列包含单词“NO”，我想将整行的前景色更改为红色。到目前为止，这是对一些代码的尝试，但它肯定不起作用，开始怀疑是否需要迭代每个单元格？

CODE:

代码：

foreach (DataGridViewRow dgvr in dataGridView1.Rows)
        {
            if (dgvr.Cells["FollowedUp"].Value.ToString() == ("No"))
            {
                dgvr.DefaultCellStyle.ForeColor = Color.Red;
            }
        }

采纳答案by Goober

public void ColourChange()
    {
        DataGridViewCellStyle RedCellStyle = null;
        RedCellStyle = new DataGridViewCellStyle();
        RedCellStyle.ForeColor = Color.Red;
        DataGridViewCellStyle GreenCellStyle = null;
        GreenCellStyle = new DataGridViewCellStyle();
        GreenCellStyle.ForeColor = Color.Green;


        foreach (DataGridViewRow dgvr in dataGridView1.Rows)
        {
            if (dgvr.Cells["FollowedUp"].Value.ToString().Contains("No"))
            {
                dgvr.DefaultCellStyle = RedCellStyle;
            }
            if (dgvr.Cells["FollowedUp"].Value.ToString().Contains("Yes"))
            {
                dgvr.DefaultCellStyle = GreenCellStyle;
            }
        }
    }

回答by TheVillageIdiot

hook up OnRowDataBoundevent then do stuff

连接OnRowDataBound事件然后做一些事情

ASPX (Grid):

ASPX（网格）：

    <asp:.... OnRowDataBound="RowDataBound"..../>

Code Behind:

背后的代码：

    protected void RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowIndex == -1)
        {
            return;
        }

        if(e.Row.Cells[YOUR_COLUMN_INDEX].Text=="NO"){
             e.Row.BackColor=Color.Red;   
        }
    }

FOR WinForms:

对于 WinForms：

hook the **DataBindingComplete** event and do stuff in it:

     private void dataGridView1_DataBindingComplete(object sender, 
                       DataGridViewBindingCompleteEventArgs e)
    {
        if (e.ListChangedType != ListChangedType.ItemDeleted)
        {
            DataGridViewCellStyle red = dataGridView1.DefaultCellStyle.Clone();
            red.BackColor=Color.Red;

            foreach (DataGridViewRow r in dataGridView1.Rows)
            {
                if (r.Cells["FollowedUp"].Value.ToString()
                       .ToUpper().Contains("NO"))
                {
                    r.DefaultCellStyle = red;
                }
            }
        }
    }

回答by William Edmondson

Is it possible there are spaces or some other character as part of the cell value? If so try using the Contains method rather than straight equality.

单元格值中是否可能有空格或其他字符？如果是这样，请尝试使用 Contains 方法而不是直接相等。

if (dgvr.Cells["FollowedUp"].Value.ToString().Contains("No"))

回答by SO User

This is the solution for Winforms:

这是 Winforms 的解决方案：

private void HighlightRows()
{
    DataGridViewCellStyle GreenStyle = null;

    if (this.dgridv.DataSource != null)
    {
        RedCellStyle = new DataGridViewCellStyle();
        RedCellStyle.BackColor = Color.Red;

        for (Int32 i = 0; i < this.dgridv.Rows.Count; i++)
        {
            if (((DataTable)this.dgridv.DataSource).Rows[i]["col_name"].ToString().ToUpper() == "NO")
            {
                this.dgridv.Rows[i].DefaultCellStyle = RedCellStyle;
                continue;
            }
        }
    }
}

回答by SO User

This code works fine for me:

这段代码对我来说很好用：

foreach (DataGridViewRow row in dataGridView1.Rows)
{
    if ((string)row.Cells["property_name"].Value == UNKNOWN_PROPERTY_NAME)
    {
        row.DefaultCellStyle.BackColor = Color.LightSalmon;
        row.DefaultCellStyle.SelectionBackColor = Color.Salmon;
    }
}

Other than casting as a string rather than calling ToString I dont really see any difference so it could be a case sensitivity bug. Try using:

除了作为字符串转换而不是调用 ToString 之外，我真的没有看到任何区别，所以它可能是一个区分大小写的错误。尝试使用：

dgvr.Cells["FollowedUp"].Value.ToString().ToUpper() == "NO"

回答by Rostov

On your DataGridView, handle the CellFormatting event:

在您的 DataGridView 上，处理 CellFormatting 事件：

dataGridView1.CellFormatting += new DataGridViewCellFormattingEventHandler(dataGridView1_CellFormatting);

Your event handler could then look like this:

您的事件处理程序可能如下所示：

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{       
    if(dataGridView1.Columns[e.ColumnIndex].Name == "FollowedUp" && e.Value != null && e.Value.ToString() == "No")
        dataGridView1.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Red;  
}

In this way you aren't 'iterating' over the rows -- simply changing the color with which they are painted/drawn when they become visible (and thus require formatting) in the grid.

通过这种方式，您不会在行上“迭代” - 只需更改它们在网格中可见（因此需要格式化）时绘制/绘制的颜色。

回答by Mustafa Salman

private void Grd_Cust_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    colorCode == 4 ? Color.Yellow : Color.Brown;
    if (e.RowIndex < 0 || Grd_Cust.Rows[e.RowIndex].Cells["FollowedUp"].Value == DBNull.Value)
        return;
    string colorCode = Grd_Cust.Rows[e.RowIndex].Cells["FollowedUp"].Value.ToString();
    e.CellStyle.BackColor = colorCode == "NO" ? Color.Red : Grd_Cust.DefaultCellStyle.BackColor;
}