Reputation: 757
is it possible to have different insert statements executed at the sametime? when a button is clicked?
Because We Are Tasked to normalize the table so I've divided my tables to reach its 3rd normal form.
However I am having a problem when I am inserting data into the database using my c# winform application.
What I want when the user clicks the button "CONFIRMED" the data will be separately inserted into different tables. And I will just then combine those tables using a select statement.
Upvotes: 0
Views: 251
Reputation: 18061
One possible way to handle this would be using a stored procedure to do the actual inserting/updating (CRUD). It will help you separate your layers and make any changes inside your database transparent to your frontend application.
Upvotes: 2