is it possible to have different insert statements executed at the开发者_StackOverflow中文版 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.
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.
Try with Parallel Programing by using Task Parallel Library (TPL)
http://www.codeproject.com/KB/Parallel_Programming/NET4ParallelIntro.aspx
精彩评论