使用者驗證SQL存儲過程和調用存儲過程

--使用者驗證存儲

create proc proc_Login(@userName varchar(50),@passWord varchar(50))

as

  begin

    select * from dbo.UserInfo where [email protected] and[email protected]

  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("失敗!");

            }