Three tier Architecture of ASP_Net

Three tier Architecture of ASP_Net

• 1.
  Three Tier Architecturein ASP.NET [email_address]
• 2.
  Our Discussion Whatis a 3-Tier concept. What are the various layers. Application layer. Business Logic Layer Data Layer [email_address]
• 3.
  Know How ofTools 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) [email_address]
• 4.
  General 3-Tier Structure[email_address]
• 5.
  .NET 3-TIER Structure[email_address]
• 6.
  Three layers Presentationtier: 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. [email_address]
• 7.
  Creating ASP. Netproject [email_address]
• 8.
  Source of DBDB 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 [email_address]
• 9.
  Connecting to DB[email_address]
• 10.
  The data accesslayer has four Methods: GetCategories() GetProducts() GetProductsByCategoryID(categoryID) GetProductByProductID(productID) [email_address]
• 11.
  Typed Dataset andTable Adapter [email_address]
• 12.
  Table Adapters TableAdaptersprovide 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 [email_address]
• 13.
  Database Name [email_address]
• 14.
  Connection string [email_address]
• 15.
  Query [email_address]
• 16.
  [email_address]
• 17.
  [email_address]
• 18.
  User defined queries[email_address]
• 19.
  [email_address]
• 20.
  Samples The DataTablesreturned 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(); } } [email_address]
• 21.
  Adding parameterized methods[email_address]
• 22.
  Insert,Update and DeleteSAMPLE 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(…); [email_address]
• 23.
  References http://msdn.microsoft.com/ http://aspnet.4guysfromrolla.comhttp://www.asp.net For my latest updates: http://www.cognobytes.com/biswadipgoswami/Default.aspx [email_address]