These 75 ASP
.Net Data Access Tutorials at asp.net explain in
detail techniques for implementing the 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. The tutorials are constructed in such a
manner that both VB and C# developers will find it easy to follow
different topics.
Introduction
In the introductory tutorials, the topics covered are creating the Data
Access Layer (DAL) to access the information in a database, how to
centralize your business rules into a Business Logic Layer (BLL).
- 1.
Creating a Data Access Layer C#
- 2.
Creating a Business Logic Layer C#
- 3.
Master Pages and Site Navigation C#
Basic
Reporting
These tutorials discuss topics like displaying data with the
ObjectDataSource control, declarative parameters and programmatically
setting the ObjectDataSource's parameter values.
- 4.
Displaying Data With the ObjectDataSource C#
- 5.
Declarative Parameters C#
- 6.
Programmatically Setting the ObjectDataSource's
Parameter Values C#
Master/Detail
These ASPdotNET tutorials examine topics like how to display the master
records in a DropDownList control and the details of the selected list
item in a GridView, the master/detail relationship to add a third layer
etc.
- 7.
Master/Detail Filtering With a DropDownList C#
- 8.
Master/Detail Filtering With Two DropDownLists C#
- 9.
Master/Detail Filtering Across Two Pages C#
- 10.
Master/Detail Using a Selectable Master GridView
with a Details DetailView C#
Custom
Formatting
These tutorials teach topics such as how to accomplish data bound
formatting through the use of the DataBound and RowDataBound event
handlers, achieving a greater degree of customization with the GridView
and DetailsView controls etc.
- 11.
Custom Formatting Based Upon Data C#
- 12.
Using TemplateFields in the GridView Control C#
- 13.
Using TemplateFields in the DetailsView Control C#
- 14.
Using the FormView's Templates C#
- 15.
Displaying Summary Information in the GridView's
Footer C#
Editing,
Inserting, and Deleting Data
These ASPdotNETtutorials examine topics like inserting, updating and
deleting data, examining the events associated with it, handling BLL
and DAL exceptions, adding validation controls to the editing and
inserting interfaces and limiting data modification functionality based
on the user.
- 16.
An Overview of Inserting, Updating, and
Deleting Data C#
- 17.
Examining the Events Associated with Inserting, Updating, and Deleting C#
- 18.
Handling BLL- and DAL-Level Exceptions in an ASP.NET Page C#
- 19.
Adding Validation Controls to the Editing and Inserting Interfaces C#
- 20.
Customizing the Data Modification Interface C#
- 21.
Implementing Optimistic Concurrency C#
- 22.
Adding Client-Side Confirmation When Deleting C#
- 23.
Limiting Data Modification Functionality Based on the User C#
Paging
and Sorting
These tutorials demonstrate topics such as paging and sorting report
data, efficiently paging through large amounts of data, sorting custom
paged data and creating a customized sorting user interface.
- 24.
Paging and Sorting Report Data C#
- 25.
Efficiently Paging Through Large Amounts of Data C#
- 26.
Sorting Custom Paged Data C#
- 27.
Creating a Customized Sorting User Interface C#
Custom
Button Actions
This tutorial shows how to create custom button actions in a GridView.
- 28.
Adding and Responding to Buttons to a GridView C#
Displaying
Data
with the DataList and Repeater
These tutorials discuss topics like displaying data with the DataList
and Repeater controls, formatting the DataList and Repeater controls
based upon data, showing multiple records per row with the DataList
Control and nested data web controls.
- 29.
Displaying Data with the DataList and
Repeater Controls C#
- 30.
Formatting the DataList and Repeater Based
Upon Data C#
- 31.
Showing Multiple Records per Row with the DataList
Control C#
- 32.
Nested Data Web Controls C#
Filtering
Scenarios with the DataList
and Repeater
These tutorials examine using different filtering scenarios with the
DataList and Repeater controls. This section also covers the
master/detail filtering with a DropDownList, master/detail filtering
across two pages and master/detail using a bulleted list of master
records with a Details DataList
- 33.
Master/Detail Filtering With a DropDownList C#
- 34.
Master/Detail Filtering Across Two Pages C#
- 35.
Master/Detail Using a Bulleted List of Master Records with a Details
DataList C#
Editing
and Deleting Data Through
the DataList
These tutorials demonstrate ASPdotNET techniques like editing and
deleting data in the DataList, performing batch updates, handling BLL
and DAL level exceptions, adding validation controls to the DataList's
editing interface, customizing the DataList's editing interface etc.
- 36.
An Overview of Editing and Deleting Data in
the DataList C#
- 37.
Performing Batch Updates C#
- 38.
Handling BLL- and DAL-Level Exceptions C#
- 39.
Adding Validation Controls to the DataList’s
Editing Interface C#
- 40.
Customizing the DataList’s Editing Interface C#
- 41.
Implementing Optimistic Concurrency C#
- 42.
Adding Client-Side Confirmation When Deleting C#
- 43.
Limiting Data Modification Functionality Based on the User C#
Paging
and Sorting with the DataList
and Repeater
These tutorials shows how to create paging report data in a DataList or
Repeater control and how to sort data in a DataList or Repeater control.
- 44.
Paging Report Data in a DataList or
Repeater Control C#
- 45.
Sorting Data in a DataList or Repeater Control C#
Custom
Button Actions with the DataList
and Repeater
This tutorial examines the topic of custom button action with the
DataList and Repeater controls.
- 46.
Custom Buttons in the DataList and Repeater C#
Accessing
the Database
Directly from an ASP.NET Page
These tutorials examine topics like querying data with the
SqlDataSource control, using parameterized queries with the
SqlDataSource control, inserting, updating and deleting data with the
SqlDataSource control and implementing optimistic concurrency with the
SqlDataSource control.
- 47.
Querying Data with the SqlDataSource Control C#
- 48.
Using Parameterized Queries with the SqlDataSource C#
- 49.
Inserting, Updating, and Deleting Data with the SqlDataSource C#
- 50.
Implementing Optimistic Concurrency with the SqlDataSource C#
Enhancing
the GridView
These tutorials show ASPdotNET techniques such as adding a
GridView column of radio buttons and checkboxes and inserting a new
record from the GridView's footer.
- 51.
Adding a GridView Column of Radio Buttons C#
- 52.
Adding a GridView Column of Checkboxes C#
- 53.
Inserting a New Record from the GridView’s
Footer C#
Working
with Binary Files
These tutorials examine these techniques: uploading binary files,
displaying binary data in the data web controls, including a file
upload option when adding a new record and updating, deleting existing
binary data.
- 54.
Uploading FilesC#
- 55.
Displaying Binary Data in the Data Web Controls C#
- 56.
Including a File Upload Option When Adding a New Record C#
- 57.
Updating and Deleting Existing Binary Data C#
Caching
Data
These tutorials teach topics like caching data with the
ObjectDataSource, caching data in the architecture and application
startup and using SQL cache dependencies.
- 58.
Caching Data with the ObjectDataSource C#
- 59.
Caching Data in the Architecture C#
- 60.
Caching Data at Application Startup C#
- 61.
Using SQL Cache Dependencies C#
Database-Driven
Site Maps
This tutorial shows how to build a custom database driven site map
provider.
- 62.
Building a Custom Database-Driven Site Map Provider C#
Working
with
Batched Data
These tutorials demonstrate techniques with working with batched data
and wrapping database modifications within a transaction
- 63.
Wrapping Database Modifications within a Transaction C#
- 64.
Batch Updating C#
- 65.
Batch Deleting C#
- 66.
Batch Inserting C#
Advanced
Data
Access Scenarios
These tutorials teach topics of advanced data access scenarios. The
topics include creating new stored procedures, using existing stored
procedures, updating the TableAdapter to use JOINs, adding additional
DataTable columns, working with computed columns, debugging stored
procedures and creating stored procedures and user defined functions
with manages code.
- 67.
Creating New Stored Procedures for the Typed DataSet’s
TableAdapters C#
- 68.
Using Existing Stored Procedures for the Typed DataSet’s
TableAdapters C#
- 69.
Updating the TableAdapter to Use JOINs C#
- 70.
Adding Additional DataTable Columns C#
- 71.
Working with Computed Columns C#
- 72.
Configuring the Data Access Layer’s Connection- and Command-Level
Settings C#
- 73.
Protecting Connection Strings and Other Configuration Information C#
- 74.
Debugging Stored Procedures C#
- 75.
Creating Stored Procedures and User-Defined Functions with Managed
Code C#
Popularity: 4% [?]
Related Posts:37 ASP.NET AJAX Video TutorialsFree ASP.NET Books and eLearning CourseFree ASP.NET Training Course11 Ebooks on Web Development, AJAX, ASP.NET, C++, C#, and XSLTASP.NET and Visual Basic .NET Tutorials
Tags for this post>>
ASP.NET |
dotNET
