How to perform sum per line on a datagridview in c#

Question

Good afternoon, I need a help, I have a datagridview that contains a Type Coin column and a Total Currency column. In the Currency Type column I can have up to 3 types of currency, euro currency, dollar currency and real currency. Now I need to do a sum per currency. Ex sum everything that is euro currency and show in txtboxEuro, then sum everything that is dollar currency and show in textboxDolar. How can I do this

follows the screen of the datagridview.

follows my code.

private void ListaGrid()
        {
            conex.Open();
            string strSQL = @"SELECT DISTINCT
                            SY.YF_DESC_SI                               AS [TIPO MOEDA],
                            RTRIM(SC.C7_PRODUTO) + ' - ' + SC.C7_DESCRI AS PRODUTO,
                            SUM(SC.C7_QUANT)                            AS QTDA, 
                            SUM(SC.C7_TOTAL * SC.C7_TXMOEDA)            AS TOTAL,
                            SUM(SC.C7_TOTAL)                            AS [TOTAL MOEDA]
                   FROM  SC7010 AS SC
                   INNER JOIN SM2010 AS SM WITH (NOLOCK) ON SM.M2_DATA = SC.C7_EMISSAO
                   INNER JOIN SA2010 AS SA WITH (NOLOCK) ON SA.A2_COD = SC.C7_FORNECE
                   INNER JOIN SYF010 AS SY WITH (NOLOCK) ON SY.YF_MOEFAT = SC.C7_MOEDA
                   WHERE SC.D_E_L_E_T_ <> '*' 
 AND SC.C7_EMISSAO BETWEEN CONVERT(datetime, '" + txtDtInicial.Text + "', 103) AND CONVERT(datetime,'" + txtDtFinal.Text + "', 103) AND SA.A2_COD = '" + txtCodFornec.Text + "' GROUP BY SC.C7_PRODUTO, SC.C7_DESCRI, SY.YF_DESC_SI ORDER BY RTRIM(SC.C7_PRODUTO) + ' - ' + SC.C7_DESCRI";

            comando = new SqlCommand(strSQL, conex);

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

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

            double QTDA = 0;
            foreach (DataGridViewRow rowKG in DGW_PedComprasPic.Rows)
            {
                QTDA += Convert.ToDouble(rowKG.Cells["QTDA"].Value);
            }
            txtProdkg.Text = Convert.ToString(QTDA);
            txtProdkg.Text = QTDA.ToString("N2");

            double TotalReal = 0;
            foreach (DataGridViewRow rowR in DGW_PedComprasPic.Rows)
            {
                TotalReal += Convert.ToDouble(rowR.Cells["TOTAL"].Value);
            }
            txtReal.Text = Convert.ToString(TotalReal);
            txtReal.Text = TotalReal.ToString("C");

            conex.Close();
        }

Answer 1

With LINQ it feels really good to do it, and simple.

decimal totalEuro = DGW_PedComprasPic.Rows.Cast<DataGridViewRow>()
.Where(t => t.Cells[/*Nome ou indice da coluna com o tipo da moeda */].Value.ToString() == "Euro")
.Sum(t => Convert.ToDecimal(t.Cells[/*Nome ou indice da coluna de com o valor */].Value));

txtBoxTotalEuro.Text = totalEuro; // Ajustar para valor monetário.