3 tier architecture example in asp.net with c# - asp.net,c#

Like 5.7k Follow @aspdotnetsuresh 2,443 followers

ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQLServer,Ajax,SSRS, XML examplesaspdotnet-suresh offers C#.net articles andtutorials,csharp dot net,asp.net articles andtutorials,VB.NET Articles,Gridview articles,codeexamples of asp.net 2.0 /3.5,AJAX,SQL ServerArticles,examples of .net technologies

HOME ASP.NET AJAX GRIDVIEW JAVASCRIPT SQL JQUERY OOPS CONCEPTS INTERVIEW QUESTIONS TRACE MOBILE NUMBER CONTACT

3 tier architecture example in asp.net with C#By: Suresh Dasari May 17, 2010

Categories: 3-TierArchitecture , Asp.net

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

1. Application Layer or Presentation Layer

2. Business Access Layer(BAL) or Business Logic Layer(BLL)

3. Data Access Layer(DAL)

Here I will explain each layer with simple example that is User Registration

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

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

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,

Search This Site

Search

About Me

SURESH DASARI

TENALI, ANDHRA PRADESH, INDIA

Hi i am suresh dasari,software

engineer working on

asp.net,c#.net,SQL Server.

V IEW MY COMPLETE PROFILE

Follow @aspdotnetsuresh 2,443 followers

Like 5.7k

20

Powered by Translate

Recent Posts

2

3 tier architecture example in asp.net with C# - ASP.NET,C#.NET,VB.... http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-archit...

1 of 18 17-05-2013 PM 02:23

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

/// </summary>

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.

/// </summary>

/// <value>The _UserName attribute value.</value>

public string UserName

{

get

{

return _UserName;

}

set

{

_UserName = value;

}

}

/// <summary>

/// Gets or sets the _Password attribute value.

/// </summary>

/// <value>The _Password attribute value.</value>

public string Password

{

get

{

return _Password;

}

set

{

_Password = value;

}

}

/// <summary>

/// Gets or sets the _FirstName attribute value.

/// </summary>

/// <value>The _FirstName attribute value.</value>

public string FirstName

{

get

{

return _FirstName;

}

set

{

_FirstName = value;

}

}

/// <summary>

/// Gets or sets the _LastName attribute value.

/// </summary>

/// <value>The _LastName attribute value.</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:

SubscribeSubscribeSubscribeSubscribe

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#


2 of 18 17-05-2013 PM 02:23

{

return _LastName;

}

set

{

_LastName = value;

}

}

/// <summary>

/// Gets or sets the _Email attribute value.

/// </summary>

/// <value>The _Email attribute value.</value>

public string Email

{

get

{

return _Email;

}

set

{

_Email = value;

}

}

/// <summary>

/// Gets or sets the _Phoneno attribute value.

/// </summary>

/// <value>The _Phoneno attribute value.</value>

public string Phoneno

{

get

{

return _Phoneno;

}

set

{

_Phoneno = value;

}

}

/// <summary>

/// Gets or sets the _Location attribute value.

/// </summary>

/// <value>The _Location attribute value.</value>

public string Location

{

get

{

return _Location;

}

set

{

_Location = value;

}

}

/// <summary>

/// Gets or sets the _Created_By attribute value.

/// </summary>

/// <value>The _Created_By attribute value.</value>

public string Created_By

{

get

{

return _Created_By;

}

set

{

_Created_By = value;

}

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)

#region Insert UserInformationDetails

/// <summary>

/// Insert UserDetails

/// </summary>

/// <param name="objUserBEL"></param>

/// <returns></returns>

public string InsertUserDetails(BEL objUserDetails)

{

DAL objUserDAL = new DAL();

try

{

return objUserDAL.InsertUserInformation(objUserDetails);

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 )

Authentication ( 16 )

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 )

AutoComplete ( 7 )

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 )

OOPS Concepts ( 3 )

Visual Studio ( 3 )

ZIP UNZIP Files ( 3 )

web.config ( 3 )

360 Degree View Plugins ( 2 )

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 )


