My Doubt?

Question

I need how to Create Three Tire Architecture Simple Application. Please Send me With Example. Thanks&Regs Magesh.A

MuthuMari M · Answer

Hi , You have to follow this procedure , first you have to create sp then create one class files , inside this class to write coding for connetion strings , datareader, dataadapter functions. then you call this function in ur UI. For ex. write this coding in a class files Function getAdapter(ByVal sql As String) As SQl.SqlDataAdapter adpt = New SQl.SqlDataAdapter(sql, connection) Return adpt End Function Function getDataTable(ByVal sql As String) As DataTable ds = New DataSet Dim adpt As SQl.SqlDataAdapter = getAdapter(sql) adpt.Fill(ds) con.Close() Return ds.Tables(0) End Function then you have to call this in your UI . Thanks! If this post is useful then mark it as " Accepted Answer "

Krishna Garad · Answer

Hi Mangesh Check this link to get the data from database using 3-tier.

Senthilkumar · Answer

Hi, Its simple to create and you can do it by yourselves. There are three tier. 1) Presentation or UI layer 2) Business layer 3) Data Access Layer This is client-middleware-server architecture model. You need three layers. Presentation layer is nothing but the .aspx pages, which will be displayed in the client browser. When you create the web sites it will show the .aspx pages under the solution. Business or middleware layer interacts with the presentation and data access layer. You can create the class library project and it allows you to add as many as classes for writing the business logics. Data Access layer is used to write the logic to query the data from the database and interact with the database. The UI layer interacts to business layer and it will talk with the data layer. You can create this as separate project. For more info: http://geekswithblogs.net/edison/archive/2009/04/05/a-simple-3-tier-layers-application-in-asp.net.aspx http://www.dotnetfunda.com/articles/article71.aspx

magesh manavalan · Answer

Its ok. i don't know this concepts app so pls send me simple one application.

MuthuMari M · Answer

Hi magesh, Concepts: The presentation tier contains the UI (User Interface) elements of the site, and includes all the logic that manages the interaction between the visitor and the client's business. ( ASP.NET Web Forms,Web User Controls,ASP.NET Master Pages ) The business tier receives requests from the presentation tier and returns a result to the presentation tier depending on the business logic it contains. ( C# Classes ) The data tier is responsible for storing the application's data and sending it to the business tier when requested. ( SQL Server Stored Procedures ) Pls refer this url , for samples http://geekswithblogs.net/edison/archive/2009/04/05/a-simple-3-tier-layers-application-in-asp.net.aspx Hope this help you. If this post is useful then mark it as " Accepted Answer "

My Doubt?

Answers (5)