Enterprise Library 2.0 取得存储过程的返回值

  http://blog.youkuaiyun.com/hawkjin/archive/2007/05/25/1625271.aspx(转)

1.存储过程

 

CREATE PROCEDURE p1  AS
return 1
GO

2.C#代码

 

using System;
using System.Data;
using System.Data.Common;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace Test
...{
  public partial class _Default : System.Web.UI.Page
  ...{
    protected void Page_Load(object sender, EventArgs e)
    ...{
      Database db = DatabaseFactory.CreateDatabase();
      string sqlCommand = "p1";
      DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
      db.AddParameter(dbCommand, "myReturnValue", DbType.Int32, ParameterDirection.ReturnValue, "", DataRowVersion.Current, null);
      db.ExecuteNonQuery(dbCommand);
      Response.Write(db.GetParameterValue(dbCommand, "myReturnValue").ToString());

    }
  }
}