Three Tier Architecture in ASP.NET : Three Tier Architecture in ASP.NET biswadip@cognobytes.com
Our Discussion : Our Discussion What is a 3-Tier concept.
What are the various layers.
Application layer.
Business Logic Layer
Data Layer biswadip@cognobytes.com
Know How of Tools : Know How of Tools Tools used:
Visual Web Developer 2005 (Free)
Visual Studio 2005 (Paid)
Databases used:
MS SQL Server 2005
MS ACCESS 2003/2007 (with MS-Office package) biswadip@cognobytes.com
General 3-Tier Structure : General 3-Tier Structure biswadip@cognobytes.com
.NET 3-TIER Structure : .NET 3-TIER Structure biswadip@cognobytes.com
Three layers : Three layers Presentation tier: The top most level of the application is the user interface(Web Browser). The main function of the interface is to translate tasks and results to something the user understands. This is also called the Application layer.
Logic Tier: This layer coordinates the application, processes commands, makes logical decisions and evaluations, and performs calculations, It also moves and processes data between the two surrounding layers.
Data tier: Here information is stored and retrieved from a database management system. The information is then passed back to the logic tier for processing and then eventually back to the user. biswadip@cognobytes.com
Creating ASP. Net project : Creating ASP. Net project biswadip@cognobytes.com
Source of DB : Source of DB DB used with this is the Default NorthWind Database which can be downloaded from here
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en biswadip@cognobytes.com
Connecting to DB : Connecting to DB biswadip_g@hotmail.com
Slide 10 : The data access layer has four Methods:
GetCategories()
GetProducts()
GetProductsByCategoryID(categoryID)
GetProductByProductID(productID) biswadip_g@hotmail.com
Typed Dataset and Table Adapter : Typed Dataset and Table Adapter biswadip@cognobytes.com
Table Adapters : Table Adapters TableAdapters provide communication between your application and a database. More specifically, a TableAdapter connects to a database, executes queries or stored procedures, and either returns a new data table populated with the returned data or fills an existing DataTable with the returned data. TableAdapters are also used to send updated data from your application back to the database.
Generic Structure :
TableAdapter.Fill
TableAdapter.Update
TableAdapter.GetData
TableAdapter.Insert
TableAdapter.ClearBeforeFill biswadip@cognobytes.com
Database Name : Database Name biswadip@cognobytes.com
Connection string : Connection string biswadip@cognobytes.com
Query : Query biswadip@cognobytes.com
Slide 16 : biswadip@cognobytes.com
Slide 17 : biswadip@cognobytes.com
User defined queries : User defined queries biswadip@cognobytes.com
Slide 19 : biswadip@cognobytes.com
Samples : Samples The DataTables returned by the TableAdapter can be bound to ASP.NET data Web controls, such as the
GridView,
DetailsView,
DropDownList,
CheckBoxList, and several others.
Sample Code:>> AllProducts.aspx.cs
using NorthwindTableAdapters;
public partial class AllProducts : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{ ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); GridView1.DataSource = productsAdapter.GetProducts();
GridView1.DataBind();
} } biswadip@cognobytes.com
Adding parameterized methods : Adding parameterized methods biswadip@cognobytes.com
Insert,Update and Delete : Insert,Update and Delete biswadip@cognobytes.com SAMPLE CODE:>>
ProductsTableAdapter productsAdapter = new ProductsTableAdapter();
// Delete the product with condition
productsAdapter.Delete(…);
// Update a record with condition
productsAdapter.Update(…);
// Add a new product
productsAdapter.Insert(…);
References : References http://msdn.microsoft.com/
http://aspnet.4guysfromrolla.com
http://www.asp.net
For my latest updates:
http://www.cognobytes.com/biswadipgoswami/Default.aspx biswadip@cognobytes.com