3 of 18 17-05-2013 PM 02:23

}

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


and how this method comes


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

What is about these statements I will explain about it in data access layer



this DAL related our Data access layer. Check below information to know about that function and Data

access layer

Data Access Layer(DAL)

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

Create one more class file like same as above process and give name as DAL.CS

Write the following code in DAL class file

//SQL Connection string

string ConnectionString = ConfigurationManager.AppSettings["LocalConnection"].ToString();

#region Insert User Details

/// <summary>

/// Insert Job Details

/// </summary>

/// <param name="objBELJobs"></param>

/// <returns></returns>

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;

}


{

throw ex;

}

finally

{

cmd.Dispose();

con.Close();

con.Dispose();

}

}

#endregion

Here if you observe above functionality I am getting all the parameters by simply creating BEL

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 )

AjaxDragPanelExtender ( 1 )

AjaxPasswordStrength ( 1 )

AjaxRatingControl ( 1 )

AjaxSlideshowExtender ( 1 )

Arraylist ( 1 )

Assembly ( 1 )

Authorization ( 1 )

Average rating ( 1 )

Chatting Plugins ( 1 )

CheckBoxList ( 1 )

CodingStandards ( 1 )

Custom Right Click Menu ( 1 )

DataGrid ( 1 )

Fixed Header on Scroll ( 1 )

Generic List ( 1 )

HTML ( 1 )

IP Address ( 1 )

ImportContacts ( 1 )

KeyBoard Key Codes ( 1 )

ListBox ( 1 )

MCC Award ( 1 )

PDF Viewers ( 1 )

Panorama Image Viewer Plugins ( 1 )

QueryString ( 1 )

RSSFeeds ( 1 )

RadioButtonList ( 1 )

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 )


4 of 18 17-05-2013 PM 02:23

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"

+ "');</script>");

}

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 Subscribe by RSS Subscribe by Email

Follow @aspdotnetsuresh 2,443 followers


5 of 18 17-05-2013 PM 02:23

126 comments :

1

2

3

4

5

6

7

8

9

10

11

12

13

hyu said...

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...

thanks hyu keep visiting......


jooey said...

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...

thanks jooey

March 28, 2011 at 6:03 PM

Anonymous said...

very nice

April 10, 2011 at 5:43 AM

Anonymous said...

wheres d database?

September 3, 2011 at 12:02 AM

Dejt Mi Chi said...

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...

nice wesite suresh.

November 28, 2011 at 4:23 AM

Anonymous said...

hi suresh tis site is very useful for me and all dotnet developers.thank u.


Pandoh kishan said...

HIIII WHAT AN IDEA SR GGGGGGGGGGGGGGGGGGGGGGGGGGGGGG

December 23, 2011 at 11:31 PM

Shruti said...

Hi suresh, very nice website and this topic is really very usefull..


Deepika said...

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...

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.


6 of 18 17-05-2013 PM 02:23

14

15

16

17

18

19

20

21

22

23

24

25

Sir this is mail id:[email protected] please send your mail id.

April 13, 2012 at 3:07 AM

Mahesh said...

nice article very useful

April 18, 2012 at 7:31 AM

sattar342 said...

Thank you very much Mr. Suresh

April 29, 2012 at 4:52 PM

yashu said...

thanku ...

May 1, 2012 at 11:02 PM

Anonymous said...

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...

Hi Suresh,

Can you give one simple project for MVC3 application in Visual Studio 2010

May 29, 2012 at 4:29 AM

Anonymous said...

where is database procedure...

July 3, 2012 at 5:17 AM

Santhosh Kumar said...

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...

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...

Awesome..i was searching for such a good poast. thanks alot :)

July 26, 2012 at 11:02 PM

pankaj khairanar said...

really nice article!

August 2, 2012 at 4:12 PM

Susil singh said...

Sir, how to create database for this project? i m new in this field so please explain for creating database and how to

connect.


Susil singh said...

Hi! Brothers, please tell me how to create database for this project.



7 of 18 17-05-2013 PM 02:23

26

