//Updates existing save game public void UpdateSaveFileList(int gameFileSelection) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { //Open connection conn.Open(); //Calls private instance variable from above to input SQL command SqlCommand cmd = new SqlCommand(SQL_ReSaveGameFIle, conn); cmd.Parameters.AddWithValue("@save_id", PlayerClass.SaveID); cmd.Parameters.AddWithValue("@player_name", PlayerClass.PlayerName); cmd.Parameters.AddWithValue("@player_level", PlayerClass.PlayerLevel); cmd.Parameters.AddWithValue("@player_money", PlayerClass.PlayerMoney); cmd.Parameters.AddWithValue("@owned_weapon_type", PlayerClass.OwnedWeaponType); cmd.Parameters.AddWithValue("@owned_weapon_damage", PlayerClass.OwnedWeaponDamage); cmd.Parameters.AddWithValue("@owned_armor_type", PlayerClass.OwnedArmorType); cmd.Parameters.AddWithValue("@owned_armor_value", PlayerClass.OwnedArmorValue); cmd.ExecuteNonQuery(); PlayerClass.CheckSave(PlayerClass.SaveID); } } catch { Console.Clear(); Console.WriteLine("\n Sorry, the game failed to save. It was probably your fault."); Thread.Sleep(2000); Console.Clear(); } }