Save data to different tables using same button

Question

how to insert data to different tables using same save button in tab control c# (diffent form in tab page but only have one save button for every tab page)

Sundar · Answer

Pass all values that are to be inserted into data using Store Procedure. Get the Parameters in SP and In that Write your SQL. Eg: Alter procedure [dbo].[Sample] ( @dataOne int=0 @dataTwo int=0 ) AS BEGIN Insert into TableOne (dataone) values(@dataOne) Insert into TableTwo (dataTwo) values (@dataTwo) END

Tapan Patel · Answer

though form exists in different tab it is still inside the main/MDI form right? (correct me if I am wrong). So ideally when you hit the Save (or any button tied to Save operation) you should check of existence of datasets for that form and if exists push them too along with current tab's data sets.

Ankit Rajput · Answer

Check the focus of Tab Page and set some flag or enum for table selection.