Passing datatable as parameter to stored procedure

Suraj Kumbhar

Hello,

I have three tables as one master and 2 details table. I want to save data in all three tables by passing single datatable as parameter to stored procedure.

Can anybody tell me how to do that??

How to store values from one table to all three different tables??

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
I believe that you have already implemented to pass DataTable as parameter to StoredProcedure. So if you have multiple table insert then why are not passing multiple parameters. That will be easy for you to insert data into original tables.

Alternative way is to pass data as XML format. XML contains all master table records as well as Details table data. In StoredProcedure you need parse and insert into respective tables.

https://www.aspsnippets.com/Articles/Pass-XML-parameter-to-Stored-Procedure-in-C-and-VBNet.aspx

http://www.aspdotnet-suresh.com/2012/12/aspnet-send-xml-file-as-parameter-to.html
Suraj Kumbhar9y ago
Hello Manas,
Thank you so much for your suggession. Passing table as parameter to stored procedure is totally new concept for me. I will try implemeting parameter as you said.
Thanks & Regards,
Suraj