使用ADO调用存储过程
create proc usp_Login
@uname varchar(50),
@password varchar(50),
@result bit output
as
begin
declare @count int
set @count=(select COUNT(*) from T_Users where FuserName=@uname and
Fpassword=@password)
if @count>0
begin
set @result=1
end
else
begin
set @result=0
end
end
declare @r bit
exec usp_Login 'admin','111',@result=@r output
string username = txtUserName.Text.Trim();
string password = txtPassword.Text.Trim();
string UserConstr = ConfigurationManager.ConnectionStrings["UserDB1conStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(UserConstr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
string sp_name = "usp_Login";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sp_name;
SqlParameter prm1 = new SqlParameter("@uname", username);
SqlParameter prm2 = new SqlParameter("@password", password);
SqlParameter prm3 = new SqlParameter("@result", System.Data.SqlDbType.Bit);
cmd.Parameters.Add(prm1);
cmd.Parameters.Add(prm2);
cmd.Parameters.Add(prm3);
prm3.Direction = ParameterDirection.Output;
object obj = cmd.ExecuteScalar();
bool b = Convert.ToBoolean(prm3.Value);
if (b)
{
Label2.Text = "登录成功";
}
else
{
Label2.Text="登录失败";
}
}
}