Data Access Tutorial

Welcome to a series of tutorials that will explore techniques for implementing these common Data Access patterns in ASP.NET 2.0. These tutorials are geared to be concise and provide step-by-step instructions with plenty of screen shots to walk you through the process visually.

Learn how to create the Data Access Layer (DAL), using typed DataSets, to access the information in a database. Download  Creating Data Accesslayer article.

Learn how to centralize your business rules into a Business Logic Layer (BLL) that serves as an intermediary for data exchange between the presentation layer and the DAL. Download Creating Business Logic Layer article.

One common characteristic of user-friendly websites is that they have a consistent, site-wide page layout and navigation scheme. This tutorial looks at how you can create a consistent look and feel across all pages that can easily be updated. Download about Master Pages and Site Navigation.

To provide flexibility, the GridView offers the TemplateField, which renders using a template. A template can include a mix of static HTML, Web controls, and databinding syntax. In this tutorial we’ll examine how to use the TemplateField to achieve a greater degree of customization with the GridView control. Download  Using Template Fields in Gridview Control article.

Learn how to configure the SqlDataSource to insert, update, and delete data. Download An Overview of Inserting,Updating and Deleting Data with SqlDataSource article.

Learn how to map an ObjectDataSource’s Insert(), Update(), and Delete() methods to the methods of BLL classes, as well as how to configure the GridView, DetailsView, and FormView controls to provide data modification capabilities. Download An Overview of Inserting,Editing, Deleting Data Article.

In the interfaces we’ve created so far, a user can accidentally delete data by clicking the Delete button when they meant to click the Edit button. In this tutorial we’ll add a client-side confirmation dialog box that appears when the Delete button is clicked. Download Adding Client Side Confirmation when Deleting article.

Paging and sorting are two very common features when displaying data in an online application. In this tutorial we’ll take a first look at adding sorting and paging to our reports, which we will then build upon in future tutorials. Download Paging and Sorting Report Data article.

Learn how to allow users to upload binary files (such as Word or PDF documents) to your Web site where they may be stored in either the server’s file system or the database. Download Uploading Files in Binary Format  article.

Learn how to create a Web interface that allows the user to both enter text data and upload binary files. To illustrate the options available to store binary data, one file will be saved in the database while the other is stored in the file system. Download Including a FileUpload option when Adding a New Record article.

In earlier tutorials we have created SQL statements in our code and passed the statements to the database to be executed. An alternative approach is to use stored procedures, where the SQL statements are pre-defined at the database. In this tutorial we learn how to have the TableAdapter Wizard generate new stored procedures for us. Download  Creating New Stored Procedures for the Typed Dataset’s Table Adapter article.

Learnn ObjectDataSource control Using this control you can bind data retrieved from the BLL created in the previous tutorial without having to write a line of code! Download Displaying Data with Object Data Source article.

Learn how to use a parameter set to a hard-coded value to select the data to display in a DetailsView control. Download Declarative Paramters article.

Look at adding a method to our DAL and BLL that accepts a single input parameter and returns data. The example will set this parameter programmatically. Downlaod Programmatically Setting the Object Data Sources Parameter article.

Learn  how to display the master records in a DropDownList control and the details of the selected list item in a GridView. Download Master/Detail Filtering With a Dropdownlist Article.

MVC

Tutorials about ASP.NET MVC Framework.

See Asp.Net MVC Framework Videos .

This tutorial is a great introduction for people who are new to the ASP.NET MVC Framework and who want to get a sense of the process of building an ASP.NET MVC application. Creating a Tasklist Application with ASP.NET MVC

Confused about Models, Views, and Controllers? In this tutorial, Stephen Walther introduces you to the different parts of an ASP.NET MVC application. Understanding Models, Views, and Controllers

In this tutorial, u’ll see  ASP.NET MVC controllers. You learn how to create new controllers and return different types of action results. Understanding Controllers, Controller Actions, and Action Results

What is an ASP.NET MVC View and how does it differ from a HTML page? In this tutorial, Stephen Walther introduces you to Views and demonstrates how you can take advantage of View Data and HTML Helpers within a View. Understanding Views, View Data, and HTML Helpers

In this tutorial, u’ll learn how browser requests get mapped to controller actions through URL Routing. You also learn how to create a custom route that displays different blog entries depending on the date passed in a URL. An Introduction to URL Routing

Prevent JavaScript Injection Attacks and Cross-Site Scripting Attacks from happening to you. In this tutorial, Stephen Walther explains how you can easily defeat these types of attacks by HTML encoding your content. Preventing JavaScript Injection Attacks

Learn how to create unit tests for controller actions. In this tutorial, Stephen Walther demonstrates how to test whether a controller action returns a particular view, returns a particular set of data, or returns a different type of action result. Creating Unit Tests for ASP.NET MVC Applications

In this tutorial, you learn how to use ASP.NET MVC, and URL Routing, with different versions of Internet Information Services. You learn different strategies for using ASP.NET MVC with IIS 7.0 (classic mode), IIS 6.0, and earlier versions of IIS. Using ASP.NET MVC with Different Versions of IIS

WPF(Windows Presentation Foundation)

Windows Presentation Foundation (WPF) provides developers with a unified programming model for building rich Windows smart client user experiences that incorporate UI, media, and documents… more.

Downalod

 A2z About WPF Article

WPF_Wrox Professional WPF Programming Book

Aress.Pro.WPF in Csharp 2008 Book 

See WPF Videos