23-07-19, 09:19 PM
استبدل الاستعلام بـ :
PHP كود :
string SqlStr = "SELECT sum(Amount)as Amount, Beneficiary_Name, Project_Number FROM CHEQUES WHERE(Beneficiary_Name = N'" + cmbaccountname.Text + "')
AND (Project_Number = " + cmbprojectnumber.Text + ")or(Notes=N'" + cmbaccountname.Text + "') group by Beneficiary_Name, Project_Number";
سبحان الله وبحمده سبحان الله العظيم و الحمد لله ولا اله الا الله والله اكبر
