Jagjit Saini

Jagjit Saini

  • NA
  • 166
  • 0

Erro

Sep 6 2011 11:12 AM
Hi

MySqlCommand


Query was working fine before writing .AddHours(3.5) , but after writing this it is giving error . I want to add(3.5)



Thanks
myCommand = new MySqlCommand("Insert into hs_hr_attendance (attendance_id,employee_id,punchin_time,punchout_time,out_note,status) values(" + 10 + "," + empno + "," + "Now().AddHours(3.5)" + "," + "NULL" + "," + "NULL" + "," + '2' + ")", con);

myCommand.ExecuteNonQuery();

Answers (4)