27

28

29

30

31

32

ALOK NAYAK said...

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...

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...

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...

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...

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',

@ERROR=@HN OUTPUT

SELECT @HN

August 18, 2012 at 9:15 PM

SHANKAR said...

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...


8 of 18 17-05-2013 PM 02:23

33

34

35

36

37

38

39

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...

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...

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...

nice web site.... keep it up

August 28, 2012 at 12:45 AM

Munavvar Patel said...

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...

@Shankar - Kindly add the below line after the insert statement

SET @ERROR ='success' to avoid casting error.


Anonymous said...

For a fresher like me it will be very helpful if you publish the entire code (ie), with stored procedures and database

tables.


Anonymous said...

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


9 of 18 17-05-2013 PM 02:23

40

41

42

43

44

45

46

47

48

49

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.


Anonymous said...

do i have to create a class for each table?

i mean BEL class.


Sneha said...

Hey..dats a very easiest way you explained..

really helpfull..


Anonymous said...

Very good artical sir ........


chothani punita said...

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.


Anonymous said...

No need to add entity layer.....

BAL and DAL are enough...

October 8, 2012 at 10:51 PM

Anonymous said...

where is the code for reset button?

it is just to clear all the fields.........

October 8, 2012 at 10:57 PM

Poonam said...

Vry nice description of 3 tier architecture for begginer.. Thank u!!


Anonymous said...

GUD POST


Anonymous said...

gr8


vipin pandey said...

hi! suresh

it'S very helpful

but, please write the stored procdure of it.

that'S awesome

thank you sir



10 of 18 17-05-2013 PM 02:23

50

51

52

53

54

55

56

57

58

59

60

61

Ameerpv said...

good information thank you

October 22, 2012 at 11:03 AM

Anonymous said...

fabulous article . Got a clear picture regarding entity/property layer.

Regards

Raj

October 24, 2012 at 11:54 PM

Anonymous said...

Niccceeeee bro.... easiest and best one from all


Anonymous said...

realy a nice tutorial i ever seen about three tier architecture........


JPEdwards said...

its very nice sir to understand easily i am thankful to u for that


ANOOP said...

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...

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


Anonymous said...

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


Anonymous said...

what is problem in this


chanti said...

suresh bhayya awesome simply code bhayya


sagar said...

Exactly good working by you guys....

keep it continues

Thanks to understand 3 tier arch...


Anonymous said...


11 of 18 17-05-2013 PM 02:23

62

63

64

65

66

67

68

69

70

71

72

73

very nice Mr Suresh...

i like ur demo and code too..


Anonymous said...

Mr Harshu..pls check parameter which u passed...

so u can solve ur error...


Anonymous said...

Very good article I understood it given step by step...very useful


Anonymous said...

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..


Anonymous said...

Thank u sir.....:)


Anonymous said...

Nice article .Will you pls explain how to make 3-tier architecture?


Anonymous said...

can u please upload image to folder using this same method.... please


Anonymous said...

gud one...


Anonymous said...

nice..


Anonymous said...


Venkatesan K said...

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


hima said...

thank u for sharing the articles.....


Sandhya Reddy said...

Very clear for freshers........



12 of 18 17-05-2013 PM 02:23

74

75

76

77

78

79

80

81

82

83

84

85

Sandhya Reddy said...

Very clear for freshers........


Ranga Rao said...

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]


Ranga Rao said...

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]


Anonymous said...

Hi Suresh this is a good example for but not for 3 tier


Anonymous said...

Hi Suresh this is a good example for 3 layer but not for 3 tier


Jatin said...

This comment has been removed by the author.

January 3, 2013 at 2:15 AM

Jatin said...

Suresh, u r really doing a nice job..


Jatin said...

your way of explanation is really easy and efficient.. :)


Anonymous said...

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]


Anonymous said...

Jayant :gud 1 it actually made some thoughts clear


sureshbehera said...

its very valuable for me i want mvc demo project also plz plz plz send me on e-mail [email protected]


Anonymous said...

great



13 of 18 17-05-2013 PM 02:23

