How to write the code in simple program in 3tier archetecture.and what will write in button clickevent

Hello Ranjan... A 3 Tier Architecture basically divides the project into 3 parts...

1. DAL(Data Access Layer) - here you will contain code which connects to the Data Source(Database).

2. BOL(Business Object Layer) - here you will contain the logic where you will interact with the DAL and get values in some methods.

3. UI Layer(User Interface Layer) - This layer will basically contain all the aspx pages and the logic for that particular page.

Example:

Suppose your DAL has a Class called "ClsConnection.cs"

ClsConnection.cs:

using System;

using System.Data;

using System.Configuration;

using System.Data.SqlClient;

public class ClsConnection

{

public static int QueryExecution(commandtext)

{

SqlConnection con = new SqlConnection("Connection String");

SqlCommand cmd = new SqlCOmmand(commandtext, con);

int value = cmd.ExecuteNonQuery();

return value;

}

}

Suppose your BOL has a Class called "GetIntValues.cs"

GetIntValues.cs

using System;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using YourSolutionName.DAL;

public class GetIntValues

{

public static int getValues()

{

int TotalValues = ClsConnection.QueryExecution("Select count(*) from TableName");

return TotalValues;

}

}

Suppose your UI Layer has a page called "ShowIntValues.aspx"

So in the Code file you can show the value something like this...

using System;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using YourSolutionName.BOL;

protected void btnLogin_Click(object sender, EventArgs e)

{

lblValue.Text = Convert.ToString(GetIntValues.getValues());

}

PLEASE MARK THE ANSWER AS ACCEPTED IF IT HELPED YOU!!!

Nice demo to understand