Color GridControl Cell If Other Based On Other Column’s Value Color Gridcontrol

  • November 5, 2023
  • -
private void dtInventory_RowCellStyle(object sender, RowCellStyleEventArgs e) {
  GridView view = sender as GridView;

  if (e.Column.FieldName == "QtyRemaining" && e.CellValue.ToString() == "0") {
    e.Appearance.BackColor = Color.WhiteSmoke;
    e.Appearance.ForeColor = Color.LightSlateGray;

    if (e.Column.FieldName == "GenericName") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
    }

  } else if (e.Column.FieldName == "QtyRemaining" && Convert.ToInt32(e.CellValue) > 0) {
    e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Bold);
  } else if (e.Column.FieldName == "QtyRemaining" && Convert.ToInt32(e.CellValue) < 0) {
    e.Appearance.BackColor = Color.WhiteSmoke;
    e.Appearance.ForeColor = Color.LightSlateGray;
  }

  if (view.GetRowCellValue(e.RowHandle, "QtyRemaining").ToString() == "0") {

    if (e.Column.FieldName == "BatchNo") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "Brandname") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "ExpiryDate") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "UnitType") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "GenericName") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "BrandName") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "Dosage") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "Packing") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "UnitPrice") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }

    if (e.Column.FieldName == "UnitCost") {
      e.Appearance.BackColor = Color.WhiteSmoke;
      e.Appearance.ForeColor = Color.LightSlateGray;
      e.Appearance.Font = new Font(e.Appearance.Font, FontStyle.Regular);
    }
  }
}
  • General
Previous Post
Next Post