public static void updateClass(Class newClass, Class oldClass) { SqlConnection connection = new SqlConnection(connString); connection.Open(); string query = "UPDATE classes " + "SET className = '" + newClass.getClassName() + "', " + "classSection = '" + newClass.getClassSection() + "', " + "facebookGroupId = '" + newClass.getFbGroupID() + "' " + "WHERE classID = " + oldClass.getClassID() +";"; Console.WriteLine("The update query is: "+query); SqlCommand cmd = new SqlCommand(query, connection); cmd.ExecuteNonQuery(); connection.Close(); }