C#开发WinForm根据条件改变DataGridView行颜色

根据条件改变DataGridView行的颜色可以使用RowPrePaint事件。

示例程序界面如下:

示例程序代码如下:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlClient;

namespace DgvChangeColor
{
  public partial class Form1 : Form
  {
      public Form1()
      {
          InitializeComponent();
      }

      string strCon = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
      private void Form1_Load(object sender, EventArgs e)
      {
          DataTable dt = GetDataSource();
          this.DgvColor.DataSource = dt;
      }

      private void DgvColor_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
      {
          if (e.RowIndex >= DgvColor.Rows.Count - 1)
          {
              return;
          }
          DataGridViewRow dr = (sender as DataGridView).Rows[e.RowIndex];

          if (dr.Cells["项目代码"].Value.ToString().Trim().Equals("ACAC0001"))
          {
              // 设置单元格的背景色
              dr.DefaultCellStyle.BackColor = Color.Yellow;
              // 设置单元格的前景色
              dr.DefaultCellStyle.ForeColor = Color.Black;
          }
          else
          {
              dr.DefaultCellStyle.BackColor = Color.Blue;
              dr.DefaultCellStyle.ForeColor = Color.White;
          }
      }

      private DataTable GetDataSource()
      {
          DataTable dt = new DataTable();
          SqlConnection conn = new SqlConnection(strCon);
          string strSQL = "SELECT XIANGMUCDDM AS '项目代码',XIANGMUMC AS '项目名称', DANJIA AS '单价',SHULIANG AS '数量' FROM InPatientBillDt WHERE 就诊ID='225600'";
          SqlCommand cmd = new SqlCommand(strSQL, conn);
          SqlDataAdapter adapter = new SqlDataAdapter();
          adapter.SelectCommand = cmd;
          try
          {
              conn.Open();
              adapter.Fill(dt);
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          finally
          {
              conn.Close();
          }
          return dt;
      }
  }
}

示例程序下载地址:点此下载

关于C#开发WinForm根据条件改变DataGridView行颜色的文章就介绍到这了。希望对大家的学习有所帮助,也希望大家多多支持编程教程

使用DataGridView控件绑定数据后有时需要清空绑定的数据,在清除DataGridView绑定的数据时:1、设置DataSource为nullthis.dgvDemo. ...