Creating Login logic for asp.net C# and Stored procedure for finding Login and password

 

1. Create procedure [dbo].[spLogin]  
2. (  
3. @Email nvarchar(50),  
4. @Password nvarchar(50)  
5. )  
6. as  
7. begin  
8. Select COUNT(*) from UserRegistration where Email=@Email and Password=@Password   
9. end  
10. ---------------------------------
11. Clicking on Login button
12. 
    
13. protected void btnLogin_Click(object sender, EventArgs e)  
14.         {  
15.               
16.             string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;  
17.             using (SqlConnection con=new SqlConnection(CS))  
18.             {  
19.                 SqlCommand cmd = new SqlCommand("spLogin", con);  
20.                 cmd.CommandType = CommandType.StoredProcedure;  
21.                 con.Open();  
22.                 cmd.Parameters.AddWithValue("@Email",txtEmail.Text.Trim());  
23.                 cmd.Parameters.AddWithValue("@Password", Decrypt(txtPassword.Text.Trim()));  
24.                 int Username = (Int32)cmd.ExecuteScalar();  
25.                 if (Username == 1)  
26.                 {  
27.                     Session["Username"] = txtEmail.Text;  
28.                     Response.Redirect("Welcome.aspx");  
29.                     Session.RemoveAll();  
30.                       
31.                 }  
32.                 else  
33.                 {  
34.                     lblMessage.ForeColor = System.Drawing.Color.Red;  
35.                     lblMessage.Text = "Invalid username and password";  
36.                 }  
37.             }  
38.         } 
39. reference:- https://www.c-sharpcorner.com/blogs/how-to-login-with-encrypted-password-in-asp-net
40. https://www.c-sharpcorner.com/blogs/how-to-create-user-registration-form-with-encrypted-password-using-asp-net#ReadAndPostComment