Save data to different tables using same button

Accepted 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 Patel9y ago

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 Rajput9y ago

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