Exemplo n.º 1
0
        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();
        }