Hi Everyone,
I have set up a main tab control form that allows me to display data from several tables in the same database. Im using datagridviews to display the table data in each tab. The form is getting crowded, so I was thinking about allowing the user to insert new records to the tables in a new form by clicking on an "Add New" button. It seems more intuitive than just adding the row within the grid.
This button pops up a second form with a subset of the fields within the table. I would like to use this second form to simply add a new record to this table, and then after validation, this form would close and update the original datagridview reflecting the new record.
I'm new to forms programming, and I cant seem to figure out how best to handle the database insert. The dataset created in the main form is not visible in Form2, so what would be the best way to insert this new row from Form2?
Any help would be greatly appreciated.