110,535
社区成员
发帖
与我相关
我的任务
分享输出参数用ExecuteScalar返回的总是0
存储过程
create proc P_LoginUserName
@UserName varchar(50),
@UserPwd varchar(50),
@Flag bit,
@UserId int output
as
begin
SELECT @UserId=UserID FROM tb_User where UserName=@UserName and UserPwd = @UserPwd and Flag=@Flag
end
go
declare @Id int
exec P_LoginUserName '2','2',false ,@Id output
select @Id
执行成功，查询也可以
public int LoginUserName(User user)
{
string procname = "P_LoginUserName";
SqlParameter[] parms = { new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@UserPwd", SqlDbType.VarChar, 50),
new SqlParameter ("@Flag",SqlDbType.Bit ),new SqlParameter ("@UserId",SqlDbType .Int ) };
parms[0].Value = user.UserName;
parms[1].Value = user.UserPwd;
parms[2].Value = user.Flag;
parms[3].Direction = ParameterDirection.Output;
int result = DataBase.ExecuteScalar(procname, parms);--这里返回的是0
return result;
}
create proc P_LoginUserName
@UserName varchar(50),
@UserPwd varchar(50),
@Flag bit,
@UserId int output
as
begin
SELECT @UserId=UserID FROM tb_User where UserName=@UserName and UserPwd = @UserPwd and Flag=@Flag
end
go
declare @Id int
exec P_LoginUserName '2','2',false ,@Id output
select @Id
执行成功，查询也可以
public int LoginUserName(User user)
{
string procname = "P_LoginUserName";
SqlParameter[] parms = { new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@UserPwd", SqlDbType.VarChar, 50),
new SqlParameter ("@Flag",SqlDbType.Bit ),new SqlParameter ("@UserId",SqlDbType .Int ) };
parms[0].Value = user.UserName;
parms[1].Value = user.UserPwd;
parms[2].Value = user.Flag;
parms[3].Direction = ParameterDirection.Output;
int result = DataBase.ExecuteScalar(procname, parms);--这里返回的是0
return result;
}
...全文
请发表友善的回复…
发表回复
蔡袅 2010-10-25
- 打赏
- 举报
第一行第一列
xiaoshen1360 2010-10-25
- 打赏
- 举报
[Quote=引用 2 楼 findcaiyzh 的回复:]
你不是用@UserId作为返回值吗？
parms[3]才是@UserId
msdn中对于SqlCommand.ExecuteScalar 的解释
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional co……
[/Quote]
学习
你不是用@UserId作为返回值吗？
parms[3]才是@UserId
msdn中对于SqlCommand.ExecuteScalar 的解释
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional co……
[/Quote]
学习
宝_爸 2010-10-25
- 打赏
- 举报
你不是用@UserId作为返回值吗？
parms[3]才是@UserId
msdn中对于SqlCommand.ExecuteScalar 的解释
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
如果你想使用ExecuteScalar 的返回值而不是输出参数，可以修改你的sql语句
SELECT UserID FROM tb_User where UserName=@UserName and UserPwd = @UserPwd and Flag=@Flag
parms[3]才是@UserId
msdn中对于SqlCommand.ExecuteScalar 的解释
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
如果你想使用ExecuteScalar 的返回值而不是输出参数，可以修改你的sql语句
SELECT UserID FROM tb_User where UserName=@UserName and UserPwd = @UserPwd and Flag=@Flag
lutaotony 2010-10-25
- 打赏
- 举报
public static int ExecuteScalar(string procName, SqlParameter[] parames)
{
SqlConnection con = GetCon();
SqlCommand com = ComCreat(procName, parames, con);
int scalar = Convert.ToInt32(com.ExecuteScalar());
con.Close();
return scalar;
}
{
SqlConnection con = GetCon();
SqlCommand com = ComCreat(procName, parames, con);
int scalar = Convert.ToInt32(com.ExecuteScalar());
con.Close();
return scalar;
}
claymore1114 2010-10-25
- 打赏
- 举报
贴一下你的 DataBase.ExecuteScalar方法。
flyerwing 2010-10-25
- 打赏
- 举报
[Quote=引用 2 楼 findcaiyzh 的回复:]
你不是用@UserId作为返回值吗？
parms[3]才是@UserId
msdn中对于SqlCommand.ExecuteScalar 的解释
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional co……
[/Quote]
权威.
你不是用@UserId作为返回值吗？
parms[3]才是@UserId
msdn中对于SqlCommand.ExecuteScalar 的解释
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional co……
[/Quote]
权威.
lutaotony 2010-10-25
- 打赏
- 举报
使用 ExecuteScalar 方法返回结果中第一行的第一列的值，以及返回值和返回参数。
lutaotony 2010-10-25
- 打赏
- 举报
我在请教一下，因为select count(*) from tb_user 时返回的也是一个值，但是也可以用ExecuteScalar（）来接这个参数。
SELECT @UserId=UserID FROM tb_User where UserName=@UserName and UserPwd = @UserPwd and Flag=@Flag
我这里也是返回一个参数。可能说法有点不太好请教中
SELECT @UserId=UserID FROM tb_User where UserName=@UserName and UserPwd = @UserPwd and Flag=@Flag
我这里也是返回一个参数。可能说法有点不太好请教中
yuha521 2010-10-25
- 打赏
- 举报
呵呵！！不会！绑定！
