A2Z Dotnet

Gain & Share Dotnet Knowledge.

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.


October 1, 2008 Posted by | General | , | Leave a comment

Learn SQL

Learn SQL Basics.

Download Basic SQL

Complete Sql Interview Questions with Answers ( Prepared By Pinaldave, SqlAuthority.com)

SQL Server Database Guidelines Complete and Coding Standards List – By Pinaldave, SqlAuthority.com

The Best blog for all Sql Queries http://blog.sqlauthority.com/ .

Note: By Clicking the above link, you will redirect to source provider.

August 12, 2008 Posted by | .Net Books | | 1 Comment


LINQ to SQL: .NET Language-Integrated Query for Relational Data


LINQ to SQL provides a runtime infrastructure for managing relational data as objects without losing the ability to query. Your application is free to manipulate the objects while LINQ to SQL stays in the background tracking your changes automatically.


 Download LINQ To SQL

July 29, 2008 Posted by | General | , | Leave a comment


%d bloggers like this: