Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2005-04-06 : 09:55:27
|
| Hello guysI want to give some parameters either in interger or string to a stred procudures like examplecs.commandtext="exec sp_name(param,param)"cs.executenow i want to receive some outputs it may be either single result or resultset. how could i receive my output. however can i use return_value=cs.execute.fileds(0) or not please tell me. and if not then give me the idea about how i can do thatamit kumar madhukar |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-04-06 : 10:55:41
|
| Google on ASP ParameterYou'll find pages like this. |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-06 : 16:53:07
|
Using a command object (ADO or ADO.net) you can specify input vs. output parameters. Since you need to return a value you need to append output parameters to this command object. Once you execute this command you can return the results. Also you may consider returning actual rowsets if you need various fields from your database after an update / insert.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Return From Stored Procedure