private void AddPlayerLog() { try { DataHandler dh = new DataHandler(); playerLog pl = new playerLog(MilitaryGame.playerID, recordedHealth.Min().ToString(), recordedFuel.Min().ToString(), allRecordedSpeeds.Max().ToString(), allRecordedAltitudes.Max().ToString(), PickAircraft.aircraftUsed); dh.AddPlayerLog(pl); } catch (Exception) { MessageBox.Show("An error occurred when adding your results", "Error"); } }
public void AddPlayerLog(playerLog player) { conn.Open(); string command = "INSERT INTO tblPlayer_Log (playerID, Health, Fuel, MaxSpeed, MaxAltitude, AircraftUsed) VALUES (" + "'" + player.PlayerId + "'," + "'" + player.Health + "'," + "'" + player.Fuel + "'," + "'" + player.MaxSpeed + "'," + "'" + player.MaxAltitude + "'," + "'" + player.AircraftUsed + "')"; OleDbCommand cmd = new OleDbCommand(command, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); conn.Close(); }