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();
}