86

87

88

89

90

91

92

93

94

95

96

97

98

Thatiboina Prasad said...

great


Anonymous said...

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...

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...

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...

good blog sir.. easy to understand.

great job...............


Ganesh Kumar said...

good blog sir.. easy to understand.

great job...............


Anish Shaikh said...

Thanks...It is Useful for me...great explaination

Thank U very Much.... :)

February 4, 2013 at 5:52 AM

aspnet said...

thank you sir ,this is helpful content


Anonymous said...

Nice and Very Help Full Sir


Parthiban B said...

Thank you This is very helpful


Anonymous said...

u should be a great teacher..u explains in very simple manner so newer people can also get your blogs...thanks u


Shiva Katta said...

Clearly understood what is 3-tier atchitecture . Thank you .


edwin rajkumar said...

i want coding for sign out in 3 tier architecture with session concept



14 of 18 17-05-2013 PM 02:23

99

100

101

102

103

104

105

106

107

108

109

Anonymous said...

Thanks Suresh,

It is realy helpful information for any .net developer and the way you explained is simply awesome...!!


Jangu Phelix said...

Hi Suresh,

I must say you are great. I visit your site almost daily, and learn at least something new everyday. Keep it up.


thinusha said...

Your All Coding in Blogspot is meaningfull.Nice tutorial of 3-tiers for beginner..


Megic Geeks Technology said...

Hello Suresh.

it is really helpfull....

keep it up.....


sunil kumar said...

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]


Vishal Jagani said...

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...

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...

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...

Nice article .Will you pls explain how to make MVC 4 ?

March 13, 2013 at 6:18 AM

Anonymous said...

nice

March 18, 2013 at 3:38 AM

Anonymous said...

i got error in DAL.cs nullreference was unhandled by code in connectionstring

March 20, 2013 at 12:29 AM


15 of 18 17-05-2013 PM 02:23

110

111

112

113

114

115

116

117

nandy said...

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...

namespace BLclass

{

public class BLPerson

{

public string RegisterUser(PersonInfo entityObj)

{

PersonDALclass dalObj = new PersonDALclass();

try

{

return dalObj.RegisterUser(entityObj);

}


{

throw ex;

}

finally

{

dalObj = null;

}

}

}

whats wrong in this code.

March 24, 2013 at 2:36 AM

Kapil Jangra said...

thanks alot dear suresh for your fruitful postings.

March 31, 2013 at 10:01 PM

Rajesh Narra said...

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...

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...

Good Job Suresh........Awesome Explanation in all your tutorials....

April 16, 2013 at 3:54 AM

seema darade said...

thanks....It's good explanation.....

April 16, 2013 at 8:52 AM

Anonymous said...

nice

April 25, 2013 at 4:44 AM

Anonymous said...


16 of 18 17-05-2013 PM 02:23

Newer Post Older Post

Give your Valuable Comments

Comment as:

Home

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

118

119

120

121

122

123

124

125

126

nice

April 25, 2013 at 4:45 AM

Anonymous said...

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...

So good site for us..thanks this site..

April 29, 2013 at 7:47 AM

Pradeep said...

its very usefull to all

May 7, 2013 at 12:26 AM

Anonymous said...

Good one,Very Useful

May 7, 2013 at 1:17 PM

Web Master said...

Hi,

DO I need to create seperate classes for each table in BEL class ?

May 8, 2013 at 3:17 AM

Imtiyaz Jamadar said...

This is one of the best site I ever seen ..

May 10, 2013 at 9:25 PM

Bhusan said...

CODE FOR SAVING RADIO BUTTON (DAL,BAL & PRESENTATION LAYER)VALUE IN 3 TIER

KINDLY REPLY

May 11, 2013 at 8:45 AM

jackson said...

Thanks alot suresh... awesome explanation..

May 15, 2013 at 9:37 AM


17 of 18 17-05-2013 PM 02:23

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.


18 of 18 17-05-2013 PM 02:23

3 tier architecture example in asp.net with c# - asp.net,c#

Documents