[maxruined]

(24-07-19, 01:29 AM)Hmd30 كتب :

PHP كود :

private void button1_Click(object sender, EventArgs e) {
    double amount = SumAmount(6760, "Magdy kamel");
    textBox6.Text = amount.ToString();
}


public double SumAmount(int Project_Number, string Beneficiary_Name) {
    double amount = 0;

    string sql =
        " SELECT Sum([Amount]) AS Amount,                           " +
        " FROM   [CHEQUES]                                          " +
        " WHERE  ( [Project_number] = @prjNum )                     " +
        "        AND ( [Beneficiary_name] OR [Notes] = @bnfName )   ";

    using (SqlCommand cmd = new SqlCommand(sql, sqlcon)) {
        cmd.Parameters.AddWithValue("@prjNum", Project_Number);
        cmd.Parameters.AddWithValue("@bnfName", Beneficiary_Name);

        if (sqlcon.State != ConnectionState.Open) sqlcon.Open();
        amount = (double)cmd.ExecuteScalar();
        sqlcon.Close();

    }

    return amount;
} 


شكرا جداًَ اخى العزيز