Change the color line according to the contents of the cell in the datagridview

Question

Change the color line according to the contents of the cell in the datagridview

Navigation

#1 by (3 votes)

1

I have a Windows Form that loads a DataGridView , it has a column that contains both positive and negative values, so when the value of this column is negative, the line has a different color.

How can I do this?

follows the Code:

private void ListaGrid()
{
    string strSQL = @"SELECT  
            SA.A1_COD                     AS CODIGO,
            SA.A1_NOME                    AS CLIENTE,
            SA.A1_LC                      AS [LIMITE CREDITO],
            SUM(SE.E1_VALOR)              AS [TOTAL COMPRA],
            SUM(SE.E1_SALDO)              AS [SALDO ABERTO],
            SA.A1_LC - SUM(SE.E1_SALDO)   AS [SALDO LIMITE]
        FROM SA1010 AS SA
        INNER JOIN SE1010 AS SE WITH (NOLOCK) ON SA.A1_COD = SE.E1_CLIENTE
        WHERE SA.D_E_L_E_T_ <> '*' AND SE.D_E_L_E_T_ <> '*'
        GROUP BY SA.A1_COD, SA.A1_NOME, SA.A1_LC
        ORDER BY CODIGO";

    comando = new SqlCommand(strSQL, conm);

    try
    {
        SqlDataAdapter dados = new SqlDataAdapter(comando);
        DataTable dtLista = new DataTable();
        dados.Fill(dtLista);

        DGW_LimiteCredito.DataSource = dtLista;
    }
    catch
    {
        MessageBox.Show("Não existem dados a serem encontrados");
    }
}

c#

asked by anonymous 15.09.2017 / 21:32

1 answer

What calculation to convert a 'CodePoint' to UTF-16? Help with sum

score 3 · Accepted Answer

You will iterate through all the lines of your DataGridView and compare the value of the column that contains the value you want to check. If the value is negative, the row (row) will be painted the color you choose, in the example it is red.

foreach (DataGridViewRow row in DGW_LimiteCredito.Rows)
{
     if (Convert.ToInt32(row.Cells[/*Index ou nome da coluna com o valor*/].Value) < 0 ) 
     {
         // Se for negativo, fica vermelho
         row.DefaultCellStyle.BackColor = Color.Red; 
     }
}