Insert Gridview data using using datatable

Question

Sir in my application i have 2 tables  Master table & Detail table.. Textbox values are insert into master table & gridview data insert into Detail table.. Using store procedure how to insert both data in single execution . help sir

Ajith kp · Answer

Thank you but how can save grid data and text box data into 2 tables using a single stored procedure.. ?? Any one please help..

Sanjay Kumar · Answer

Hi Ajith kp using Transaction multiple tables insert( 2 tables ) this link show only ref http://www.c-sharpcorner.com/UploadFile/47548d/simple-mysql-transaction-in-Asp-Net/ http://blog.sqlauthority.com/2010/06/02/sql-server-stored-procedure-and-transactions/ http://stackoverflow.com/questions/3948816/multiple-inserts-and-selects-in-one-stored-procedure