I have a database, with 5 tables, for my question i just need 2 to explain
One is: AUFK
Second is: AUFP
In my form, AUFK is ment my adding a new ordernnumber(PK), the User who ordered and the date. This are Detailed View -> Textboxes and have the same bindingsource -> AUFK.
Now i have added into AUFK, the datatable AUFP, this is going by dataset. So i
get a datagridview from AUFP, from AUFK.
AUFP is just, if a User have already AUFK entries, it should display them, when you validate the AUFK Number Textbox in the form.
What i have done till now:
-creating the adapter for that table
private Data.lehrlingDataSetTableAdapters.NV_AUFKTableAdapter AUFKAdapter = new Data.lehrlingDataSetTableAdapters.NV_AUFKTableAdapter();
- i filled the datatable on load:
- i set the proper settings in the datatabledesigner for the relations, but now i dont know how to use the datatableadapter right. If i validate the AUFK number box, if the number exists that it should fill my gridview AUFP.
Thank you for evtl. help!