大哥帮帮我!!!
我的表:
ID username usertype存储过程:
CREATE PROC P_GetInfo
@id int,
@username varchar(50) output
AS
begin
select * from T_My_Test where ID=@id;
RETURN
end
GO
调用存储过程输出参数@username:
function
{
..../打开链接
myCommand.Parameters.Add(new SqlParameter("@id",SqlDbType.Int));//添加参数
myCommand.Parameters["@id"].Value =1;
SqlParameter paramID = new SqlParameter("@username",SqlDbType.VarChar);
paramID.Direction = ParameterDirection.ReturnValue;
myCommand.Parameters.Add(paramID);
.....//绑定数据
输出参数:
}提示错误: 过程 'P_GetInfo' 需要参数 '@username',但未提供该参数
我的表:
ID username usertype存储过程:
CREATE PROC P_GetInfo
@id int,
@username varchar(50) output
AS
begin
select * from T_My_Test where ID=@id;
RETURN
end
GO
调用存储过程输出参数@username:
function
{
..../打开链接
myCommand.Parameters.Add(new SqlParameter("@id",SqlDbType.Int));//添加参数
myCommand.Parameters["@id"].Value =1;
SqlParameter paramID = new SqlParameter("@username",SqlDbType.VarChar);
paramID.Direction = ParameterDirection.ReturnValue;
myCommand.Parameters.Add(paramID);
.....//绑定数据
输出参数:
}提示错误: 过程 'P_GetInfo' 需要参数 '@username',但未提供该参数
CREATE PROC P_GetInfo
@id int,
@username varchar(50) output
AS
begin
select @username=username from T_My_Test where ID=@id;
RETURN
end
GO
可以
BEGIN
select @username= (select username from T_My_Test where ID=@id)
END
OutputValue.Direction = ParameterDirection.Output;
OutputValue.Value = "";
存储过程:
CREATE PROC P_GetInfo
@id int,
@username varchar(50) output
AS
begin
select @username=username from T_My_Test where ID=@id;
RETURN
end
GO
要return就没必要output