Explain the logic of writing a string to the database. enter image description here

I have a form like this: enter image description here

Do I understand correctly that when adding a single row or several to the table Order1 (main table), I need to add these values ​​to the initial tables (schedule, specialties, patients, services) from the beginning, while clicking on the Add button, and then click Save to get these values ​​by key to the main table.

At the same time, in the form, each textBox is the value for the initial tables, that is, for the database you need one DataSet, and for each table its own instance of the DataAdapter that you got these values ​​into the main table?

  • What you first need to add an entry to the directory, and only then to the linked table is correct. But that for this you definitely need a special button - no longer. - Akina
  • Never use regular data, such as last names, to link data in tables. For this there are primary keys. The surname can change, you can make a mistake in it, there are namesakes, and the speed of work when linking to the fields with the whole digital data type is higher. - Sergey S.

0