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

http://blog.csdn.net/hawkjin/archive/2007/05/25/1625271.aspx(转)

1.存储过程

CREATEPROCEDUREp1AS
return1
GO

2.C#代码

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

usingMicrosoft.Practices.EnterpriseLibrary.Common;
usingMicrosoft.Practices.EnterpriseLibrary.Data;

namespaceTest
...{
publicpartialclass_Default:System.Web.UI.Page
...{
protectedvoidPage_Load(objectsender,EventArgse)
...{
Databasedb=DatabaseFactory.CreateDatabase();
stringsqlCommand="p1";
DbCommanddbCommand=db.GetStoredProcCommand(sqlCommand);
db.AddParameter(dbCommand,"myReturnValue",DbType.Int32,ParameterDirection.ReturnValue,"",DataRowVersion.Current,null);
db.ExecuteNonQuery(dbCommand);
Response.Write(db.GetParameterValue(dbCommand,"myReturnValue").ToString());

}
}
}