OpdatereHold

public void OpdaterHold() {
		try {
			Connection minConnection;
			minConnection = DriverManager
					.getConnection("jdbc:sqlserver://Dennis;databaseName=YodaFitness;user=sa;password=HelloWorld;");

			Statement stmt = minConnection.createStatement();

			int id = Integer.parseInt(txfIdOpret.getText().trim());
			String navn = txfNavnOpret.getText();
			String dag = txfDagOpret.getText();
			String uge = txfUgeOpret.getText();
			String start = txfStartTidOpret.getText();
			String status = txfStatusOpret.getText();
			String varighed = txfVaringhedOpret.getText();
			String maxAntal = txfMaxAntalOpret.getText();
			String sal = txfSalNrOpret.getText();
			String insID = txfInsOpdater.getText();

			String sql = "exec updateHold" + " " + id + ", '" + navn + "', " + "'" + dag + "', '" + uge + "', '" + start
					+ "', '" + status + "', " + varighed + ", '" + maxAntal + "', '" + sal + "','" + insID + "'";

			stmt.executeUpdate(sql);

			if (stmt != null) {
				stmt.close();
			}
			if (minConnection != null) {
				minConnection.close();
			}

		} catch (Exception e) {
			System.out.println("fejl:  " + e.getMessage());
		}
	}