Main Menu
3 Tier Architecture In .net Pdf
суббота 25 апреля admin 25
What is N-Tier?
An N-Tier Application program is one that is distributed among three or more separate computers in a distributed network.
Step 3 Now before going to the coding lets create the three tier structure so that it would be easier to understand for beginner programmers. Add a new Class library to the solution by going to File - Add - New project 2. Select the class library and name it ThreeTierVB.BusinessLogic. Layer architectures are essentially objects and work in object oriented environment just like asp.net. 3-tier architecture is a very well known architecture in the.
The most common form of n-tier is the 3-tier Application, and it is classified into three categories.
- User interface programming in the user's computer
- Business logic in a more centralized computer, and
- Required data in a computer that manages a database.
This architecture model provides Software Developers to create Reusable application/systems with maximum flexibility.
In N-tier, 'N' refers to a number of tiers or layers are being used like – 2-tier, 3-tier or 4-tier, etc. It is also called “Multi-TierArchitecture”.
The n-tier architecture is an industry-proven software architecture model. It is suitable to support enterprise level client-server applications by providing solutions to scalability, security, fault tolerance, reusability, and maintainability. It helps developers to create flexible and reusable applications.
In this tutorial, you will learn-
N-Tier Architecture
A diagrammatic representation of an n-tier system depicts here – presentation, application, and database layers.
These three layers can be further subdivided into different sub-layers depending on the requirements.
Some of the popular sites who have applied this architecture are
- MakeMyTrip.com
- Sales Force enterprise application
- Indian Railways – IRCTC
- Amazon.com, etc.
Some common terms to remember, so as to understand the concept more clearly.
- Distributed Network: It is a network architecture, where the components located at network computers coordinate and communicate their actions only by passing messages. It is a collection of multiple systems situated at different nodes but appears to the user as a single system.
- It provides a single data communication network which can be managed separately by different networks.
- An example of Distributed Network– where different clients are connected within LAN architecture on one side and on the other side they are connected to high-speed switches along with a rack of servers containing service nodes.
- Client-Server Architecture: It is an architecture model where the client (one program) requests a service from a server (another program) i.e. It is a request-response service provided over the internet or through an intranet.
In this model, Client will serve as one set of program/code which executes a set of actions over the network. While Server, on the other hand, is a set of another program, which sends the result sets to the client system as requested.
- In this, client computer provides an interface to an end user to request a service or a resource from a server and on the other hand server then processes the request and displays the result to the end user.
- An example of Client-Server Model– an ATM machine. A bank is the server for processing the application within the large customer databases and ATM machine is the client having a user interface with some simple application processing.
- Platform: In computer science or software industry, a platform is a system on which applications program can run. It consists of a combination of hardware and software that have a built-in instruction for a processors/microprocessors to perform specific operations.
- In more simple words, the platform is a system or a base where any applications can run and execute to obtain a specific task.
- An example of Platform – A personal machine loaded with Windows 2000 or Mac OS X as examples of 2 different platforms.
- Database: It is a collection of information in an organized way so that it can be easily accessed, managed and updated.
- Examples of Database – MySQL, SQL Server, and Oracle Database are some common Db's.
Types of N-Tier Architectures
There are different types of N-Tier Architectures, like 3-tier Architecture, 2-Tier Architecture and 1- Tier Architecture.
First, we will see 3-tier Architecture, which is very important.
Marianne faithfull broken english deluxe torrent free. Released in 1979 following periods of homelessness, heroin addiction, and scandal, Marianne Faithfull's opus recovered her from exile and captured a generation's disillusioned comedown. Marianne Faithfull - Broken English by me. Topics Marianne Faithfull, Broken English. Marianne Faithfull - Broken English 1 - Broken English. Addeddate 2013-03-09 22:07:01 Identifier. TORRENT download. Download 1 file. VBR M3U download. Download 1 file. Marianne Torrent Results: Marianne & Leonard: Words of Love 1 hour(s) and 42 minutes - Movie - 2019 An in-depth look at the relationship between the late musician Leonard Cohen and his Norwegian muse Marianne Ihlen. Download Marianne Faithfull Fast and for Free. Come and experience your torrent treasure chest right here. More Marianne Faithfull available on the site.
3-Tier Architecture
By looking at the below diagram, you can easily identify that 3-tier architecture has three different layers.
- Presentation layer
- Business Logic layer
- Database layer
Here we have taken a simple example of student form to understand all these three layers. It has information about a student like – Name, Address, Email, and Picture.
User Interface Layer or Presentation Layer
Presentation Layer
Code Explanation
- The above code defines the basic designing of a front end view of applications as well as calling of the functions of other layers so that they can be integrated with each other.
Business Access Layer -
This is the function of the business layer which accepts the data from the application layer and passes it to the data layer.
- Business logic acts as an interface between Client layer and Data Access Layer
- All business logic – like validation of data, calculations, data insertion/modification are written under business logic layer.
- It makes communication faster and easier between the client and data layer
- Defines a proper workflow activity that is necessary to complete a task.
Explanation of code
The code is using the function of business layer, which will accept the data for the application layer and passed it to the data layer. The Business layer codes act as a mediator between the functions defined in the presentation layer and data layer and calling the functions vice -versa.
Data Access Layer
This is the data layer function, which receives the data from the business layer and performs the necessary operation into the database.
Explanation of code
The code defines in dataset layer above accepts the entire request: requested by the system and performing the required operations into the database.
2-Tier Architecture:
It is like Client-Server architecture, where communication takes place between client and server.
In this type of software architecture, the presentation layer or user interface layer runs on the client side while dataset layer gets executed and stored on server side.
There is no Business logic layer or immediate layer in between client and server.
Single Tier or 1-Tier Architecture:
It is the simplest one as it is equivalent to running the application on the personal computer. All of the required components for an application to run are on a single application or server.
Presentation layer, Business logic layer, and data layer are all located on a single machine.
Advantages and Disadvantages of Multi-Tier Architectures
Advantages | Disadvantages |
|
|
|
|
| |
| |
| |
|
Hence, it is a part of a program which encrypts real-world business problems and determines how data can be updated, created, stored, or changed to get the complete task done.
N-Tier Architecture Tips and Development
Considering the software professionals must have a full control on all the layers of the architecture, tips on n-tier architecture are given as below
- Try to decouple layers from another layer as much as possible by using a technique like soap XML.
- Use some automated tools to generate a mapping between a business logic layer and a relational database layer (data layer). Tools that can help in modeling these mapping techniques are – Entity Framework and Hibernate for .Net etc.
- In client presenter layer, put a common code for all the clients in a separate library as much as possible. This will maximize the code reusability for all types of clients.
- A cache layer can be added into an existing layer to speed up the performance.
Summary:
Also, they will improve your performance and grades. Database management systems solutions manual 6th edition. FREE sample available for download. Most noteworthy, we do not restrict access to educators and teachers, as a result, students are allowed to get those manuals. Noteworthy, both students and instructors can obtain this Solutions Manual.
The N-tier architecture helps to manage all the components (business layer, presentation layer, and database layer) of an application under one roof.
Applications thatuses small numbers of users on a local area network can benefit from n-tier architecture.
Such architectural design ascertains maintaining, scaling up and deploying an application on the Internet efficiently.
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
1 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Like
ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL HOME ASP.NET AJAX GRIDVIEW JAVASCRIPT SQL JQUERY OOPS CONCEPTS INTERVIEW QUESTIONS Server,Ajax,SSRS, XML examples aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code 3 tier architecture example in asp.net examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies By: Suresh Dasari May 17, 2010
with C#
Follow @aspdotnetsuresh
5.7k
TRACE MOBILE NUMBER
2,443 followers
CONTACT
Search This Site
Categories: 3-TierArchitecture , Asp.net Search
Introduction Here I will explain about uses of 3-Tier architecture and how to create or implement 3-tier architecture for our project in asp.net Description 1. What is the use of 3-tier architecture and why we go for that architecture? 2. First we need to know what 3-Tier architecture is. 3. How to create 3-Tier architecture for our project? Uses of 3-Tier Architecture 1. To make application more understandable. 2. Easy to maintain, easy to modify application and we can maintain good look of architecture. If we use this 3-Tier application we can maintain our application in consistency manner. Basically 3-Tier architecture contains 3 layers
About Me
1. Application Layer or Presentation Layer 2. Business Access Layer(BAL) or Business Logic Layer(BLL) 3. Data Access Layer(DAL)
SUR ESH DA SA R I T E NA L I , A NDH R A PR A DESH , INDI A
Hi i am suresh dasari,software engineer working on
Here I will explain each layer with simple example that is User Registration
asp.net,c#.net,SQL Server.
Application Layer or Presentation Layer Presentation layer contains UI part of our application i.e., our aspx pages or input is taken from the user. This layer mainly used for design purpose and get or set the data back and forth. Here I have designed my registration aspx page like this
V I E W M Y COM P LE T E P ROFILE
Follow @aspdotnetsuresh Like
20
5.7k
Powered by
2,443 followers
Translate
2 This is Presentation Layer for our project Design your page like this and double click on button save now in code behind we need to write statements to insert data into database this entire process related to Business Logic Layer and Data Access Layer. Now we will discuss about Business Access Layer or Business Logic Layer Business Access Layer (BAL) or Business Logic Layer (BLL) This layer contains our business logic, calculations related with the data like insert data, retrieve data and validating the data. This acts as a interface between Application layer and Data Access Layer Now I will explain this business logic layer with my sample Recent Posts I have already finished form design (Application Layer) now I need to insert user details into database if user click on button save. Here user entering details regarding Username, password, Firstname, Lastname, Email, phone no, Location. I need to insert all these 7 parameters to database. Here we are placing all of our database actions into data access layer (DAL) in this case we need to pass all these 7 parameters to data access layers. In this situation we will write one function and we will pass these 7 parameters to function like this String Username= InserDetails (string Username, string Password, string Email, string Firstname,
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
2 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
string Lastname, string phnno, string Location) If we need this functionality in another button click there also we need to declare the parameters like string Username, string Password like this rite. If we place all these parameters into one place and use these parameters to pass values from application layer to data access layer by using single object to whenever we require how much coding will reduce think about it for this reason we will create entity layer or property layer this layer comes under sub of group of our Business Logic layer Don't get confuse just follow my instructions enough How we have to create entity layer it is very simple Right click on your project web application---> select add new item ----> select class file in wizard ---> give name as BEL.CS because here I am using this name click ok Open the BEL.CS class file declare the parameters like this in entity layer Don’t worry about code it’s very simple for looking it’s very big nothing is there just parameters declaration that’s all check I have declared whatever the parameters I need to pass to data access layer I have declared those parameters only BEL.CS
#region Variables /// <summary> /// User Registration Variables /// private string _UserName; private string _Password; private string _FirstName; private string _LastName; private string _Email; private string _Phoneno; private string _Location; private string _Created_By; #endregion /// <summary> /// Gets or sets the _UserName attribute value. /// ///The _UserName attribute value. public string UserName { get { return _UserName; } set { _UserName = value; } } /// <summary> /// Gets or sets the _Password attribute value. /// /// The _Password attribute value. public string Password { get { return _Password; } set { _Password = value; } } /// <summary> /// Gets or sets the _FirstName attribute value. /// /// The _FirstName attribute value. public string FirstName { get { return _FirstName; } set { _FirstName = value; } } /// <summary> /// Gets or sets the _LastName attribute value. /// /// The _LastName attribute value. public string LastName { get
jQuery Show Gridview Row Details in Tooltip on MouseHover in.. More » JavaScript - Convert JSON String to JSON Object More » C# - Convert Datatable to JSON String in C#, VB.NET More » Get Title and Description of URL in Asp.net Like Facebook More » Asp.net Show Multiple Markers on Google Map V3 from Database.. More » Get LinkedIn Logged in User Details(Name,Email, Url, Profile.. More » Need Your Help Please vote for me More » Adding Linkedin Login Button to Website using JavaScript API.. More » Move Selected Gridview Rows to Another Gridview in Asp.net More » 8 jQuery Best HTML5 Audio Player Plugins Examples with Tutor.. More »
We're on
+563
Find us on Facebook Aspdotnetsuresh Like 5,762 people like Aspdotnetsuresh.
Facebook social plugin
Get Latest articles in your inbox for free. Enter your email address:
Subscribe
Blog Archive ► 2013 ( 153 ) ► 2012 ( 301 ) ► 2011 ( 131 ) ▼ 2010 ( 77 ) ► December ( 20 ) ► November ( 5 ) ► October ( 11 ) ► September ( 14 ) ► August ( 8 ) ► July ( 1 ) ► June ( 2 ) ▼ May ( 4 ) 3 tier architecture example in asp.net with C#
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
3 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
{ return _LastName; } set { _LastName = value; } } /// <summary> /// Gets or sets the _Email attribute value. /// ///The _Email attribute value. public string Email { get { return _Email; } set { _Email = value; } }
WPF (Windows Presentation Foundation) in .NET Cursors in SQL Server Publishing Web Site in asp.net ► April ( 12 )
Categories Asp.net ( 421 ) General ( 269 ) JQuery ( 190 ) Code Snippets ( 96 ) Javascript ( 82 ) SQL Server ( 82 ) Gridview ( 75 ) C#.Net ( 68 ) VB.NET ( 56 ) JQuery Plugins ( 45 ) Errors ( 36 ) Ajax ( 31 ) Interview Questions ( 30 ) DropdownList ( 18 )
/// <summary> /// Gets or sets the _Phoneno attribute value. /// ///The _Phoneno attribute value. public string Phoneno { get { return _Phoneno; } set { _Phoneno = value; } }
Authentication ( 16 )
/// <summary> /// Gets or sets the _Location attribute value. /// ///The _Location attribute value. public string Location { get { return _Location; } set { _Location = value; } }
AutoComplete ( 7 )
/// <summary> /// Gets or sets the _Created_By attribute value. /// ///The _Created_By attribute value. public string Created_By { get { return _Created_By; } set { _Created_By = value; }
DatePicker ( 15 ) Fileupload ( 15 ) SharePoint ( 15 ) validations ( 15 ) Membership ( 14 ) Google API ( 12 ) IISServer ( 12 ) JSON ( 12 ) Crystal Reports ( 11 ) Google MAPS ( 11 ) CSS ( 10 ) SendMail ( 8 )
ExcelSheet ( 7 ) InternetTips ( 7 ) ToolTip ( 7 ) AjaxModalPopupExtender ( 6 ) Menu ( 6 ) SQL Joins ( 6 ) SlideShow ( 6 ) Windows Application ( 6 ) XML ( 6 ) CheckBox ( 5 ) DataList ( 5 ) ExportGridviewData ( 5 ) Modalpopup ( 5 ) WebService ( 5 ) Dynamic Controls ( 4 ) Facebook ( 4 ) Twitter ( 4 ) WCF ( 4 ) Windows Service ( 4 ) YouTube ( 4 ) jQuery Menu ( 4 ) jQuery UI ( 4 ) Accordion Menu ( 3 ) AjaxAsyncFileUpload ( 3 ) EncryptionandDecryption ( 3 ) LightBoxEffect ( 3 )
Our parameters declaration is finished now I need to create Business logic layer how I have create it follow same process for add one class file now give name called BLL.CS. Here one point don’t forget this layer will act as only mediator between application layer and data access layer based on this assume what this layer contains. Now I am writing the following BLL.CS(Business Logic layer)
OOPS Concepts ( 3 ) Visual Studio ( 3 ) ZIP UNZIP Files ( 3 ) web.config ( 3 ) 360 Degree View Plugins ( 2 )
#region Insert UserInformationDetails /// <summary> /// Insert UserDetails /// /// <param name='objUserBEL'> /// public string InsertUserDetails(BEL objUserDetails) { DAL objUserDAL = new DAL(); try { return objUserDAL.InsertUserInformation(objUserDetails);
AjaxAutoCompleteExtender ( 2 ) AjaxTabContainer ( 2 ) Blog Statistics ( 2 ) Flip Effect ( 2 ) Global.asax ( 2 ) Linkedin ( 2 ) MultilineTextbox ( 2 ) News Ticker in jQuery ( 2 ) Progressbar ( 2 ) SSRS ( 2 )
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
4 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
} catch (Exception ex) { throw ex; } finally { objUserDAL = null; } } #endregion Here if you observe above code you will get doubt regarding these what is BEL objUserDetails DAL objUserDAL = new DAL();
Session Timeout ( 2 ) ThumbnailsGeneration ( 2 ) UserName Check ( 2 ) jQuery Media Plugins ( 2 ) 3-TierArchitecture ( 1 ) ADO.NET ( 1 ) AbstractVsInterface ( 1 ) ActiveDirectory ( 1 ) Advertise ( 1 ) Ajax Calendarextender ( 1 ) Ajax ConfirmbuttonExtender ( 1 ) AjaxAccordionControl ( 1 ) AjaxCalendarExtender ( 1 ) AjaxCollapsiblePanelControl ( 1 )
and how this method comes
AjaxDragPanelExtender ( 1 ) AjaxPasswordStrength ( 1 )
return objUserDAL.InsertUserInformation(objUserDetails); Here BEL objUserDetails means we already created one class file called BEL.CS with some parameters have you got it now I am passing all these parameters to Data access Layer by simply create one object for our BEL class file
AjaxRatingControl ( 1 ) AjaxSlideshowExtender ( 1 ) Arraylist ( 1 ) Assembly ( 1 ) Authorization ( 1 )
What is about these statements I will explain about it in data access layer DAL objUserDAL = new DAL(); return objUserDAL.InsertUserInformation(objUserDetails);
Average rating ( 1 ) Chatting Plugins ( 1 ) CheckBoxList ( 1 ) CodingStandards ( 1 )
this DAL related our Data access layer. Check below information to know about that function and Data access layer
Custom Right Click Menu ( 1 )
Data Access Layer(DAL)
Fixed Header on Scroll ( 1 )
DataGrid ( 1 )
Generic List ( 1 )
Data Access Layer contains methods to connect with database and to perform insert,update,delete,get data from database based on our input data I think it’s to much data now directly I will enter into DAL
HTML ( 1 ) IP Address ( 1 ) ImportContacts ( 1 ) KeyBoard Key Codes ( 1 )
Create one more class file like same as above process and give name as DAL.CS
ListBox ( 1 ) MCC Award ( 1 )
Write the following code in DAL class file
PDF Viewers ( 1 ) Panorama Image Viewer Plugins ( 1 )
//SQL Connection string string ConnectionString = ConfigurationManager.AppSettings['LocalConnection'].ToString();
QueryString ( 1 ) RSSFeeds ( 1 ) RadioButtonList ( 1 )
#region Insert User Details /// <summary> /// Insert Job Details /// /// <param name='objBELJobs'> /// public string InsertUserInformation(BEL objBELUserDetails) { SqlConnection con = new SqlConnection(ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand('sp_userinformation', con); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.AddWithValue('@UserName',objBELUserDetails.UserName); cmd.Parameters.AddWithValue('@Password', objBELUserDetails.Password); cmd.Parameters.AddWithValue('@FirstName', objBELUserDetails.FirstName); cmd.Parameters.AddWithValue('@LastName', objBELUserDetails.LastName); cmd.Parameters.AddWithValue('@Email', objBELUserDetails.Email); cmd.Parameters.AddWithValue('@PhoneNo', objBELUserDetails.Phoneno); cmd.Parameters.AddWithValue('@Location', objBELUserDetails.Location); cmd.Parameters.AddWithValue('@Created_By', objBELUserDetails.Created_By); cmd.Parameters.Add('@ERROR', SqlDbType.Char, 500); cmd.Parameters['@ERROR'].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); string strMessage = (string) cmd.Parameters['@ERROR'].Value; con.Close(); return strMessage; } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } } #endregion
Read/Write text file ( 1 ) ReadOnlyValues ( 1 ) Repeater ( 1 ) Resize Image ( 1 ) RichTextBox ( 1 ) SQL Constraints ( 1 ) SiteMap ( 1 ) Social Media Bookmark Plugins ( 1 ) Spell Checker ( 1 ) Testing ( 1 ) Trace Mobile Number ( 1 ) Try Catch ( 1 ) UpdatePanel ( 1 ) VBScript ( 1 ) Virtual Keyboard ( 1 ) WPF ( 1 ) jQuery Audio Plugins ( 1 ) jQuery Mobile ( 1 ) jQuery Video Plugins ( 1 ) scroll top/bottom of div ( 1 ) setInterval ( 1 )
Here if you observe above functionality I am getting all the parameters by simply creating BEL
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
5 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
objBELUserDetails. If we create one entity file we can access all parameters through out our project by simply creation of one object for that entity class based on this we can reduce redundancy of code and increase re usability Observe above code have u seen this function before? in BLL.CS i said i will explain it later got it in DAL.CS I have created one function InsertUserInformation and using this one in BLL.CS by simply creating one object of DAL in BLL.CS. Here you will get one doubt that is why BLL.CS we can use this DAL.CS directly into our code behind we already discuss Business logic layer provide interface between DAL and Application layer by using this we can maintain consistency to our application. Now our Business Logic Layer is ready and our Data access layer is ready now how we can use this in our application layer write following code in your save button click like this
protected void btnsubmit_Click(object sender, EventArgs e) { string Output = string.Empty; if (txtpwd.Text txtcnmpwd.Text) { BEL objUserBEL = new BEL(); objUserBEL.UserName = txtuser.Text; objUserBEL.Password = txtpwd.Text; objUserBEL.FirstName = txtfname.Text; objUserBEL.LastName = txtlname.Text; objUserBEL.Email = txtEmail.Text; objUserBEL.Phoneno = txtphone.Text; objUserBEL.Location = txtlocation.Text; objUserBEL.Created_By = txtuser.Text; BLL objUserBLL = new BLL(); Output = objUserBLL.InsertUserDetails(objUserBEL); } else { Page.RegisterStartupScript('UserMsg', '<Script language='javascript'>alert(' + 'Password mismatch' + ');'); } lblErrorMsg.Text = Output; } Here if you observe I am passing all parameters using this BEL(Entity Layer) and we are calling the method InsertUserDetails by using this BLL(Business Logic Layer) Now run your applciation test with debugger you can get idea clearly. I hope it helps you.
Download sample code attached
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.
Like
5.7k
20
Follow @aspdotnetsuresh
Subscribe by RSS
Subscribe by Email
2,443 followers
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
6 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
126 comments : hyu said..
1
Your All Coding in Blogspot is meaningfull.Nice tutorial of 3-tiers for beginner. I Rate 5 Star
December 25, 2010 at 2:26 AM Suresh Dasari said..
2
thanks hyu keep visiting...
December 25, 2010 at 4:09 AM jooey said..
3
I am really impressed the way you make me understand.Thank you very much.Keep on bloging.
March 28, 2011 at 9:59 AM Suresh Dasari said..
4
thanks jooey
March 28, 2011 at 6:03 PM Anonymous said..
5
very nice
April 10, 2011 at 5:43 AM Anonymous said..
6
wheres d database?
September 3, 2011 at 12:02 AM Dejt Mi Chi said..
7
Hi, really great tutorial here. Before reading this I had some problems understanding when to use an entity layer or property layer. I noticed some tutorial used it, and some didnt. I believe you explained that part very clear here.
October 20, 2011 at 7:16 AM Anonymous said..
8
nice wesite suresh.
November 28, 2011 at 4:23 AM Anonymous said..
9
hi suresh tis site is very useful for me and all dotnet developers.thank u.
November 28, 2011 at 4:24 AM Pandoh kishan said..
10
HIIII WHAT AN IDEA SR GGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
December 23, 2011 at 11:31 PM Shruti said..
11
Hi suresh, very nice website and this topic is really very usefull.
December 26, 2011 at 1:59 AM Deepika said..
12
While visiting this site I'm getting interest towards subject.I feel thankful to you for that
February 15, 2012 at 10:45 PM Anonymous said..
13
Hai sir this rajesh from kakinada,iam working as .net developer ,Today i see the blog i am really impressed,this site is very usefull me.
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
7 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Sir this is mail id:[email protected] please send your mail id.
April 13, 2012 at 3:07 AM Mahesh said..
14
nice article very useful
April 18, 2012 at 7:31 AM sattar342 said..
15
Thank you very much Mr. Suresh
April 29, 2012 at 4:52 PM yashu said..
16
thanku ..
May 1, 2012 at 11:02 PM Anonymous said..
17
Hello Sir, Thanks .. It is very helpful for all ..Keep up your Good work. I am very impressed the way you are explaining.
May 23, 2012 at 10:52 PM Ram said..
18
Hi Suresh, Can you give one simple project for MVC3 application in Visual Studio 2010
May 29, 2012 at 4:29 AM Anonymous said..
19
where is database procedure..
July 3, 2012 at 5:17 AM Santhosh Kumar said..
20
thanks for your valuable information, it make ma to easy understand 3 tier architech. keep on rocks
July 22, 2012 at 11:22 PM Anonymous said..
21
What is need of private variables in BEL.cs as you are using public variables everywhere in your example?
July 24, 2012 at 12:06 AM Anonymous said..
22
Awesome.i was searching for such a good poast. thanks alot :)
July 26, 2012 at 11:02 PM pankaj khairanar said..
23
really nice article!
August 2, 2012 at 4:12 PM Susil singh said..
24
Sir, how to create database for this project? i m new in this field so please explain for creating database and how to connect.
August 2, 2012 at 7:47 PM Susil singh said..
25
Hi! Brothers, please tell me how to create database for this project.
August 2, 2012 at 7:51 PM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
8 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
ALOK NAYAK said..
26
Its really easy way to understand 3-tire Arch. I have already done but confused abt 3-tire. Thanks Suresh..
August 17, 2012 at 7:48 AM SHANKAR said..
27
Hello suresh p-lease save me..i have lots of confusion when i writting SP for this article..i am requested to you..please tell me key points to create proc for this app.thanks
August 18, 2012 at 9:42 AM Anonymous said..
28
Hi Suresh, While launching the applicaton, after entering the user details its giving me an error 'Procedure or function sp_userinformation has too many arguments specified.'
August 18, 2012 at 8:33 PM Harshu said..
29
Hi Suresh, While launching the applicaton, after entering the user details its giving me an error 'Procedure or function sp_userinformation has too many arguments specified.'
August 18, 2012 at 8:34 PM SHANKAR said..
30
Hello Anonymous for fixing that Bug we need to pass prameter for otput..here is the Proc for that app..after writing the code once test in sqlserver only then after write sp in DAL class. CREATE TABLE tbl_tier ( UserName VARCHAR(30), Password VARCHAR(30), FirstName VARCHAR(30), LastName VARCHAR(30), Email VARCHAR(30), Phoneno VARCHAR(30), Location VARCHAR(30), Created_By VARCHAR(30) ) ALTER PROC sp_userinformation ( @UserName VARCHAR(30), @Password VARCHAR(30), @FirstName VARCHAR(30), @LastName VARCHAR(30), @Email VARCHAR(30), @Phoneno VARCHAR(30), @Location VARCHAR(30), @Created_By VARCHAR(30), @ERROR VARCHAR(30) OUTPUT ) AS BEGIN INSERT INTO tbl_tier VALUES(@UserName,@Password,@FirstName,@LastName,@Email,@Phoneno,@Location,@Created_By) END
DECLARE @HN VARCHAR(30) EXEC sp_userinformation 'SHANKAR','12345','SHANKAR','PARSHIMONI','[email protected]','9966385883','HYDERABAD','SHANKAR', @[email protected] OUTPUT SELECT @HN
August 18, 2012 at 9:15 PM SHANKAR said..
31
hello suresh pls visit this site,i am getting one bug in BLL.cs file i,e Unable to cast object of type 'System.DBNull' to type 'System.String'..i have been fixing this bug but i coudn't do..so please drop you answer ..tanq
August 18, 2012 at 9:21 PM SHANKAR said..
32
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
9 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Hello friends finally i got final result in 3 tier architectur app.but i have taken only 3 controls.i have posted entire code including proc in my blogspot..so please click this link for further details http://www.shankar-mydotnetsite.blogspot.in/
August 19, 2012 at 1:49 AM Anonymous said..
33
Hi this post was very nice & 200% useful for 3Tier freshers including me. This shows your technical stuff as well as reputation. Iam expecting similar like this post for basic or freshers who are willing to learn mvc, because we & our blog fans need to update with current trend & technology. So, Please post mvc example. Thank you!
August 24, 2012 at 12:08 AM Sagar said..
34
Hi this post was very nice & 200% useful for 3Tier freshers including me. This shows your technical stuff as well as reputation. Iam expecting similar like this post for basic or freshers who are willing to learn mvc, because we & our blog fans need to update with current trend & technology. So, Please post mvc example. Thank you!
August 24, 2012 at 12:09 AM Uddhav Garkal said..
35
nice web site.. keep it up
August 28, 2012 at 12:45 AM Munavvar Patel said..
36
NOTICE BEL works just for calling method of DLL(realy overhead of coding and need one extra class). why can't we write(call dll method)in codebihind file(directly in button 'Click event')?
September 2, 2012 at 10:20 PM Anonymous said..
37
@Shankar - Kindly add the below line after the insert statement SET @ERROR ='success' to avoid casting error.
September 9, 2012 at 9:25 AM Anonymous said..
38
For a fresher like me it will be very helpful if you publish the entire code (ie), with stored procedures and database tables.
September 9, 2012 at 11:33 PM Anonymous said..
39
CREATE TABLE tbl_tier ( UserName VARCHAR(30), Password VARCHAR(30), FirstName VARCHAR(30), LastName VARCHAR(30), Email VARCHAR(30), Phoneno VARCHAR(30), Location VARCHAR(30), Created_By VARCHAR(30) ) ALTER PROC sp_userinformation ( @UserName VARCHAR(30), @Password VARCHAR(30), @FirstName VARCHAR(30), @LastName VARCHAR(30), @Email VARCHAR(30), @Phoneno VARCHAR(30), @Location VARCHAR(30), @Created_By VARCHAR(30), @ERROR VARCHAR(30) OUTPUT ) AS
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
10 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
BEGIN INSERT INTO tbl_tier VALUES(@UserName,@Password,@FirstName,@LastName,@Email,@Phoneno,@Location,@Created_By) SET @ERROR='Success' END the stored procedure should look like above. You need to pass the out parameter.
September 11, 2012 at 10:10 AM Anonymous said..
40
do i have to create a class for each table? i mean BEL class.
September 17, 2012 at 2:26 AM Sneha said..
41
Hey.dats a very easiest way you explained. really helpfull.
September 20, 2012 at 10:39 AM Anonymous said..
42
Very good artical sir ....
September 27, 2012 at 1:05 PM chothani punita said..
43
Awesome post.I got idea about the 3 tier architecture..thank u so much sir. I am going to develop a website----Online Examination System in asp.net with 3 tier architecture. Plz help me how can I do it as I new in asp.net, plz explain me in detail. Thanking u.
October 2, 2012 at 6:24 AM Anonymous said..
44
No need to add entity layer... BAL and DAL are enough..
October 8, 2012 at 10:51 PM Anonymous said..
45
where is the code for reset button? it is just to clear all the fields.....
October 8, 2012 at 10:57 PM Poonam said..
46
Vry nice description of 3 tier architecture for begginer. Thank u!!
October 10, 2012 at 6:11 AM Anonymous said..
47
GUD POST
October 16, 2012 at 4:47 AM Anonymous said..
48
gr8
October 16, 2012 at 6:11 AM vipin pandey said..
49
hi! suresh it'S very helpful but, please write the stored procdure of it. that'S awesome thank you sir
October 22, 2012 at 1:37 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
11 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Ameerpv said..
50
good information thank you
October 22, 2012 at 11:03 AM Anonymous said..
51
fabulous article . Got a clear picture regarding entity/property layer. Regards Raj
October 24, 2012 at 11:54 PM Anonymous said..
52
Niccceeeee bro.. easiest and best one from all
November 1, 2012 at 4:22 AM Anonymous said..
53
realy a nice tutorial i ever seen about three tier architecture....
November 3, 2012 at 1:01 AM JPEdwards said..
54
its very nice sir to understand easily i am thankful to u for that
November 11, 2012 at 10:08 AM ANOOP said..
55
haii.. this post is very helpful.. i want to learn more and i have some doubts. pls give me your mailid
November 15, 2012 at 9:31 PM Anonymous said..
56
Hi, I like your example of three tier example .It is very easy to understand . I have a request for you can you please tell me about stored Procedure ,So i can get best explanation. THANKS A LOT.And keep it up
November 22, 2012 at 3:01 AM Anonymous said..
57
HAI
in .aspx it show error at InsertUserDetails(objUserBEL); shos that 'BEL does not contain a definition for 'InsertUserDetails'and no extension method 'InsertUserDetails' accepting a first argument of type 'BEL' could be found
November 24, 2012 at 3:05 AM Anonymous said..
58
what is problem in this
November 24, 2012 at 3:06 AM chanti said..
59
suresh bhayya awesome simply code bhayya
November 28, 2012 at 12:18 AM sagar said..
60
Exactly good working by you guys.. keep it continues Thanks to understand 3 tier arch..
November 28, 2012 at 1:32 AM Anonymous said..
61
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
12 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
very nice Mr Suresh.. i like ur demo and code too.
November 29, 2012 at 5:05 AM Anonymous said..
62
Mr Harshu.pls check parameter which u passed.. so u can solve ur error..
November 29, 2012 at 5:07 AM Anonymous said..
63
Very good article I understood it given step by step..very useful
November 29, 2012 at 5:21 AM Anonymous said..
64
only the thing is can u provide this article without using out parameter it is difficult to understand fresher how the value is returned? to the BLL can you brief it? Thank in advance.
November 29, 2012 at 5:42 AM Anonymous said..
65
Thank u sir...:)
December 5, 2012 at 9:17 PM Anonymous said..
66
Nice article .Will you pls explain how to make 3-tier architecture?
December 6, 2012 at 10:48 PM Anonymous said..
67
can u please upload image to folder using this same method.. please
December 9, 2012 at 8:09 PM Anonymous said..
68
gud one..
December 10, 2012 at 11:34 PM Anonymous said..
69
nice.
December 11, 2012 at 4:50 AM Anonymous said..
70
December 13, 2012 at 5:20 AM Venkatesan K said..
71
hi Mr.suresh...... Its very helpful to me and i have a doubt? how can i insert the values in more than tables from windows form to database via DAL and BAL concept..Please Tell me and i am waiting for your ans
December 16, 2012 at 9:01 PM hima said..
72
thank u for sharing the articles...
December 20, 2012 at 8:26 AM Sandhya Reddy said..
73
Very clear for freshers....
December 21, 2012 at 10:40 PM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
13 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Sandhya Reddy said..
74
Very clear for freshers....
December 21, 2012 at 10:43 PM Ranga Rao said..
75
Hi suresh its a perfect 3 tier architecture code and very easy to understand. please mention connection string in web.config file. please send me how to update dropdownlist inside gridview inn rowupdating event includind database back up. My mail is [email protected]
December 28, 2012 at 10:46 PM Ranga Rao said..
76
Hi suresh its a perfect 3 tier architecture code and very easy to understand. please mention connection string in web.config file. please send me how to update dropdownlist inside gridview inn rowupdating event includind database back up. My mail is [email protected]
December 28, 2012 at 10:48 PM Anonymous said..
77
Hi Suresh this is a good example for but not for 3 tier
December 30, 2012 at 9:43 PM Anonymous said..
78
Hi Suresh this is a good example for 3 layer but not for 3 tier
December 30, 2012 at 9:46 PM Jatin said..
79
This comment has been removed by the author. January 3, 2013 at 2:15 AM Jatin said..
80
Suresh, u r really doing a nice job.
January 3, 2013 at 2:16 AM Jatin said..
81
your way of explanation is really easy and efficient. :)
January 3, 2013 at 2:18 AM Anonymous said..
82
Ya its good topic. But i have one doubt on 3 tier architecture. How to fill master and child table using 3 Tier architecture by using Transaction? Please send me answer to this mail id [email protected]
January 6, 2013 at 12:00 AM Anonymous said..
83
Jayant :gud 1 it actually made some thoughts clear
January 7, 2013 at 12:55 AM sureshbehera said..
84
its very valuable for me i want mvc demo project also plz plz plz send me on e-mail [email protected]
January 7, 2013 at 2:44 AM Anonymous said..
85
great
January 9, 2013 at 1:05 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
14 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Thatiboina Prasad said..
86
great
January 9, 2013 at 5:19 AM Anonymous said..
87
Really it is a very helpful artical for beginners and I got very much help from your article in our final year project.Thanks u mr.suresh and keep updating..
January 11, 2013 at 8:43 PM Anonymous said..
88
hai suresh.Is it mention any connectionstring in bll.i follow u r steps.when i am trying to execute 'The connectionstring property has not been initialized' error showing in bll.
January 17, 2013 at 11:31 PM Suneel Kumar said..
89
Hai Suresh, it is much useful for me.., And It is very easy to understand your presentation.
January 24, 2013 at 11:00 PM Ganesh Kumar said..
90
good blog sir. easy to understand. great job........
January 31, 2013 at 9:50 AM Ganesh Kumar said..
91
good blog sir. easy to understand. great job........
January 31, 2013 at 9:50 AM Anish Shaikh said..
92
Thanks..It is Useful for me..great explaination Thank U very Much.. :)
February 4, 2013 at 5:52 AM aspnet said..
93
thank you sir ,this is helpful content
February 6, 2013 at 7:42 PM Anonymous said..
94
Nice and Very Help Full Sir
February 6, 2013 at 11:36 PM Parthiban B said..
95
Thank you This is very helpful
February 8, 2013 at 9:49 PM Anonymous said..
96
u should be a great teacher.u explains in very simple manner so newer people can also get your blogs..thanks u
February 12, 2013 at 3:20 AM Shiva Katta said..
97
Clearly understood what is 3-tier atchitecture . Thank you .
February 15, 2013 at 1:15 AM edwin rajkumar said..
98
i want coding for sign out in 3 tier architecture with session concept
February 21, 2013 at 2:10 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
15 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Anonymous said..
99
Thanks Suresh, It is realy helpful information for any .net developer and the way you explained is simply awesome..!!
February 21, 2013 at 6:11 AM Jangu Phelix said..
100
Hi Suresh, I must say you are great. I visit your site almost daily, and learn at least something new everyday. Keep it up.
February 21, 2013 at 11:06 PM thinusha said..
101
Your All Coding in Blogspot is meaningfull.Nice tutorial of 3-tiers for beginner.
February 22, 2013 at 4:03 AM Megic Geeks Technology said..
102
Hello Suresh. it is really helpfull.. keep it up...
February 25, 2013 at 3:21 AM sunil kumar said..
103
VOUCHER: • VOUCHER NO (PK) (VAR 30) • DATE (VAR 10) • PAID TO (VAR 30) • AMOUNT (DOUBLE 30) • REASON (VAR 45) • AUTHORIAZED SIGNATURE (TEXT ) Voucher is the table and folling are the attribute now i want desining and store procedure with 3-tire architure with coding every thing Please help me out of the proble are mail me [email protected]
February 26, 2013 at 3:00 AM Vishal Jagani said..
104
Bhai. Suresh Thoda Easy Way me 3 Tire ka Coding Nahi Hai Kya ? Ye Samaj Me Nahi aa raha hai. Thoda samj me aye esa kucchhh Likho na pls yaar I m Fresher for 3 tier.. to kya aap kuchh Help Kar sakte ho
March 4, 2013 at 12:29 AM Hardik-Patel said..
105
nice sir its impressive and keep doing this type of stuff in easy manner. thanks a lot
March 10, 2013 at 3:54 AM pramod said..
106
hello my query is how to implement 3 tiers Architecture in whole asp.net project i.e if there is more than 10 form so how to implement 3 tiers architecture is there create each bal,dal for each databasse code please solve my query
March 10, 2013 at 11:49 PM Marees said..
107
Nice article .Will you pls explain how to make MVC 4 ?
March 13, 2013 at 6:18 AM Anonymous said..
108
nice
March 18, 2013 at 3:38 AM Anonymous said..
109
i got error in DAL.cs nullreference was unhandled by code in connectionstring
March 20, 2013 at 12:29 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
16 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
nandy said..
110
ERROR*** i have initialized my dal object to null in finally block, its showing error, ExecuteNonQuery: Connection property has not been initialized.
March 24, 2013 at 1:44 AM nandy said..
111
namespace BLclass { public class BLPerson { public string RegisterUser(PersonInfo entityObj) { PersonDALclass dalObj = new PersonDALclass(); try { return dalObj.RegisterUser(entityObj); } catch (Exception ex) { throw ex; } finally { dalObj = null; }
} } whats wrong in this code.
March 24, 2013 at 2:36 AM Kapil Jangra said..
112
thanks alot dear suresh for your fruitful postings.
March 31, 2013 at 10:01 PM Rajesh Narra said..
113
good post really it is very useful for everyone .thanks a lot .awesome work by you
April 5, 2013 at 11:50 PM Manpreet Kaur said..
114
in our webpage to bind textbox we do as textbox1.text what is the correct synatx for binding drop down list mail me on my id [email protected] urgent
April 15, 2013 at 5:48 AM Jeevanandam Jpd said..
115
Good Job Suresh....Awesome Explanation in all your tutorials..
April 16, 2013 at 3:54 AM seema darade said..
116
thanks..It's good explanation...
April 16, 2013 at 8:52 AM Anonymous said..
117
nice
April 25, 2013 at 4:44 AM Anonymous said..
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
17 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit.. 118
nice
April 25, 2013 at 4:45 AM Anonymous said..
119
I cannot access BEL in in DAL class.. i.e . I cannot write BEL b=new BEL() // Here BEL is not coming in intellisence ..
April 27, 2013 at 5:27 AM sundar neupane said..
120
So good site for us.thanks this site.
April 29, 2013 at 7:47 AM Pradeep said..
121
its very usefull to all
May 7, 2013 at 12:26 AM Anonymous said..
122
Good one,Very Useful
May 7, 2013 at 1:17 PM Web Master said..
123
Hi, DO I need to create seperate classes for each table in BEL class ?
May 8, 2013 at 3:17 AM Imtiyaz Jamadar said..
124
This is one of the best site I ever seen .
May 10, 2013 at 9:25 PM Bhusan said..
125
CODE FOR SAVING RADIO BUTTON (DAL,BAL & PRESENTATION LAYER)VALUE IN 3 TIER KINDLY REPLY
May 11, 2013 at 8:45 AM jackson said..
126
Thanks alot suresh.. awesome explanation.
May 15, 2013 at 9:37 AM
Give your Valuable Comments
Comment as:
Newer Post
Home
Older Post
Subscribe to: Post Comments ( Atom )
Other Related Posts Display Images in Asp.net Gridview from Database in C#, VB.NET .. Ajax Asynchronous File Upload Asp.net Example to Upload Files .. JavaScript - Show Number of Characters Remaining in .. - Asp.net Asp.net
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
18 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Cross Page Postback in Asp.net Example 2.0, 3.0, 3.5, 4.0 - ASP ..
Asp.net insert, Edit, update, delete data in gridview Introduction to Object Oriented Programming Concepts (OOPS) in C#.net Introduction to WCF - WCF tutorial WCF Tutorial - Windows Communication Foundation WCF Example WCF Sample code in asp.net 3.5 Basic WCF Tutorial for Beginners 3 tier architecture example in asp.net with C# how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and retrieve images from database using asp.net Simple login form example in asp.net Check Username and Password availability in database Interview Questions in ASP.NET,C#.NET,SQL Server,.NET Framework Ajax ModalPopUpExtender Example to edit the gridview row values in asp.net Ajax Cascading Dropdownlist Sample with database using asp.net how to save images into folder and images path in database and display images from folder in gridview based on images path in database using asp.net
© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved. The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.
17-05-2013 PM 02:23
1 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Like
ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL HOME ASP.NET AJAX GRIDVIEW JAVASCRIPT SQL JQUERY OOPS CONCEPTS INTERVIEW QUESTIONS Server,Ajax,SSRS, XML examples aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code 3 tier architecture example in asp.net examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies By: Suresh Dasari May 17, 2010
with C#
Follow @aspdotnetsuresh
5.7k
TRACE MOBILE NUMBER
2,443 followers
CONTACT
Search This Site
Categories: 3-TierArchitecture , Asp.net Search
Introduction Here I will explain about uses of 3-Tier architecture and how to create or implement 3-tier architecture for our project in asp.net Description 1. What is the use of 3-tier architecture and why we go for that architecture? 2. First we need to know what 3-Tier architecture is. 3. How to create 3-Tier architecture for our project? Uses of 3-Tier Architecture 1. To make application more understandable. 2. Easy to maintain, easy to modify application and we can maintain good look of architecture. If we use this 3-Tier application we can maintain our application in consistency manner. Basically 3-Tier architecture contains 3 layers
About Me
1. Application Layer or Presentation Layer 2. Business Access Layer(BAL) or Business Logic Layer(BLL) 3. Data Access Layer(DAL)
SUR ESH DA SA R I T E NA L I , A NDH R A PR A DESH , INDI A
Hi i am suresh dasari,software engineer working on
Here I will explain each layer with simple example that is User Registration
asp.net,c#.net,SQL Server.
Application Layer or Presentation Layer Presentation layer contains UI part of our application i.e., our aspx pages or input is taken from the user. This layer mainly used for design purpose and get or set the data back and forth. Here I have designed my registration aspx page like this
V I E W M Y COM P LE T E P ROFILE
Follow @aspdotnetsuresh Like
20
5.7k
Powered by
2,443 followers
Translate
2 This is Presentation Layer for our project Design your page like this and double click on button save now in code behind we need to write statements to insert data into database this entire process related to Business Logic Layer and Data Access Layer. Now we will discuss about Business Access Layer or Business Logic Layer Business Access Layer (BAL) or Business Logic Layer (BLL) This layer contains our business logic, calculations related with the data like insert data, retrieve data and validating the data. This acts as a interface between Application layer and Data Access Layer Now I will explain this business logic layer with my sample Recent Posts I have already finished form design (Application Layer) now I need to insert user details into database if user click on button save. Here user entering details regarding Username, password, Firstname, Lastname, Email, phone no, Location. I need to insert all these 7 parameters to database. Here we are placing all of our database actions into data access layer (DAL) in this case we need to pass all these 7 parameters to data access layers. In this situation we will write one function and we will pass these 7 parameters to function like this String Username= InserDetails (string Username, string Password, string Email, string Firstname,
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
2 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
string Lastname, string phnno, string Location) If we need this functionality in another button click there also we need to declare the parameters like string Username, string Password like this rite. If we place all these parameters into one place and use these parameters to pass values from application layer to data access layer by using single object to whenever we require how much coding will reduce think about it for this reason we will create entity layer or property layer this layer comes under sub of group of our Business Logic layer Don't get confuse just follow my instructions enough How we have to create entity layer it is very simple Right click on your project web application---> select add new item ----> select class file in wizard ---> give name as BEL.CS because here I am using this name click ok Open the BEL.CS class file declare the parameters like this in entity layer Don’t worry about code it’s very simple for looking it’s very big nothing is there just parameters declaration that’s all check I have declared whatever the parameters I need to pass to data access layer I have declared those parameters only BEL.CS
#region Variables /// <summary> /// User Registration Variables /// private string _UserName; private string _Password; private string _FirstName; private string _LastName; private string _Email; private string _Phoneno; private string _Location; private string _Created_By; #endregion /// <summary> /// Gets or sets the _UserName attribute value. /// ///
jQuery Show Gridview Row Details in Tooltip on MouseHover in.. More » JavaScript - Convert JSON String to JSON Object More » C# - Convert Datatable to JSON String in C#, VB.NET More » Get Title and Description of URL in Asp.net Like Facebook More » Asp.net Show Multiple Markers on Google Map V3 from Database.. More » Get LinkedIn Logged in User Details(Name,Email, Url, Profile.. More » Need Your Help Please vote for me More » Adding Linkedin Login Button to Website using JavaScript API.. More » Move Selected Gridview Rows to Another Gridview in Asp.net More » 8 jQuery Best HTML5 Audio Player Plugins Examples with Tutor.. More »
We're on
+563
Find us on Facebook Aspdotnetsuresh Like 5,762 people like Aspdotnetsuresh.
Facebook social plugin
Get Latest articles in your inbox for free. Enter your email address:
Subscribe
Blog Archive ► 2013 ( 153 ) ► 2012 ( 301 ) ► 2011 ( 131 ) ▼ 2010 ( 77 ) ► December ( 20 ) ► November ( 5 ) ► October ( 11 ) ► September ( 14 ) ► August ( 8 ) ► July ( 1 ) ► June ( 2 ) ▼ May ( 4 ) 3 tier architecture example in asp.net with C#
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
3 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
{ return _LastName; } set { _LastName = value; } } /// <summary> /// Gets or sets the _Email attribute value. /// ///
WPF (Windows Presentation Foundation) in .NET Cursors in SQL Server Publishing Web Site in asp.net ► April ( 12 )
Categories Asp.net ( 421 ) General ( 269 ) JQuery ( 190 ) Code Snippets ( 96 ) Javascript ( 82 ) SQL Server ( 82 ) Gridview ( 75 ) C#.Net ( 68 ) VB.NET ( 56 ) JQuery Plugins ( 45 ) Errors ( 36 ) Ajax ( 31 ) Interview Questions ( 30 ) DropdownList ( 18 )
/// <summary> /// Gets or sets the _Phoneno attribute value. /// ///
Authentication ( 16 )
/// <summary> /// Gets or sets the _Location attribute value. /// ///
AutoComplete ( 7 )
/// <summary> /// Gets or sets the _Created_By attribute value. /// ///
DatePicker ( 15 ) Fileupload ( 15 ) SharePoint ( 15 ) validations ( 15 ) Membership ( 14 ) Google API ( 12 ) IISServer ( 12 ) JSON ( 12 ) Crystal Reports ( 11 ) Google MAPS ( 11 ) CSS ( 10 ) SendMail ( 8 )
ExcelSheet ( 7 ) InternetTips ( 7 ) ToolTip ( 7 ) AjaxModalPopupExtender ( 6 ) Menu ( 6 ) SQL Joins ( 6 ) SlideShow ( 6 ) Windows Application ( 6 ) XML ( 6 ) CheckBox ( 5 ) DataList ( 5 ) ExportGridviewData ( 5 ) Modalpopup ( 5 ) WebService ( 5 ) Dynamic Controls ( 4 ) Facebook ( 4 ) Twitter ( 4 ) WCF ( 4 ) Windows Service ( 4 ) YouTube ( 4 ) jQuery Menu ( 4 ) jQuery UI ( 4 ) Accordion Menu ( 3 ) AjaxAsyncFileUpload ( 3 ) EncryptionandDecryption ( 3 ) LightBoxEffect ( 3 )
Our parameters declaration is finished now I need to create Business logic layer how I have create it follow same process for add one class file now give name called BLL.CS. Here one point don’t forget this layer will act as only mediator between application layer and data access layer based on this assume what this layer contains. Now I am writing the following BLL.CS(Business Logic layer)
OOPS Concepts ( 3 ) Visual Studio ( 3 ) ZIP UNZIP Files ( 3 ) web.config ( 3 ) 360 Degree View Plugins ( 2 )
#region Insert UserInformationDetails /// <summary> /// Insert UserDetails /// /// <param name='objUserBEL'> /// public string InsertUserDetails(BEL objUserDetails) { DAL objUserDAL = new DAL(); try { return objUserDAL.InsertUserInformation(objUserDetails);
AjaxAutoCompleteExtender ( 2 ) AjaxTabContainer ( 2 ) Blog Statistics ( 2 ) Flip Effect ( 2 ) Global.asax ( 2 ) Linkedin ( 2 ) MultilineTextbox ( 2 ) News Ticker in jQuery ( 2 ) Progressbar ( 2 ) SSRS ( 2 )
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
4 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
} catch (Exception ex) { throw ex; } finally { objUserDAL = null; } } #endregion Here if you observe above code you will get doubt regarding these what is BEL objUserDetails DAL objUserDAL = new DAL();
Session Timeout ( 2 ) ThumbnailsGeneration ( 2 ) UserName Check ( 2 ) jQuery Media Plugins ( 2 ) 3-TierArchitecture ( 1 ) ADO.NET ( 1 ) AbstractVsInterface ( 1 ) ActiveDirectory ( 1 ) Advertise ( 1 ) Ajax Calendarextender ( 1 ) Ajax ConfirmbuttonExtender ( 1 ) AjaxAccordionControl ( 1 ) AjaxCalendarExtender ( 1 ) AjaxCollapsiblePanelControl ( 1 )
and how this method comes
AjaxDragPanelExtender ( 1 ) AjaxPasswordStrength ( 1 )
return objUserDAL.InsertUserInformation(objUserDetails); Here BEL objUserDetails means we already created one class file called BEL.CS with some parameters have you got it now I am passing all these parameters to Data access Layer by simply create one object for our BEL class file
AjaxRatingControl ( 1 ) AjaxSlideshowExtender ( 1 ) Arraylist ( 1 ) Assembly ( 1 ) Authorization ( 1 )
What is about these statements I will explain about it in data access layer DAL objUserDAL = new DAL(); return objUserDAL.InsertUserInformation(objUserDetails);
Average rating ( 1 ) Chatting Plugins ( 1 ) CheckBoxList ( 1 ) CodingStandards ( 1 )
this DAL related our Data access layer. Check below information to know about that function and Data access layer
Custom Right Click Menu ( 1 )
Data Access Layer(DAL)
Fixed Header on Scroll ( 1 )
DataGrid ( 1 )
Generic List ( 1 )
Data Access Layer contains methods to connect with database and to perform insert,update,delete,get data from database based on our input data I think it’s to much data now directly I will enter into DAL
HTML ( 1 ) IP Address ( 1 ) ImportContacts ( 1 ) KeyBoard Key Codes ( 1 )
Create one more class file like same as above process and give name as DAL.CS
ListBox ( 1 ) MCC Award ( 1 )
Write the following code in DAL class file
PDF Viewers ( 1 ) Panorama Image Viewer Plugins ( 1 )
//SQL Connection string string ConnectionString = ConfigurationManager.AppSettings['LocalConnection'].ToString();
QueryString ( 1 ) RSSFeeds ( 1 ) RadioButtonList ( 1 )
#region Insert User Details /// <summary> /// Insert Job Details /// /// <param name='objBELJobs'> /// public string InsertUserInformation(BEL objBELUserDetails) { SqlConnection con = new SqlConnection(ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand('sp_userinformation', con); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.AddWithValue('@UserName',objBELUserDetails.UserName); cmd.Parameters.AddWithValue('@Password', objBELUserDetails.Password); cmd.Parameters.AddWithValue('@FirstName', objBELUserDetails.FirstName); cmd.Parameters.AddWithValue('@LastName', objBELUserDetails.LastName); cmd.Parameters.AddWithValue('@Email', objBELUserDetails.Email); cmd.Parameters.AddWithValue('@PhoneNo', objBELUserDetails.Phoneno); cmd.Parameters.AddWithValue('@Location', objBELUserDetails.Location); cmd.Parameters.AddWithValue('@Created_By', objBELUserDetails.Created_By); cmd.Parameters.Add('@ERROR', SqlDbType.Char, 500); cmd.Parameters['@ERROR'].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); string strMessage = (string) cmd.Parameters['@ERROR'].Value; con.Close(); return strMessage; } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); con.Close(); con.Dispose(); } } #endregion
Read/Write text file ( 1 ) ReadOnlyValues ( 1 ) Repeater ( 1 ) Resize Image ( 1 ) RichTextBox ( 1 ) SQL Constraints ( 1 ) SiteMap ( 1 ) Social Media Bookmark Plugins ( 1 ) Spell Checker ( 1 ) Testing ( 1 ) Trace Mobile Number ( 1 ) Try Catch ( 1 ) UpdatePanel ( 1 ) VBScript ( 1 ) Virtual Keyboard ( 1 ) WPF ( 1 ) jQuery Audio Plugins ( 1 ) jQuery Mobile ( 1 ) jQuery Video Plugins ( 1 ) scroll top/bottom of div ( 1 ) setInterval ( 1 )
Here if you observe above functionality I am getting all the parameters by simply creating BEL
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
5 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
objBELUserDetails. If we create one entity file we can access all parameters through out our project by simply creation of one object for that entity class based on this we can reduce redundancy of code and increase re usability Observe above code have u seen this function before? in BLL.CS i said i will explain it later got it in DAL.CS I have created one function InsertUserInformation and using this one in BLL.CS by simply creating one object of DAL in BLL.CS. Here you will get one doubt that is why BLL.CS we can use this DAL.CS directly into our code behind we already discuss Business logic layer provide interface between DAL and Application layer by using this we can maintain consistency to our application. Now our Business Logic Layer is ready and our Data access layer is ready now how we can use this in our application layer write following code in your save button click like this
protected void btnsubmit_Click(object sender, EventArgs e) { string Output = string.Empty; if (txtpwd.Text txtcnmpwd.Text) { BEL objUserBEL = new BEL(); objUserBEL.UserName = txtuser.Text; objUserBEL.Password = txtpwd.Text; objUserBEL.FirstName = txtfname.Text; objUserBEL.LastName = txtlname.Text; objUserBEL.Email = txtEmail.Text; objUserBEL.Phoneno = txtphone.Text; objUserBEL.Location = txtlocation.Text; objUserBEL.Created_By = txtuser.Text; BLL objUserBLL = new BLL(); Output = objUserBLL.InsertUserDetails(objUserBEL); } else { Page.RegisterStartupScript('UserMsg', '<Script language='javascript'>alert(' + 'Password mismatch' + ');'); } lblErrorMsg.Text = Output; } Here if you observe I am passing all parameters using this BEL(Entity Layer) and we are calling the method InsertUserDetails by using this BLL(Business Logic Layer) Now run your applciation test with debugger you can get idea clearly. I hope it helps you.
Download sample code attached
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.
Like
5.7k
20
Follow @aspdotnetsuresh
Subscribe by RSS
Subscribe by Email
2,443 followers
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
6 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
126 comments : hyu said..
1
Your All Coding in Blogspot is meaningfull.Nice tutorial of 3-tiers for beginner. I Rate 5 Star
December 25, 2010 at 2:26 AM Suresh Dasari said..
2
thanks hyu keep visiting...
December 25, 2010 at 4:09 AM jooey said..
3
I am really impressed the way you make me understand.Thank you very much.Keep on bloging.
March 28, 2011 at 9:59 AM Suresh Dasari said..
4
thanks jooey
March 28, 2011 at 6:03 PM Anonymous said..
5
very nice
April 10, 2011 at 5:43 AM Anonymous said..
6
wheres d database?
September 3, 2011 at 12:02 AM Dejt Mi Chi said..
7
Hi, really great tutorial here. Before reading this I had some problems understanding when to use an entity layer or property layer. I noticed some tutorial used it, and some didnt. I believe you explained that part very clear here.
October 20, 2011 at 7:16 AM Anonymous said..
8
nice wesite suresh.
November 28, 2011 at 4:23 AM Anonymous said..
9
hi suresh tis site is very useful for me and all dotnet developers.thank u.
November 28, 2011 at 4:24 AM Pandoh kishan said..
10
HIIII WHAT AN IDEA SR GGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
December 23, 2011 at 11:31 PM Shruti said..
11
Hi suresh, very nice website and this topic is really very usefull.
December 26, 2011 at 1:59 AM Deepika said..
12
While visiting this site I'm getting interest towards subject.I feel thankful to you for that
February 15, 2012 at 10:45 PM Anonymous said..
13
Hai sir this rajesh from kakinada,iam working as .net developer ,Today i see the blog i am really impressed,this site is very usefull me.
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
7 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Sir this is mail id:[email protected] please send your mail id.
April 13, 2012 at 3:07 AM Mahesh said..
14
nice article very useful
April 18, 2012 at 7:31 AM sattar342 said..
15
Thank you very much Mr. Suresh
April 29, 2012 at 4:52 PM yashu said..
16
thanku ..
May 1, 2012 at 11:02 PM Anonymous said..
17
Hello Sir, Thanks .. It is very helpful for all ..Keep up your Good work. I am very impressed the way you are explaining.
May 23, 2012 at 10:52 PM Ram said..
18
Hi Suresh, Can you give one simple project for MVC3 application in Visual Studio 2010
May 29, 2012 at 4:29 AM Anonymous said..
19
where is database procedure..
July 3, 2012 at 5:17 AM Santhosh Kumar said..
20
thanks for your valuable information, it make ma to easy understand 3 tier architech. keep on rocks
July 22, 2012 at 11:22 PM Anonymous said..
21
What is need of private variables in BEL.cs as you are using public variables everywhere in your example?
July 24, 2012 at 12:06 AM Anonymous said..
22
Awesome.i was searching for such a good poast. thanks alot :)
July 26, 2012 at 11:02 PM pankaj khairanar said..
23
really nice article!
August 2, 2012 at 4:12 PM Susil singh said..
24
Sir, how to create database for this project? i m new in this field so please explain for creating database and how to connect.
August 2, 2012 at 7:47 PM Susil singh said..
25
Hi! Brothers, please tell me how to create database for this project.
August 2, 2012 at 7:51 PM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
8 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
ALOK NAYAK said..
26
Its really easy way to understand 3-tire Arch. I have already done but confused abt 3-tire. Thanks Suresh..
August 17, 2012 at 7:48 AM SHANKAR said..
27
Hello suresh p-lease save me..i have lots of confusion when i writting SP for this article..i am requested to you..please tell me key points to create proc for this app.thanks
August 18, 2012 at 9:42 AM Anonymous said..
28
Hi Suresh, While launching the applicaton, after entering the user details its giving me an error 'Procedure or function sp_userinformation has too many arguments specified.'
August 18, 2012 at 8:33 PM Harshu said..
29
Hi Suresh, While launching the applicaton, after entering the user details its giving me an error 'Procedure or function sp_userinformation has too many arguments specified.'
August 18, 2012 at 8:34 PM SHANKAR said..
30
Hello Anonymous for fixing that Bug we need to pass prameter for otput..here is the Proc for that app..after writing the code once test in sqlserver only then after write sp in DAL class. CREATE TABLE tbl_tier ( UserName VARCHAR(30), Password VARCHAR(30), FirstName VARCHAR(30), LastName VARCHAR(30), Email VARCHAR(30), Phoneno VARCHAR(30), Location VARCHAR(30), Created_By VARCHAR(30) ) ALTER PROC sp_userinformation ( @UserName VARCHAR(30), @Password VARCHAR(30), @FirstName VARCHAR(30), @LastName VARCHAR(30), @Email VARCHAR(30), @Phoneno VARCHAR(30), @Location VARCHAR(30), @Created_By VARCHAR(30), @ERROR VARCHAR(30) OUTPUT ) AS BEGIN INSERT INTO tbl_tier VALUES(@UserName,@Password,@FirstName,@LastName,@Email,@Phoneno,@Location,@Created_By) END
DECLARE @HN VARCHAR(30) EXEC sp_userinformation 'SHANKAR','12345','SHANKAR','PARSHIMONI','[email protected]','9966385883','HYDERABAD','SHANKAR', @[email protected] OUTPUT SELECT @HN
August 18, 2012 at 9:15 PM SHANKAR said..
31
hello suresh pls visit this site,i am getting one bug in BLL.cs file i,e Unable to cast object of type 'System.DBNull' to type 'System.String'..i have been fixing this bug but i coudn't do..so please drop you answer ..tanq
August 18, 2012 at 9:21 PM SHANKAR said..
32
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
9 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Hello friends finally i got final result in 3 tier architectur app.but i have taken only 3 controls.i have posted entire code including proc in my blogspot..so please click this link for further details http://www.shankar-mydotnetsite.blogspot.in/
August 19, 2012 at 1:49 AM Anonymous said..
33
Hi this post was very nice & 200% useful for 3Tier freshers including me. This shows your technical stuff as well as reputation. Iam expecting similar like this post for basic or freshers who are willing to learn mvc, because we & our blog fans need to update with current trend & technology. So, Please post mvc example. Thank you!
August 24, 2012 at 12:08 AM Sagar said..
34
Hi this post was very nice & 200% useful for 3Tier freshers including me. This shows your technical stuff as well as reputation. Iam expecting similar like this post for basic or freshers who are willing to learn mvc, because we & our blog fans need to update with current trend & technology. So, Please post mvc example. Thank you!
August 24, 2012 at 12:09 AM Uddhav Garkal said..
35
nice web site.. keep it up
August 28, 2012 at 12:45 AM Munavvar Patel said..
36
NOTICE BEL works just for calling method of DLL(realy overhead of coding and need one extra class). why can't we write(call dll method)in codebihind file(directly in button 'Click event')?
September 2, 2012 at 10:20 PM Anonymous said..
37
@Shankar - Kindly add the below line after the insert statement SET @ERROR ='success' to avoid casting error.
September 9, 2012 at 9:25 AM Anonymous said..
38
For a fresher like me it will be very helpful if you publish the entire code (ie), with stored procedures and database tables.
September 9, 2012 at 11:33 PM Anonymous said..
39
CREATE TABLE tbl_tier ( UserName VARCHAR(30), Password VARCHAR(30), FirstName VARCHAR(30), LastName VARCHAR(30), Email VARCHAR(30), Phoneno VARCHAR(30), Location VARCHAR(30), Created_By VARCHAR(30) ) ALTER PROC sp_userinformation ( @UserName VARCHAR(30), @Password VARCHAR(30), @FirstName VARCHAR(30), @LastName VARCHAR(30), @Email VARCHAR(30), @Phoneno VARCHAR(30), @Location VARCHAR(30), @Created_By VARCHAR(30), @ERROR VARCHAR(30) OUTPUT ) AS
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
10 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
BEGIN INSERT INTO tbl_tier VALUES(@UserName,@Password,@FirstName,@LastName,@Email,@Phoneno,@Location,@Created_By) SET @ERROR='Success' END the stored procedure should look like above. You need to pass the out parameter.
September 11, 2012 at 10:10 AM Anonymous said..
40
do i have to create a class for each table? i mean BEL class.
September 17, 2012 at 2:26 AM Sneha said..
41
Hey.dats a very easiest way you explained. really helpfull.
September 20, 2012 at 10:39 AM Anonymous said..
42
Very good artical sir ....
September 27, 2012 at 1:05 PM chothani punita said..
43
Awesome post.I got idea about the 3 tier architecture..thank u so much sir. I am going to develop a website----Online Examination System in asp.net with 3 tier architecture. Plz help me how can I do it as I new in asp.net, plz explain me in detail. Thanking u.
October 2, 2012 at 6:24 AM Anonymous said..
44
No need to add entity layer... BAL and DAL are enough..
October 8, 2012 at 10:51 PM Anonymous said..
45
where is the code for reset button? it is just to clear all the fields.....
October 8, 2012 at 10:57 PM Poonam said..
46
Vry nice description of 3 tier architecture for begginer. Thank u!!
October 10, 2012 at 6:11 AM Anonymous said..
47
GUD POST
October 16, 2012 at 4:47 AM Anonymous said..
48
gr8
October 16, 2012 at 6:11 AM vipin pandey said..
49
hi! suresh it'S very helpful but, please write the stored procdure of it. that'S awesome thank you sir
October 22, 2012 at 1:37 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
11 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Ameerpv said..
50
good information thank you
October 22, 2012 at 11:03 AM Anonymous said..
51
fabulous article . Got a clear picture regarding entity/property layer. Regards Raj
October 24, 2012 at 11:54 PM Anonymous said..
52
Niccceeeee bro.. easiest and best one from all
November 1, 2012 at 4:22 AM Anonymous said..
53
realy a nice tutorial i ever seen about three tier architecture....
November 3, 2012 at 1:01 AM JPEdwards said..
54
its very nice sir to understand easily i am thankful to u for that
November 11, 2012 at 10:08 AM ANOOP said..
55
haii.. this post is very helpful.. i want to learn more and i have some doubts. pls give me your mailid
November 15, 2012 at 9:31 PM Anonymous said..
56
Hi, I like your example of three tier example .It is very easy to understand . I have a request for you can you please tell me about stored Procedure ,So i can get best explanation. THANKS A LOT.And keep it up
November 22, 2012 at 3:01 AM Anonymous said..
57
HAI
in .aspx it show error at InsertUserDetails(objUserBEL); shos that 'BEL does not contain a definition for 'InsertUserDetails'and no extension method 'InsertUserDetails' accepting a first argument of type 'BEL' could be found
November 24, 2012 at 3:05 AM Anonymous said..
58
what is problem in this
November 24, 2012 at 3:06 AM chanti said..
59
suresh bhayya awesome simply code bhayya
November 28, 2012 at 12:18 AM sagar said..
60
Exactly good working by you guys.. keep it continues Thanks to understand 3 tier arch..
November 28, 2012 at 1:32 AM Anonymous said..
61
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
12 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
very nice Mr Suresh.. i like ur demo and code too.
November 29, 2012 at 5:05 AM Anonymous said..
62
Mr Harshu.pls check parameter which u passed.. so u can solve ur error..
November 29, 2012 at 5:07 AM Anonymous said..
63
Very good article I understood it given step by step..very useful
November 29, 2012 at 5:21 AM Anonymous said..
64
only the thing is can u provide this article without using out parameter it is difficult to understand fresher how the value is returned? to the BLL can you brief it? Thank in advance.
November 29, 2012 at 5:42 AM Anonymous said..
65
Thank u sir...:)
December 5, 2012 at 9:17 PM Anonymous said..
66
Nice article .Will you pls explain how to make 3-tier architecture?
December 6, 2012 at 10:48 PM Anonymous said..
67
can u please upload image to folder using this same method.. please
December 9, 2012 at 8:09 PM Anonymous said..
68
gud one..
December 10, 2012 at 11:34 PM Anonymous said..
69
nice.
December 11, 2012 at 4:50 AM Anonymous said..
70
December 13, 2012 at 5:20 AM Venkatesan K said..
71
hi Mr.suresh...... Its very helpful to me and i have a doubt? how can i insert the values in more than tables from windows form to database via DAL and BAL concept..Please Tell me and i am waiting for your ans
December 16, 2012 at 9:01 PM hima said..
72
thank u for sharing the articles...
December 20, 2012 at 8:26 AM Sandhya Reddy said..
73
Very clear for freshers....
December 21, 2012 at 10:40 PM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
13 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Sandhya Reddy said..
74
Very clear for freshers....
December 21, 2012 at 10:43 PM Ranga Rao said..
75
Hi suresh its a perfect 3 tier architecture code and very easy to understand. please mention connection string in web.config file. please send me how to update dropdownlist inside gridview inn rowupdating event includind database back up. My mail is [email protected]
December 28, 2012 at 10:46 PM Ranga Rao said..
76
Hi suresh its a perfect 3 tier architecture code and very easy to understand. please mention connection string in web.config file. please send me how to update dropdownlist inside gridview inn rowupdating event includind database back up. My mail is [email protected]
December 28, 2012 at 10:48 PM Anonymous said..
77
Hi Suresh this is a good example for but not for 3 tier
December 30, 2012 at 9:43 PM Anonymous said..
78
Hi Suresh this is a good example for 3 layer but not for 3 tier
December 30, 2012 at 9:46 PM Jatin said..
79
This comment has been removed by the author. January 3, 2013 at 2:15 AM Jatin said..
80
Suresh, u r really doing a nice job.
January 3, 2013 at 2:16 AM Jatin said..
81
your way of explanation is really easy and efficient. :)
January 3, 2013 at 2:18 AM Anonymous said..
82
Ya its good topic. But i have one doubt on 3 tier architecture. How to fill master and child table using 3 Tier architecture by using Transaction? Please send me answer to this mail id [email protected]
January 6, 2013 at 12:00 AM Anonymous said..
83
Jayant :gud 1 it actually made some thoughts clear
January 7, 2013 at 12:55 AM sureshbehera said..
84
its very valuable for me i want mvc demo project also plz plz plz send me on e-mail [email protected]
January 7, 2013 at 2:44 AM Anonymous said..
85
great
January 9, 2013 at 1:05 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
14 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Thatiboina Prasad said..
86
great
January 9, 2013 at 5:19 AM Anonymous said..
87
Really it is a very helpful artical for beginners and I got very much help from your article in our final year project.Thanks u mr.suresh and keep updating..
January 11, 2013 at 8:43 PM Anonymous said..
88
hai suresh.Is it mention any connectionstring in bll.i follow u r steps.when i am trying to execute 'The connectionstring property has not been initialized' error showing in bll.
January 17, 2013 at 11:31 PM Suneel Kumar said..
89
Hai Suresh, it is much useful for me.., And It is very easy to understand your presentation.
January 24, 2013 at 11:00 PM Ganesh Kumar said..
90
good blog sir. easy to understand. great job........
January 31, 2013 at 9:50 AM Ganesh Kumar said..
91
good blog sir. easy to understand. great job........
January 31, 2013 at 9:50 AM Anish Shaikh said..
92
Thanks..It is Useful for me..great explaination Thank U very Much.. :)
February 4, 2013 at 5:52 AM aspnet said..
93
thank you sir ,this is helpful content
February 6, 2013 at 7:42 PM Anonymous said..
94
Nice and Very Help Full Sir
February 6, 2013 at 11:36 PM Parthiban B said..
95
Thank you This is very helpful
February 8, 2013 at 9:49 PM Anonymous said..
96
u should be a great teacher.u explains in very simple manner so newer people can also get your blogs..thanks u
February 12, 2013 at 3:20 AM Shiva Katta said..
97
Clearly understood what is 3-tier atchitecture . Thank you .
February 15, 2013 at 1:15 AM edwin rajkumar said..
98
i want coding for sign out in 3 tier architecture with session concept
February 21, 2013 at 2:10 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
15 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Anonymous said..
99
Thanks Suresh, It is realy helpful information for any .net developer and the way you explained is simply awesome..!!
February 21, 2013 at 6:11 AM Jangu Phelix said..
100
Hi Suresh, I must say you are great. I visit your site almost daily, and learn at least something new everyday. Keep it up.
February 21, 2013 at 11:06 PM thinusha said..
101
Your All Coding in Blogspot is meaningfull.Nice tutorial of 3-tiers for beginner.
February 22, 2013 at 4:03 AM Megic Geeks Technology said..
102
Hello Suresh. it is really helpfull.. keep it up...
February 25, 2013 at 3:21 AM sunil kumar said..
103
VOUCHER: • VOUCHER NO (PK) (VAR 30) • DATE (VAR 10) • PAID TO (VAR 30) • AMOUNT (DOUBLE 30) • REASON (VAR 45) • AUTHORIAZED SIGNATURE (TEXT ) Voucher is the table and folling are the attribute now i want desining and store procedure with 3-tire architure with coding every thing Please help me out of the proble are mail me [email protected]
February 26, 2013 at 3:00 AM Vishal Jagani said..
104
Bhai. Suresh Thoda Easy Way me 3 Tire ka Coding Nahi Hai Kya ? Ye Samaj Me Nahi aa raha hai. Thoda samj me aye esa kucchhh Likho na pls yaar I m Fresher for 3 tier.. to kya aap kuchh Help Kar sakte ho
March 4, 2013 at 12:29 AM Hardik-Patel said..
105
nice sir its impressive and keep doing this type of stuff in easy manner. thanks a lot
March 10, 2013 at 3:54 AM pramod said..
106
hello my query is how to implement 3 tiers Architecture in whole asp.net project i.e if there is more than 10 form so how to implement 3 tiers architecture is there create each bal,dal for each databasse code please solve my query
March 10, 2013 at 11:49 PM Marees said..
107
Nice article .Will you pls explain how to make MVC 4 ?
March 13, 2013 at 6:18 AM Anonymous said..
108
nice
March 18, 2013 at 3:38 AM Anonymous said..
109
i got error in DAL.cs nullreference was unhandled by code in connectionstring
March 20, 2013 at 12:29 AM
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
16 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
nandy said..
110
ERROR*** i have initialized my dal object to null in finally block, its showing error, ExecuteNonQuery: Connection property has not been initialized.
March 24, 2013 at 1:44 AM nandy said..
111
namespace BLclass { public class BLPerson { public string RegisterUser(PersonInfo entityObj) { PersonDALclass dalObj = new PersonDALclass(); try { return dalObj.RegisterUser(entityObj); } catch (Exception ex) { throw ex; } finally { dalObj = null; }
} } whats wrong in this code.
March 24, 2013 at 2:36 AM Kapil Jangra said..
112
thanks alot dear suresh for your fruitful postings.
March 31, 2013 at 10:01 PM Rajesh Narra said..
113
good post really it is very useful for everyone .thanks a lot .awesome work by you
April 5, 2013 at 11:50 PM Manpreet Kaur said..
114
in our webpage to bind textbox we do as textbox1.text what is the correct synatx for binding drop down list mail me on my id [email protected] urgent
April 15, 2013 at 5:48 AM Jeevanandam Jpd said..
115
Good Job Suresh....Awesome Explanation in all your tutorials..
April 16, 2013 at 3:54 AM seema darade said..
116
thanks..It's good explanation...
April 16, 2013 at 8:52 AM Anonymous said..
117
nice
April 25, 2013 at 4:44 AM Anonymous said..
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
17 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit.. 118
nice
April 25, 2013 at 4:45 AM Anonymous said..
119
I cannot access BEL in in DAL class.. i.e . I cannot write BEL b=new BEL() // Here BEL is not coming in intellisence ..
April 27, 2013 at 5:27 AM sundar neupane said..
120
So good site for us.thanks this site.
April 29, 2013 at 7:47 AM Pradeep said..
121
its very usefull to all
May 7, 2013 at 12:26 AM Anonymous said..
122
Good one,Very Useful
May 7, 2013 at 1:17 PM Web Master said..
123
Hi, DO I need to create seperate classes for each table in BEL class ?
May 8, 2013 at 3:17 AM Imtiyaz Jamadar said..
124
This is one of the best site I ever seen .
May 10, 2013 at 9:25 PM Bhusan said..
125
CODE FOR SAVING RADIO BUTTON (DAL,BAL & PRESENTATION LAYER)VALUE IN 3 TIER KINDLY REPLY
May 11, 2013 at 8:45 AM jackson said..
126
Thanks alot suresh.. awesome explanation.
May 15, 2013 at 9:37 AM
Give your Valuable Comments
Comment as:
Newer Post
Home
Older Post
Subscribe to: Post Comments ( Atom )
Other Related Posts Display Images in Asp.net Gridview from Database in C#, VB.NET .. Ajax Asynchronous File Upload Asp.net Example to Upload Files .. JavaScript - Show Number of Characters Remaining in .. - Asp.net Asp.net
17-05-2013 PM 02:23
3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB..
18 of 18
http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit..
Cross Page Postback in Asp.net Example 2.0, 3.0, 3.5, 4.0 - ASP ..
Asp.net insert, Edit, update, delete data in gridview Introduction to Object Oriented Programming Concepts (OOPS) in C#.net Introduction to WCF - WCF tutorial WCF Tutorial - Windows Communication Foundation WCF Example WCF Sample code in asp.net 3.5 Basic WCF Tutorial for Beginners 3 tier architecture example in asp.net with C# how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and retrieve images from database using asp.net Simple login form example in asp.net Check Username and Password availability in database Interview Questions in ASP.NET,C#.NET,SQL Server,.NET Framework Ajax ModalPopUpExtender Example to edit the gridview row values in asp.net Ajax Cascading Dropdownlist Sample with database using asp.net how to save images into folder and images path in database and display images from folder in gridview based on images path in database using asp.net
© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved. The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.
17-05-2013 PM 02:23