create procedure hentHold2
@id varchar(10)
as
select Hold.navn, Hold.Dag, Hold.uge, Hold.startTid, Hold.statusHold, Hold.varighed, Hold.maksAntal, Hold.salNr, Hold.instruktørID
from Hold
where holdID = @id

public void hentHold() {
		try {
			Connection minConnection;
			minConnection = DriverManager
					.getConnection("jdbc:sqlserver://LAPTOP-32KIS2JP\\DANIELSSQL;databaseName=YodaFitness2;user=sa;password=dani6602;");

			Statement stmt = minConnection.createStatement();

			ResultSet res = stmt.executeQuery("exec hentHold2 " + txfIdOpdater.getText());
			while (res.next()) {
				txfNavnOpdater.setText(res.getString(1));
				txfDagOpdater.setText(res.getString(2));
				txfUgeOpdater.setText(res.getString(3));
				txfStartTidOpdater.setText(res.getString(4));
				txfStatusOpdater.setText(res.getString(5));
				txfVaringhedOpdater.setText(res.getString(6));
				txfMaxAntalOpdater.setText(res.getString(7));
				txfSalNrOpdater.setText(res.getString(8));
				txfInsOpdater.setText(res.getString(9));
			}

			if (res != null)
				res.close();
			if (stmt != null)
				stmt.close();
			if (minConnection != null)
				minConnection.close();
		} catch (Exception e) {
			System.out.println("fejl:  " + e.getMessage());
		}
	}