I have a simple question I think, but do not seem to find an answer easily
I have a lisbox and a gridview. Both are connected to a database through the design editor.
visualisation works, but now I want to show only the items in the gridview which are connected to a chosen item in the listbox.
I already set the listbox to visualize a name and the value member to have the "primary key".
Now I want to show only the items in the gridview who are connected to this primary key.
Inside the design editor I can add a query like this :
SELECT pkID, ProductieVolgorde, Stuknr, Rolnr, AantalMeters, DatumTijd, Status, fkPO
WHERE fkPO = @What do I place here?
how do I link the chosen value member of the listbox to this fkPO in the query?
Is there somewhere a simple tutorial on how to link a database fully inside the Design editor?
thanks in advance