23-07-19, 09:30 PM
(23-07-19, 09:19 PM)asemshahen5 كتب : استبدل الاستعلام بـ :
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";
ادانى اخر قيمه فقط وهى 300
يعني جبلي بس اخر سطر للاسف
