.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to separate Presentation Layer, DA Layer and BLL?

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :ASP.Net
Hello Everyone, Can anyone help me to understand how to separate layers in 3-tier architecture if it is possible here? I have a form (Default.aspx) that collects the user inputs (txtFirstName, txtLastName, txtStreetAddress, txtCity and txtZipCode) and save into a table (tblStudentInfo) and display that data into the GridView, Form View and Datalist. I have four buttons on this page. First one is the "Submit" button to submit the data into Database. Other three buttons are to display the data either in GridView, FormView or DataList. When users click on one of these three buttons it will redirect the user to Display.aspx, formview.aspx and datalist.aspx. This page also contains label to show the message weather the insertion was successful or not. "tblStudentInfo" has following definition. tblStudentID--------int--------Primary key tblFirstName-------varchar(50) tblLastName-------varchar(50) tblStreetAddress---varchar(200) tblCity--------------varchar(100) tblZipCode--------varchar(10) Stored Procedure: "InsertStudentInfo" ALTER PROCEDURE dbo.InsertStudentInfo         (@tblFirstName VARCHAR(50),         @tblLastName   VARCHAR(50),         @tblStreetAddress VARCHAR(200),         @tblCity VARCHAR(100), &

View Complete Post

More Related Resource Links

Beyond ASP: XML and XSL-based Solutions Simplify Your Data Presentation Layer


The combination of XML and XSL can provide a powerful alternative to ASP development. This article presents arguments for building even small-scale Internet applications on the XML model. An example written with traditional ASP programming is compared to the same example written with XML and XSL in order to show the benefits of this approach. The example is followed by nine good reasons to make the switch. These reasons include separation of presentation and data, reusability, extensibility, division of labor, enhanced testing, and legacy integration. The XML/XSL solutions described hold the promise of greater simplicity, flexibility, and durability than ASP solutions built the traditional way.

Scott Howlett and Jeff Dunmall

MSDN Magazine November 2000

Validation on the presentation layer in Web Forms


Hi I normally do 3 tier systems with the business logic in the middle layer as is fairly normal. One thing I've never really been happy with is validation on the presentation layer. For instance say I have a text box where users type in a date for e.g. Date of Birth, which maps onto a DOB property of type date. Where is the best place to validate it is a date. I'd like to do it in the BLL but I can't really do that because I need to convert it to a date and it might not parse. However doing some separate presentation layer validation seems messy. Is there a recommended way of doing this?

Generic list of custom class returns data in WCF service layer, but loses them in Presentation Layer


I'm reading this excellent article by John Papa in MSDN Data Points - http://msdn.microsoft.com/en-us/magazine/cc700340.aspx

This single article alone sheds great deal of light on EF, WCF, WPF, MVP architecture, Layered Architecture with these technologies and so much more.

I'm trying to experiment with the code that comes with the article as is.

When executing the application, the service layer returns a Generic List with three Customer objects to the presentation layer. However, in presentation layer, the Generic list arrives with zero objects in the list. In the context of this application, I provide 'd' as a search criteria and hit the search button; while stepping through, I can see it returns 3 rows from the database.

With my limited experience in WCF, I am unable to figure out why it is so. This article was written  for 3.5 SP1 Beta 1. Could something changed in the general release that is causing this?

-Perennial Newbie-

Cutting Edge: Building A Secure AJAX Service Layer


This month Dino builds a service layer that authenticates users of Silverlight 2 and ASP.NET AJAX services to prevent illegal access to sensitive back-end services.

Dino Esposito

MSDN Magazine September 2008

Easy UI Testing: Isolate Your UI Code Before It Invades Your Business Layer


The User Interface Process Application Block (UIP) from the Microsoft Patterns & Practices team can help you isolate your UI, write unit tests for your UI logic, and write a UI that really is the thin layer it was always meant to be. Mark Seemann shows you how it's done in this article.

Mark Seemann

MSDN Magazine August 2005

Know Thy Code: Simplify Data Layer Unit Testing using Enterprise Services


If you want to employ unit testing and test-driven development techniques in your database application development process, you'll have different factors to consider than you do when you're not involving a database. For example, you have to maintain a consistent state within the database and be able to roll back transactions when necessary. This article shows you how to get the best of unit testing for your database apps in a safe, usable manner.

Roy Osherove

MSDN Magazine June 2005

Data Access: Implement a Data Access Layer for Your App with ADO.NET


Implementing data access functionality is a core activity of most developers working with the .NET Framework, and the data access layers they build are an essential part of their applications. This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET Framework. The tips include taking advantage of object-oriented techniques and the .NET Framework infrastructure by using base classes, making classes easily inheritable by following guidelines, and carefully examining your needs before deciding on a presentation method and external interface.

Dan Fox

MSDN Magazine April 2003

.NET Reflection: Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET M


One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that generates a SQLCommand object based on the metadata of a method. Using this library, you'll be on your way to automating the generation of stored procedures.

Atif Aziz

MSDN Magazine August 2002

MSLU: Develop Unicode Applications for Windows 9x Platforms with the Microsoft Layer for Unicode


The Microsoft Layer for Unicode (MSLU) provides Unicode support on Windows platforms that don't provide their own support, including Windows 98, Windows 95, and Windows Me. With MSLU you can write Unicode applications easily for these platforms. MSLU is simple to install, small (even though it wraps more than 400 APIs), and easy on system resources. This article explains the design criteria behind MSLU and how to put the layer to work for you.

Michael Kaplan and Cathy Wissink

MSDN Magazine October 2001

Secure Sockets Layer: Protect Your E-Commerce Web Site with SSL and Digital Certificates


Security is one of the most important factors in the future growth of e-businesses. Making sure that communications remain secure between customers and the Web server is a critical issue. Secure Sockets Layer (SSL) is the standard that secure Web sites are built upon today. This article presents an overview of SSL-based Web security, explaining such fundamental concepts as digital certificates and their distribution, encryption, and the proper configuration of Microsoft Internet Information Services (IIS). Acquiring a certificate, installing it, and configuring IIS for SSL are outlined in a step-by-step process.

John Papa

MSDN Magazine April 2001

Webservice using socket layer programming



   I want to access a webservice in asp.net programming. This webservice was done using socket layer programming and also i am having the ipaddress and port address. Did any one know about how to access webservice using socket layer and if know let me know how to access the webservice. Thank you

is there any impact of using static methods in Business Access layer in 3 tier applciation


is there any impact of using static methods in Business Access layer in 3 tier applciation,

Please suggest me what are the best practices and standards

What is the difference between component,tier and layer?

We often heard about these word  like component, tier, layer of an asp.net application. Please explain the difference between  component , tier and layer?We often heard about these word  like component, tier, layer of an asp.net application.Please explain the difference between  component , tier and layer?

Package 'DataWarehouse VSIntegration layer' has failed to load properly

Hi, In my VSTS, I am not able to create a new SSIS project. When VSTS Opens It gives me following error: --------------------------- Microsoft Visual Studio --------------------------- Package Load Failure Package 'DataWarehouse VSIntegration layer' has failed to load properly ( GUID = {4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1} ). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. --------------------------- Yes   No   ---------------------------   Also, in Tools the options for Business Intelligence designer is missing.   Please help me!!Sonia Mawandia http://sqldeveloper-sonia.blogspot.com/

Issue with Data Access Layer DLL

Hi, I am working on a project in which I have made changes to LINQ to SQL code in data access layer project. Initially the code was using Single() extension method, I have changed it to SingleOrDefault() was earlier method was throwing exception if no records found in db. After making changes I ran the project but during debugging VS 2008 was showing that file is changed and do you want to reload the file box. When selected the file, the debugger was still executing the commented code (Single() method). I tried cleaning the entire solution and rebuilding it but it did not help. All the projects (Presentation, BL, DAL) are under single solution. Can any one please help me to solve the issue? Thanks in advance.

Need help: "Adding Parameterized Methods to the Data Access Layer"

Hi all, em all new in C# and .NET.I am following this tutorial: http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-csAnd i am at step 3: Adding Parameterized Methods to the Data Access Layer - i have No problems in getting out all information from my database.But when i try to get a specific item by CategoryID i get a Error.This is what i type in my Query in the table adapter:SELECT     ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, DiscontinuedFROM         ProductsWHERE CategoryID = @CategoryIDHere is the error i get when i click finish:The wizard detected the following problems when configuring TableAdapter Query "FillByCategoryID":Details:             Generated SELECT statement.              Error in WHERE clause near '@'.              Unable to parse query text.Can anyone help me with this problem?Someone who knows what i am doing wrong?Thanks

"The Windows Security layer always falls back to NTLM when connections are made locally"

Using Kerberos with SQL Server tells (in Comments): "Il-Sung Lee 27 Nov 2006 4:12 PM The Windows Security layer always falls back to NTLM when connections are made locally.  This appears to be the design of SSPI when NEGOTIATE is used so what you are seeing is expected" And how to avoid "NEGOTIATE"? I am curious about 2 aspects: 1) Why BEGOTIATE is used for local connections? What os the point in it for internal connections? 2) Does it mean that I cannot force/trick into using  Kerberos developing against local SQL Sever?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend