Intelligentedu

75 ASP.Net Data Access Tutorials
Posted: June 6th, 2009, 6:58pm CEST by computer_teacher

Tags:    [edit]

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#