Home > Data Access in Web Forms

---

This section covers the basic concepts on developing applications that allow users to interact with databases in Web Forms pages.

Expand All

Web Forms Data Model 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 Filtering Data Using Data Source Controls Using Parameters with Data Source Controls Modifying Data Using Data Source Controls Sorting Data with Data Source Controls Caching Data Using Data Source Controls Connecting to a Database Securing Connection Strings Issuing Commands to a Database Retrieving Data Using a DataReader Retrieving Data Using a DataSet Retrieving XML Data Using a DataSet Calling Data Functions in Code Behind Displaying Information From a Database Displaying Data in a Repeater Displaying Data in a DataList Displaying Data in a DataGrid Displaying Data in a GridView Selecting Information From a Database Retrieving Data From User Specified Queries Passing Variables to the Select Query Retrieving Data From Database Schema 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.