William Ferguson
|
| Posted: 02/11/2004, 5:02 PM |
|
Anyone know how to map a SQL Server Stored Proc OUTPUT parm to a page?
Resultant recordsets work great when mapped to a datagrid, but I can't seem
to get the output parms to map.
Any suggestions would be appreciated.
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 02/11/2004, 6:06 PM |
|
You can specify Input/Output direction for each Stored Procedure parameter in your data source. If this doesn't work for you for some reason, please provide more details, describe the symptoms and/or errors.
You may also contact CodeCharge Support: http://support.codecharge.com
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
rodonnell
Posts: 1
|
| Posted: 03/16/2004, 4:29 PM |
|
Here is what I need to do. I'd like to do it for Stored Procedure Custom Insert. I have a Record Grid on a asp.net control and I want to use a Custom insert stored procedure. This works great. However, I need to return an output parameter or return value and then alter the redirecturl to include this information. I use VB.NET. My problem is that in the After Execute Insert event, I can no longer access the command parameters. I stepped through the project in Visual Studio and it appears the parameters are passed ByVal so by them time the custom code block in after execute insert fires, they are out of scope. Is there any sample code or sample project using output parameters or return values?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/17/2004, 12:18 AM |
|
CCS doesn't utilize SP output parameters at this time, although this could be done in the future.
At this time I can only suggest using the .NET SqlCommand (System.Data.SqlClient.SqlCommand or System.Data.OleDb.OleDbCommand) to execute your SQL in the Before Execute events.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Jon D
|
| Posted: 07/20/2005, 9:04 AM |
|
Does CCS utilize SP output parameters yet? I'm trying to something very similiar to rodonnell's post.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/21/2005, 11:48 AM |
|
No, not yet. This should be available in the next version of CCS.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
