Create a new wrapper proc. This proc can call all your 4 procs based on some conditions you may want to apply. So the proc will return DataSet and in code you can do whatever you want to with this DataSet.
This way all you need is just call the wrapper proc from the code.
Thanks & Regards,
SP
Please do "Mark As Answer" if this helps you.
2177
Member
375 Points
325 Posts
Re: What is the better way to call multiple Stored Procedures
Apr 30, 2012 02:12 PM|LINK
Create a new wrapper proc. This proc can call all your 4 procs based on some conditions you may want to apply. So the proc will return DataSet and in code you can do whatever you want to with this DataSet.
This way all you need is just call the wrapper proc from the code.
SP
Please do "Mark As Answer" if this helps you.