Hello,
consider this simple SP,
Code:
Create Procedure GetAuthorsCount
AS
Return ( Slect Count(*) From Authors )
below code use that SP and returns the result as a return value,
Code:
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%
Dim conPubs As SqlConnection
Dim cmdAuthorCount As SqlCommand
Dim parmReturnValue As SqlParameter
Dim intAuthorCount As Integer
conPubs = New SqlConnection( "Server=localhost;uid=sa;pwd=secret;database=pubs" )
cmdAuthorCount = New SqlCommand( "GetAuthorCount", conPubs )
cmdAuthorCount.CommandType = CommandType.StoredProcedure
parmReturnValue = cmdAuthorCount.Parameters.Add( "ReturnValue", SqlDbType.Int )
parmReturnValue.Direction = ParameterDirection.ReturnValue
conPubs.Open()
cmdAuthorCount.ExecuteNonQuery()
intAuthorCount = cmdAuthorCount.Parameters( "ReturnValue" ).Value
conPubs.Close()
%>
There are <%=intAuthorCount%> records in the Authors table
ofcource,if I were you I would used output parameters instead of return values because,
1-return values just could return integers,
2-return values just return one value,
HtH.
_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.
stored procedure
