组件Datagreadview

public logsuccess()
{
        InitializeComponent();
        load_warehouse();
}

1. 添加数据

1. 向Datagreadview中添加数据

private void load_warehouse()
{
        var ds = warehouse_a.Page(1, 15, "SELECT * FROM warehouse_a").Items;
        uiDataGridView1.DataSource = ds;
}

3.添加翻页按钮的Datagreadview

private void load_warehouse()
{
        var count = warehouse_a.Query("SELECT * FROM warehouse_a").Count();
        var ds = plc_config.Page(uiPagination1.ActivePage, uiPagination1.PageSize, "SELECT * FROM warehouse_a").Items;
        uiPagination1.TotalCount = count;
        uiDataGridView1.DataSource = ds;
}

4.备注

List<warehouse_a> ds=表名.Page(从第几行开始显示,一夜显示几条数据,“SQL查询语句”).Items;

2. 颜色设置

1.双击事件RowPrePaint

private void uiDataGridView1_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
        {
            for (int i = 0; i < uiDataGridView1.Rows.Count; i++)
            {
                for (int j = 0; j < 5; j++)
                {
                    if (uiDataGridView1.Rows[i].Cells[j].Value.ToString() == "Y")
                    {
                        uiDataGridView1.Rows[i].Cells[j].Style.BackColor = Color.Red;
                    }
                    else if (uiDataGridView1.Rows[i].Cells[j].Value.ToString() == "N")
                    {
                        uiDataGridView1.Rows[i].Cells[j].Style.BackColor = Color.Green;
                    }
                    else if (uiDataGridView1.Rows[i].Cells[j].Value.ToString() == "C")
                    {
                        uiDataGridView1.Rows[i].Cells[j].Style.BackColor = Color.Yellow;
                    }
                    else
                    {
                        uiDataGridView1.Rows[i].Cells[j].Style.BackColor = Color.White;
                    }
                }
            }
        }

2.备注

在i行j列的单元格添加背景uiDataGridView1.Rows[i].Cells[j].Style.BackColor = Color.White;

RowPrePaint（单元格绘制之前执行）

RowPrePaint（单元格绘制之后执行）