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
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ajith kpPosted Feb 10, 2014, 3:18 AM
Sanjay KumarPosted Feb 10, 2014, 3:00 AM
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