Home > Data Access / ADO.NET

---

This section of the workshop covers developing data-based Web applications using ActiveX^® Data Objects in the .NET Framework ( ADO.NET ).

Expand All

ADO.NET Primer ADO.NET Data Providers Setting up ASP.NET Pages for Data Access Core ADO.NET Classes Data Source Controls Overview Introduction to Data Source Controls Binding to Data Using a Data Source Control Caching Data Using Data Source Controls Filtering Data Using Data Source Controls Modifying Data Using Data Source Controls Sorting Data with Data Source Controls Using Parameters with Data Source Controls Connecting to a Database Commands Retrieving Data Using a DataReader Retrieving Data Using a DataSet Retrieving XML Data Using a DataSet Displaying information from a database Displaying Data in a Repeater Control Displaying Data in a DataList Control Displaying Data in a DataGrid Selecting information from a database Retrieving data from user specified queries Retrieving data from any source Updating Data at the Database Level Adding a new record Editing an existing record Deleting an existing record Understanding and Using Views Creating a view Extending the Functionality of Views Sample Applications Using Views Comparison of Queries and Views Structured Query Language (SQL) Basics Introduction to Queries SQL Basic Concepts SQL Select: Specifying Data to be Included in a Query SQL Where: Specifying a Filter Condition SQL Join On: Selecting Data From More Than One Table SQL Group By: Grouping Data in Qquery Results SQL Order By: Sorting Data in Query Results Using SQL Aggregate Functions Optimizing Queries

System.Data   System.Data.Common   System.Data.OleDb   System.Data.SqlClient

NOTE: This section is currently under major reconstruction. Please bear with whatever inconvenience you may encounter; we hope to complete the job at the soonest possible time.