存储过程，传入一个参数，返回一个参数

[coffeedou]

请帮我写一个完整的C#。NET的例子，调用这个存储过程，并得到返回值。

[yaterman2]

存储过程在那里阿

[coffeedou]

CREATE PROCEDURE p_getdepartcode @parent_code varchar(10 AS
begin
declare @departcode varchar(10)
set @departcode = (select MAX(depart_code) from bas_depart where len(depart_code)-2=len(@parent_code) and

left(depart_code,len(parent_code)) = @parent_code )
if @departcode is null
set @departcode = @parent_code + '01'
else
set @departcode = str(@departcode + 1)
select @departcode
end
GO

[brightheroes]

你这个存储过程并没有返回值

[brightheroes]

http://community.csdn.net/Expert/topic/3601/3601723.xml?temp=.1158716

[sweet12345]

dim par as new sqlparameter
par.direction=output
.....
sqlcommand.sqlparametter.add(par)
定义了par的direction后，调用了sqlcommand.execute后，就可以将返回值自动赋给par了。

[sweet12345]

同样的，输入的参数，可以不用指定direction，默认的就是输入参数（input）

[memgarden]

这个存储过程不带输出参数和返回值呀

[coffeedou]

select 不能返回值吗？

[YUAN168]

CREATE function p_getdepartcode @parent_code varchar(10)
RETURNS VARCHAR(10)
begin
declare @departcode varchar(10)
set @departcode = (select MAX(depart_code) from bas_depart where len(depart_code)- 2=len(@parent_code) and

left(depart_code,len(parent_code)) = @parent_code )
if @departcode is null
set @departcode = @parent_code + '01'
else
set @departcode = str(@departcode + 1)
RETURN @departcode
end

[coffeedou]

存储过程：
CREATE PROCEDURE p_getdepartcode @parent_code varchar(10),@depart_code_out varchar(10) output AS
begin
declare @departcode varchar(10)
set @departcode = (select MAX(depart_code) from bas_depart where len(depart_code)-2=len(@parent_code) and

left(depart_code,len(parent_code)) = @parent_code )
if @departcode is null
set @departcode = @parent_code + '01'
else
set @departcode = str(@departcode + 1)
set @depart_code_out = @departcode
return @depart_code_out
end
GO

C#，ASP.NET中：
try
{
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["connstring"]);
SqlCommand cmd = new SqlCommand("p_getdepartcode",conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@parent_code",Request.QueryString["departcode"]);
Parameters[1] = new SqlParameter("@depart_code_out",SqlDbType.VarChar,10);
Parameters[1].Direction = ParameterDirection.Output;
cmd.Parameters.Add(Parameters);
cmd.ExecuteNonQuery();
depart_code.Text = Parameters[1].Value.ToString();
}
catch
{
Response.Write("执行存储过程错误，请确认您输入的参数！");
}

哪儿错了？