[asp] [mysql] [software-architecture] Forum Topics

using (MySqlCommand cmd = new MySqlCommand("SELECT EmpId, Emp_Name, Salary , Start_date , End_date , CASE WHEN (Employees.End_Date is null) THEN DATEDIFF(DATE_ADD(Start_Date, INTERVAL 30 DAY), Start_Date) * Salary/30 ELSE DATEDIFF(End_Date, Start_Date) * Salary/30 END AS Total_Salary From Employees;")) { using (MySqlDataAdapter sda = new MySqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = …