[asemshahen5]

استبدل كل الكود السابق :

PHP كود :

private void SumAmount() 
        {
            string SqlStr = "SELECT sum(Amount)as Amount, Beneficiary_Name, Project_Number FROM CHEQUES WHERE(Beneficiary_Name = N'" + cmbaccountname.Text + "') AND (Project_Number = " + cmbprojectnumber.Text + ") group by Beneficiary_Name, Project_Number";
            SqlDataAdapter Fadp = new SqlDataAdapter(SqlStr, sqlcon);
            DataTable Fdt = new DataTable();
            Fadp.Fill(Fdt);
            if (Fdt.Rows.Count>0)
            {
                textBox6.Text = Fdt.Rows[0]["Amount"].ToString();
            }
            else
            {
                textBox6.Clear();
            }
        } 


بالكود التالي :

PHP كود :

private void SumAmount() 
    {
        double Sum = 0;
        foreach (DataGridViewRow item in dataGridView1.Rows)
        {
            Sum+=Convert.ToDouble( item.Cells[1].Value);
        }
        textBox6.Text = Sum.ToString();
    }