private void btnRefresh_Click(object sender, EventArgs e) { DaoRepVentas daoRepVentas = new DaoRepVentas(); DataSet dsData = daoRepVentas.getVentasMes(dtpFecha.Value.ToShortDateString()); refreshData(); dgvData.Columns.Clear(); dgvData.Rows.Clear(); dgvData.DataSource = dsData.Tables[0]; DataGridViewColumn colum = new DataGridViewColumn(); colum.HeaderText = "FacturaEnDeuda"; colum.CellTemplate = new DataGridViewTextBoxCell(); dgvData.Columns.Add(colum); int idFact = 0; string Fact = ""; double totalDeudas = 0; int countDeudas = 0; System.Collections.IList list = dgvData.Rows; for (int i = 0; i < list.Count; i++) { DataGridViewRow row = (DataGridViewRow)list[i]; string Query = "SELECT deuda.id AS CODIGODEUDA, deuda.codeFact AS FACTURA, amount AS MONTO FROM deuda WHERE deuda.codeFact = '" + row.Cells[0].Value + "' AND deuda.active = 1;"; MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection()); MySqlDataReader reader; reader = Cmm.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { idFact = (int)reader["CODIGODEUDA"]; Fact = (string)reader["FACTURA"]; } if (idFact > 0) { row.Cells[7].Value = "SI"; row.Cells[7].ReadOnly = true; row.Cells[7].Style.BackColor = Color.Red; } else { row.Cells[7].Value = "NO"; row.Cells[7].ReadOnly = true; row.Cells[7].Style.BackColor = Color.Green; } } Cmm.Connection.Close(); } RecalcularTotales(); }