一个简单的存储过程
以下代码是我在查询分析器中执行的!没有问题,但我不知道asp.net中怎样去读取这个过程.请大家帮忙
declare @isresult smallint
set @isresult=2
execute st_uponline '1 ',@isresult output
print @isresult

[解决办法]
SqlConnection myConnection = new SqlConnection(DBConnectionString.ConnectionString);
SqlCommand myCommand = new SqlCommand( "Pr_GetUsers ",myConnection);
//用存程
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = null;
try
{
myConnection.Open();
}
catch(Exception ex)
{
throw new MyException( "10001 ", "! ",ex);
}
try
{
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch(Exception ex)
{
throw new MyException( "10001 ",ex.Message,ex);
}

return dr;

是用存程的代。你考一下吧
[解决办法]
asp.net中 借助 ado.net 来读的。
比如说有个叫：DbDataAdapter 类

[解决办法]
try

Public Function UpdateOnlineInfo(ByVal userid As String) As Integer
Dim condb As SqlConnection
condb = New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings( "constr "))
condb.Open()
Dim selestr As SqlCommand
selestr = New SqlCommand( "st_uponline ", condb)
selestr.CommandType = CommandType.StoredProcedure
sqlCmd.Parameters.Add( "@userid ", userid);
sqlCmd.Parameters.Add( "@isresult ", SqlDbType.SmallInt);
sqlCmd.Parameters[ "@isresult "].Direction = ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
Dim bs As Integer
bs = sqlCmd.Parameters[ "@isresult "].Value

Return bs
condb.Close()
End Function 'UpdateOnlineInfo