使用ADO调用存储过程

使用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="登录失败";
                   }
                
               }
           }