Login page using 3-Tier Architecture in ASP.Net

— June 2, 2019 in Asp.Net • 13 comments

This tutorial explains how to implement a Login page using 3-Tier Architecture in ASP.Net. I have described it in details. You will also get many new and known concepts to learn in this article whether on the SQL Server Query or C# code side.

In previous tutorial we have learn How to create a login page using asp.net mvc

Step :1  Open visual studio and create asp.net web project then create the sql server database with login table.in login table add field name and password

Step :2  Now you can add class DAL.CS  this class is known as first tier means it is data access layer

public class DAL
{
public int id { get; set; }
public string name { get; set; }
public string password { get; set; }
public string city { get; set; }

}

Step 3 :  Now you can add another Class BAL.CS this class known as Logical layer, here we can write the business query for for check login name and password is correct or not

public class BAL
{
SqlConnection con = new SqlConnection(@”Data Source=.\SQ;User Instance=True”);

public DataTable login_data(DAL da)
{
DataTable dt = new DataTable();

SqlDataAdapter sda = new SqlDataAdapter(“select * from user_master where name='” + da.name + “‘and password='” + da.password + “‘”, con);

sda.Fill(dt);

return dt;
}

Step 4 :  Now you can Add WebForm and Give name SignIn.aspx  then add two TextBox and Submit Button & add Code in CodeBehind file.

public partial class SignIn : System.Web.UI.Page
{
DAL da = new DAL();
BAL ba = new BAL();
DataTable dt=new DataTable();
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
da.name = TextBox1.Text;
da.password = TextBox2.Text;
dt = ba.login_data(da);
if (dt.Rows.Count > 0)
{
Response.Redirect(“home.aspx”);
}
else
{
Response.Write(“<script>alert(‘Not Valid User…….’)</script>”);
}
}

When you enter user name and password in Textbox & if user name and password are correct then it redirect to Home.aspx page if name & password are incorrect it display alert massage “Not Valid User…….“.

Login page using 3-Tier Architecture in ASP.Net

SEE MORE

  1. Auto Refresh Partial View in ASP.NET MVC
  2. What is ASP.NET Core
  3. Difference between TempData keep() And Peek() in Asp.Net MVC
  4. Difference between viewbag,viewdata and tempdata in asp.net mvc
  5. ASP.NET MVC With AngularJS
  6. Retrieving Data Using Form Collection and Inserting Into ASP.Net MVC
  7. MVC CRUD Operations Using Entity Framework
  8. Search Functionality in ASP.NET MVC
  9. How to create a User Registration page using asp.net mvc
  10. Store Multiple Checkbox state from cookie using Jquery
  11. Cascading Dropdownlist using Ajax in Asp.Net Mvc with city state country
  12. Insert, Update, Delete In GridView Using ASP.Net C#
  13. Binding Dropdownlist With Database In Asp.Net MVC
  14. Search and Filter data in Gridview using Asp.net MVC
  15. Select Insert, Update And Delete With ASP.NET MVC
  16. Display Data in GridView Using Asp.net MVC
  17. Validation in ASP.NET MVC Razor view
  18. CRUD Operation Using 3-Tier Architecture In ASP.NET
  19. How to get Connection String from Web.Config in Asp.Net C#
  20. Login page using 3-Tier Architecture in ASP.Net
  21. Asp.Net Image Upload in 3-Tier Architecture and store in sql database