3-tier architecture code sample for


  • send me code sample for 3-tier architectrue in using sql server  for insert,delete,update,find,select commands

    2.what is meant for pooling ?

    Tuesday, August 08, 2006 4:48 AM


All replies

  • PLEASE ...

    Have a look at

    You should find most of your are looking for ..

    Other interesting areas to look at are going to be generating data layer dynamically...

    Pooling connections.. is that what you are asking ?

    Tuesday, August 08, 2006 7:46 PM
  • tier nowadays refer to physical separations and a good example is Rocky Lhotka's CSLA framework.
    Monday, August 28, 2006 10:22 AM
  • If you are running Visual Studio 2005 then just go to the Start Page and look at the articles.  The first four items are building a 3 tier application.
    Friday, October 06, 2006 4:50 PM

    send me code sample for 3-tier architectrue in using sql server  for insert,delete,update,find,select commands

    Wednesday, November 21, 2007 5:05 AM
  • If you are still looking for the n-tier architecture tutorial with source code and downloadable demo project, Please go through this article



    Sunday, November 25, 2007 2:15 PM
  • I think this is what you are looking for.


    A Complete 3-tier tutorials with source code (copy-paste) including insert, delete, update, load functionality in 3-tier architecture is available at


    I am sure this will help you.

    Tuesday, May 06, 2008 5:36 AM
  • These layers are described below.

    1. Application layer or Business layer
    2. Business layer
    a. Property layer(Sub layer of business layer)
    3. data layer
    Advantages of three Tier Architecture.

    The main characteristic of a Host Architecture is that the application and databases reside on the same host computer and the user interacts with the host using an unfriendly and dump terminal. This architecture does not support distributed computing (the host applications are not able to connect a database of a strategically allied partner). Some managers found that developing a host application take too long and it is expensive. Consequently led these disadvantages to Client-Server architecture.

    Client-Server architecture is 2-Tier architecture because the client does not distinguish between Presentation layer and business layer. The increasing demands on GUI controls caused difficulty to manage the mixture of source code from GUI and Business Logic (Spaghetti Code). Further, Client Server Architecture does not support enough the Change Management. Let suppose that the government increases the Entertainment tax rate from 4% to 8 %, then in the Client-Server case, we have to send an update to each clients and they must update synchronously on a specific time otherwise we may store invalid or wrong information. The Client-Server Architecture is also a burden to network traffic and resources. Let us assume that about five hundred clients are working on a data server then we will have five hundred ODBC connections and several ruffian record sets, which must be transported from the server to the clients (because the Business layer is stayed in the client side). The fact that Client-Server does not have any caching facilities like in ASP.NET, caused additional traffic in the network. Normally, a server has a better hardware than client therefore it is able compute algorithms faster than a client, so this fact is also an additional pro argument for the 3.Tier Architecture. This categorization of the application makes the function more reusable easily and it becomes too easy to find the functions which have been written previously. If programmer wants to make further update in the application then he easily can understand the previous written code and can update easily.
    Application layer or Presentation layer

    Application layer is the form which provides the user interface to either programmer of end user. Programmer uses this layer for designing purpose and to get or set the data back and forth.
    Business layer

    This layer is a class which we use to write the function which works as a mediator to transfer the data from Application or presentation layer data layer. In the three tier architecture we never let the data access layer to interact with the presentation layer.
    a. Property Layer

    This layer is also a class where we declare the variable corresponding to the fields of the database which can be required for the application and make the properties so that we can get or set the data using these properties into the variables. These properties are public so that we can access its values.
    Data Access Layer

    This layer is also a class which we use to get or set the data to the database back and forth. This layer only interacts with the database. We write the database queries or use stored procedures to access the data from the database or to perform any operation to the database.


    Application layer is the form where we design using the controls like textbox, labels, command buttons etc.

    Business layer is the class where we write the functions which get the data from the application layer and passes through the data access layer.

    Data layer is also the class which gets the data from the business layer and sends it to the database or gets the data from the database and sends it to the business layer.

    Property layer is the sub layer of the business layer in which we make the properties to sent or get the values from the application layer. These properties help to sustain the value in a object so that we can get these values till the object destroy.

    Data flow from application layer to data layer

    You can download sample three tier project, used for this tutorial. Here we are passing the code of the student to the business layer and on the behalf of that getting the data from the database which is being displayed on the application layer.

    Presentation Layer:

    private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
    // Object of the Property layer
    clsStudent objproperty=new clsStudent();

    // Object of the business layer
    clsStudentInfo objbs=new clsStudentInfo(); 

    // Object of the dataset in which we receive the data sent by the business layer
    DataSet ds=new DataSet(); 

    // here we are placing the value in the property “ID” using the object of the 
    property layer[1].Text.ToString());

    // In ths following code we are calling a function from the business layer and passing the object of the property layer which will carry the ID till the 

    // What ever the data has been returned by the above function into the dataset is
    being populate through the presentation laye.

    Property Layer

    // These are the properties has been defined in the property layer. Using the object of the property layer we can set or get the data to or from these properties.
    public class clsStudent // Class for Student Table
    private int _id;
    private string _Name;
    private string _Address;
    private string _Email;
    private string _Picture;

    public int id // Property to set or get the value into _id variable
    get{return _id;}

    public string Name
    get{return _Name;}

    public string Address
    get{return _Address;}

    public string Email
    get{return _Email;}

    public string Picture
    get{return _Picture;}
    set{ _Picture=value;}

    Business Layer:

    "Obj" is the object of the clsStudent class has been defined in the property layer. This function is receiving the property object and passing it to the datalayer class

    // this is the function of the business layer which accepts the data from the application layer and passes it to the data layer.

    public class clsStudentInfo
    public DataSet GetAllStudentBsIDWise(clsStudent obj)
    DataSet ds=new DataSet();
    ds=objdt.getdata_dtIDWise(obj);// Calling of Data layer function
    return ds; 

    Datalayer Layer

    // this is the datalayer function which is receiving the data from the business layer and
    performing the required operation into the database

    public class clsStudentData // Data layer class
    public DataSet getdata_dtIDWise(clsStudent obj) // object of property layer class
    DataSet ds;
    string sql;
    sql="select * from student where StudentId="" order by StudentId";
    ds=new DataSet();
    // this is the datalayer function which accepts trhe sql query and performs the
    corresponding operation
    return ds;

    This is the implementation of the single function for more please see the sample application attached with the note.

    Monday, August 02, 2010 9:08 AM
  • nice one i think it gave good view to architectural view
    Tuesday, August 03, 2010 10:10 AM
  • Hi Guys,

    Is there some n-tier app sample out there that actually does NOT use datasets?? something that passes a "object", like a "client" between the layers.


     EDIT: something like this, but with more than ONE entity. I.E, A client with Banking details and/or a client with addresses.!EC564270211A8F9C!201.entry



    Object Layer:

    Class aClient


      String ClientName;

      String Clientsurname



    Business Layer:

    Class aClientBL


      public static aClient GetClient (int aClientID)


          return aClientDB.Getclient(aClientID);




    Data Layer:

    Class aClientDB


      public static aClient getClient(int aClientID)


           //run SP

          return aClient;


      public static bool SaveClient(aClient theClient)


           //run SP

           return true;



    Friday, August 13, 2010 5:30 PM
  • Hi Megastar,

    You can find all the detail about 3-tire architecture.

    With Sample source code at below link.


    Friday, January 21, 2011 9:17 AM
  • I would like to pay great thank to Sheo Narayan in order to share such a helpful link

    Thanks once again SHeo sahb

    Friday, March 25, 2011 3:06 PM
  • This is very helpful to me.......for better understanding of three tier architecture you can visit following link....
    Tuesday, April 05, 2011 6:11 AM
  • This is very helpful to me.......for better understanding of three tier architecture you can visit following link....
    Tuesday, April 05, 2011 6:11 AM
  • This is very helpful to me.......for better understanding of three tier architecture you can visit following link....
    Tuesday, April 05, 2011 6:13 AM
  • for better and easy understanding of three tier architecture you can visit following link....
    Tuesday, April 05, 2011 6:17 AM
  • Visit below link for answer. This contains a sample architecture.




    Monday, August 29, 2011 9:27 AM
  • Please refer my article in , you can download sample application 
    Tuesday, January 17, 2012 2:09 AM
  • Hi,

    I have gone through your article.

    Its implemented in 3-layered architecture.

    There is a difference between 3-tier and 3 layer.

    I want any example in 3 tier


    Wednesday, February 08, 2012 8:31 AM
    • Proposed as answer by hfofaria Monday, June 02, 2014 6:56 AM
    Thursday, March 22, 2012 2:36 PM
  • Hello,
       3 Tier Architecture is consisting of 3 essential components as following:

    1. Presentation layer
    2. Business Logic Layer
    3. Data Access layer

    Above 3 layers should work seamlessly, above all 3 layers are inter connected.

    When are we going to design then it should connect with each other and finally 3 component (DLLs) are generated in "Bin" folder.

    I am providing you 2 precious link who provides guidelines step by step as following:

    1. 3 Tier Architecture in

    2. 3 Tier Architecture

    Hope it will help you!!!


    Sunday, December 15, 2013 7:42 AM