How to separate Presentation Layer, DA Layer and BLL?

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),
&

More Related Resource Links

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.

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?

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?

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.

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.

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.

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.

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.

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.

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

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?

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/

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.

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

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?