private void ultimos_pagamentos_Load(object sender, EventArgs e) { PessoaDAL pd = new PessoaDAL(); List <Lixo> l = pd.ListarLixo(); for (int i = 0; i < l.Count; i++) { dataGridView1.Rows.Add(new object[] { l[i].Nome_Cliente, l[i].Produto, l[i].Data_Pagamento, l[i].Valor_Pago, l[i].Cod_Lixeira }); } Decimal soma = pd.SomaDividas(); lblquantomedevem.Text = Convert.ToString(soma); ///////////////////////////////////////////////////////////////////////////////////// somantorio de dividas no dia DateTime dt1 = new DateTime(); dt1 = DateTime.Now; String data1 = dt1.ToString(); Decimal somatoriodia = 0; Decimal somatoriomes = 0; for (int i = 0; i < (dataGridView1.Rows.Count) - 1; i++) { if ((dataGridView1.Rows[i].Cells[2].Value.ToString())[0].Equals(data1[0]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[1].Equals(data1[1]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[3].Equals(data1[3]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[4].Equals(data1[4]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[6].Equals(data1[6]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[7].Equals(data1[7]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[8].Equals(data1[8]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[9].Equals(data1[9]))// pegando as datas de hoje { somatoriodia = somatoriodia + Convert.ToDecimal(dataGridView1.Rows[i].Cells[3].Value.ToString()); } } lblquantomepagaramhje.Text = Convert.ToString(somatoriodia); for (int i = 0; i < (dataGridView1.Rows.Count) - 1; i++) { if ((dataGridView1.Rows[i].Cells[2].Value.ToString())[3].Equals(data1[3]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[4].Equals(data1[4]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[6].Equals(data1[6]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[7].Equals(data1[7]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[8].Equals(data1[8]) && (dataGridView1.Rows[i].Cells[2].Value.ToString())[9].Equals(data1[9])) // pegando as datas de hoje { somatoriomes = somatoriomes + Convert.ToDecimal(dataGridView1.Rows[i].Cells[3].Value.ToString()); } } lblmepagaramessemes.Text = Convert.ToString(somatoriomes); }