C# 单元格变色

源码（获取列名，for循环遍历单元格，匹配信息改变颜色）

        int rowCount;   //总行数
​
        //获取数据
        private void GetData()
        {
            try
            {
                if (MyHelper.IsConn())
                {
                    //1-定义一个webservice连接
                    DynWebService BHWS = new DynWebService();
                    //2-执行SQL
                    string sql_select = "RP_Production '" + comboboxnamenew + "'";
                    dt = BHWS.MExecSQL(MyHelper.strVerify, MyHelper.strIP, "", MyHelper.strProjName + "-" + this.AccessibleName, MyHelper.strUser, sql_select);
                    //获取总行数（需赋值datasource前获取行数）
                    rowCount = dt.Rows.Count;
                    // 设置到DataGridView中
                    gridControl1.DataSource = dt;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("错误信息：" + ex.Message, "出现错误");
            }
        }
​
        //单元格变色
        private void gridView1_RowCellStyle(object sender, RowCellStyleEventArgs e)
        {
            try
            {
                if (gridView1.Columns.Contains(gridView1.Columns["背景颜色"]))
                {
                    if (Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["背景颜色"])) != "")
                    {
                        string[] strColor = Convert.ToString(gridView1.GetRowCellValue(e.RowHandle, gridView1.Columns["背景颜色"])).Split(',');
                        int nA = Convert.ToInt16(strColor[0]);
                        int nB = Convert.ToInt16(strColor[1]);
                        int nC = Convert.ToInt16(strColor[2]);
                        //rowCount=dt.Rows.Count总行数
                        for (int r = 0; r < rowCount; r++)
                        {
                            //c=column值
                            for (int c = 3; c < 10; c++)
                            {
                                if (dt.Rows[r][c].ToString() != "")
                                {
                                    //获取该列标题
                                    string name = dt.Columns[c].ColumnName;
                                    if (e.RowHandle == r && e.Column.FieldName == name)
                                    {
                                        e.Appearance.BackColor = Color.FromArgb(nA, nB, nC);
                                    }
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("错误信息:" + ex.Message, "出现错误");
            }
        }