存储过程:
CREATE PROCEDURE UserLogin
(
@Username nvarchar (50),
@Password nvarchar (100)
)
AS
select * From UserInfo
where (UserName=@Username) and (Password=@Password)
RETURN
GO
--------cs文件 SqlDataAdapter ds = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("UserLogin", connectionString);
cmd.Connection = connectionString;
cmd.CommandType = CommandType.StoredProcedure; SqlParameter prm1 = new SqlParameter("@username", SqlDbType.NVarChar, 50);
SqlParameter prm2 = new SqlParameter("@password", SqlDbType.NVarChar, 100); prm1.Value = username.Text;
prm2.Value = password.Text;
connectionString.Open();
cmd.ExecuteNonQuery();
connectionString.Close();我想通过存储过程实现登陆,不知道怎么判断这个人是不是登陆成功,不如能传回来一个值那样。。刚刚学习.net使用存储过程。请指教!我分不多了。。不好意思
CREATE PROCEDURE UserLogin
(
@Username nvarchar (50),
@Password nvarchar (100)
)
AS
select * From UserInfo
where (UserName=@Username) and (Password=@Password)
RETURN
GO
--------cs文件 SqlDataAdapter ds = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("UserLogin", connectionString);
cmd.Connection = connectionString;
cmd.CommandType = CommandType.StoredProcedure; SqlParameter prm1 = new SqlParameter("@username", SqlDbType.NVarChar, 50);
SqlParameter prm2 = new SqlParameter("@password", SqlDbType.NVarChar, 100); prm1.Value = username.Text;
prm2.Value = password.Text;
connectionString.Open();
cmd.ExecuteNonQuery();
connectionString.Close();我想通过存储过程实现登陆,不知道怎么判断这个人是不是登陆成功,不如能传回来一个值那样。。刚刚学习.net使用存储过程。请指教!我分不多了。。不好意思
SqlParameter prm2 = new SqlParameter("@password", SqlDbType.NVarChar, 100); prm1.Value = username.Text;
prm2.Value = password.Text;这里的参数要加到 Command 对象的 Parameters 集合里去:
cmd.Parameters.Add(prm1);
cmd.Parameters.Add(prm2);cmd.ExecuteNonQuery();
改成:
SqlDataReader reader = cmd.ExecuteReader();
if(reader.Read())
{
// 找到了相关的用户
}
else
{
// 没找到用户信息
}
reader.Close();