用户验证SQL存储过程和调用存储过程

--用户验证存储

create proc proc_Login(@userName varchar(50),@passWord varchar(50))
as
  begin
    select * from dbo.UserInfo where UserName=@userName andUserPassWord=@passWord
  end

 

--调用存储

exec pro_login 'chenyun','123'

 

--在ASP中调用存储

 //执行存储过程
            SqlConnection con = new SqlConnection("Data Source=ZHOUYAPENG;Initial Catalog=chenyun;Integrated Security=True");
            con.Open();
            var cmd = new SqlCommand("proc_Login", con);
            cmd.CommandType = CommandType.StoredProcedure;

            //添加输入查询参数、赋予值
            cmd.Parameters.Add("@userName", SqlDbType.VarChar);
            cmd.Parameters["@userName"].Value = name;
            cmd.Parameters.Add("@passWord",SqlDbType.VarChar);
            cmd.Parameters["@passWord"].Value = pwd;
            
             //执行查询
            using (var reader = cmd.ExecuteReader())
            {
                if (reader.Read())
                    MessageBox.Show("成功!");
                else
                    MessageBox.Show("失败!");
            }