ASP.Net调用存储过程，如何取得其返回值呢?

Question

strSQL = " select * from T_OECMonthCommentBaseData where YearMonth='" + Trim(Me.sltYear.SelectedItem.Value) & Trim(Me.sltMonth.SelectedItem.Value) + "'"
        drResult = sqlQry.Query(strSQL)        If drResult.Rows.Count < 1 Then
            strSQL = "exec P_GetMonthTotalData @sEmployeeCondi='" + sEmployeeCondi + "',@YearMonth='" + Trim(Me.sltYear.SelectedItem.Value) & Trim(Me.sltMonth.SelectedItem.Value) + "',"
            strSQL += "@LegalWorkdays=" + CStr(Me.txtLawDay.Value) + ",@TotalDays=" + CStr(Me.txtFactDay.Value) + ",@iFlag=1"
        Else
            strSQL = "exec P_GetMonthTotalData @sEmployeeCondi='" + sEmployeeCondi + "',@YearMonth='" + Trim(Me.sltYear.SelectedItem.Value) & Trim(Me.sltMonth.SelectedItem.Value) + "',"
            strSQL += "@LegalWorkdays=" + CStr(Me.txtLawDay.Value) + ",@TotalDays=" + CStr(Me.txtFactDay.Value) + ",@iFlag=2"
        End If        'Response.Write(strSQL)
        If sqlQry.InsUpdDelQry(strSQL) Then
            Response.Write("<script language='javascript'>")
            Response.Write("alert('汇总数据生成成功！');")
            Response.Write("</script>")
        Else
            Response.Write("<script language='javascript'>")
            Response.Write("alert('汇总数据生成失败,请重试！');")
            Response.Write("</script>")
        End If这是在服务器端的

Answer 1

添加 Direction.ReturnValue 类型的参数

Answer 2

CREATE PROCEDURE    P_GetMonthTotalData            
(
    return 1  //return -1 ）

Answer 3

OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@RetVal", OleDbType.Integer);
cmd.Parameters["@RetVal"].Direction = ParameterDirection.ReturnValue;
while (rdr.Read())
    Console.WriteLine("OrderID = " + rdr[0].ToString());
rdr.Close();
//注意必须要数据库操作完全 完成后才能访问到return value
Console.WriteLine(cmd.Parameters["@RetVal"].Value.ToString() + " orders");
cn.Close();