获得存储过程的返回值

 

在csl类中使用的方法:

namespace WebApplication.获得存储过程的返回值
{
    public partial class GetProcReturnValue : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string str = "";
            bind(out str);

            txtReturn.Text = str;
        }

        //数据绑定并返回查询到的数据行数
        void bind(out string txt)
        {
            SqlParameter[] parameters = {

                        new SqlParameter("@AreaId", SqlDbType.Int,4),
                        new SqlParameter("@AreaNmae", SqlDbType.VarChar,30),
                        new SqlParameter("@outData", SqlDbType.Int,4),                         
                                        };
            parameters[0].Value = 9;
            parameters[1].Value = "上海市";
            parameters[2].Direction = ParameterDirection.Output;

            DataTable table = DAL.SqlHelper.ExcuteProctestTable("getOutData", parameters);

            GridView1.DataSource = table;
            GridView1.DataBind();

          

            txt = parameters[2].Value.ToString();

 

          

 

        }

    }
}

 

数据库中存储过程的写法:

- - 写法一（直接对数据返回参数进行赋值）

USE [MyThreeLevel]
GO
/****** Object:  StoredProcedure [dbo].[getOutData]    Script Date: 05/12/2013 08:38:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--获得存储过程的返回值
create proc [dbo].[getOutData]
(
 @AreaId int,
 @AreaNmae varchar(30),
 @outData int out
)

as
begin
select * from AreaFull where AreaPid=0

select @outData=COUNT(1) from AreaFull where AreaPid=0

end

 

 

--写法二（调用数据库中的统计全局变量）

--获得数据总数
ALTER proc [dbo].[getSqlData]
(
 @count int out
)
as
begin

select ID,FRoleName,FDescription,State from FRole
set @count=@@ROWCOUNT--设置获得返回的数据条数,这种写法是把数据主键设置成自增列的情况

end