public static void updateStudent(Student newStudent, Student oldStudent) { SqlConnection connection = new SqlConnection(connString); connection.Open(); string query = "UPDATE students " + "SET ID = '" + newStudent.getID() + "', " + "FirstName = '" + newStudent.getFName() + "', " + "LastName = '" + newStudent.getLName() + "', " + "Email = '" + newStudent.getEmail() + "', " + "ClassID = '" + newStudent.getClassID() +"' "+ "WHERE ID = '" +oldStudent.getID() +"' AND classID = '" + oldStudent.getClassID() + "';"; Console.WriteLine("The update query is: " + query); SqlCommand cmd = new SqlCommand(query, connection); cmd.ExecuteNonQuery(); connection.Close(); }