急！！！－－存储过程的返回值，不对！ 附代码

[shaying]

存储过程：
是一个登录界面
userid主键

--处理用户登录事件
CREATE proc sm_login_user
@userid bigint output,
@username varchar(50) output,
@pwd varchar(50),
@type varchar(50)

As
begin
select
@userid=UserID,
@username=UserName
from
Users
where
UserName=@username and Password=@pwd and Type=@type
--如果用户未注册
if @@ROWCOUNT<1
select @username='null'
--print @userid
--print @username
end
GO

调用过程：

public class UserDetails
{
public Int32 UserID;
public string UserName;
public string Password;
public string Type;
}

public UserDetails UserLogin(string username,string pwd,string type)
{
SqlConnection myConnection =
new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand myCommand = new SqlCommand("sm_login_user",myConnection);

myCommand.CommandType = CommandType.StoredProcedure;

SqlParameter prmUserID = new SqlParameter("@userid",SqlDbType.BigInt);
prmUserID.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(prmUserID);

SqlParameter prmUserName = new SqlParameter("@username",SqlDbType.VarChar,50);
prmUserName.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(prmUserName);

SqlParameter prmPassword = new SqlParameter("@pwd",SqlDbType.VarChar,50);
prmPassword.Value = pwd;
myCommand.Parameters.Add(prmPassword);

SqlParameter prmType = new SqlParameter("@type",SqlDbType.VarChar,50);
prmType.Value = type;
myCommand.Parameters.Add(prmType);

UserDetails myUserDetails = new UserDetails();

myUserDetails.UserID = Convert.ToInt32(prmUserID.Value);
myUserDetails.UserName = prmUserName.Value.ToString();
--------------------------------------------------------------------------------------
为什么输入正确的UserName,Password,Type，存储过程返回的值也是:myUserDetails.UserID无值，
myUserDetails.UserName＝“null”,单独测试存储过程没问题的！

[YAOHE]

UserName=@username 有问题吧，你多定义变量试试

[singlepine]

SqlDbType.BigInt，太大了吧，换成SqlDbType.Int试试

[shaying]

谢谢，不过单独测试存储过程没问题，print输出正确

[baituole]

up坐沙发的,输出参数怎么可以当输入参数里