asp.net.ph : ADO.NET Primer: Structured Query Language ( SQL ) Basics

asp.net.ph

Home
Getting Started

Getting Started
ASP.NET Primer

Authoring an ASP.NET Page
Publishing ASP.NET Files
Introducing ASP.NET Web Forms
Introducing Web Forms Server Controls

ASP.NET Syntax

ASP.NET Page Syntax

Code Declaration Blocks
Code Render Blocks
Custom Server Control Syntax
Data Binding Expression Syntax
Page Directives Syntax
Server-Side Comments
Server Control Inline Template Syntax
Server-Side Include Directive Syntax
Server-Side Object Tag Syntax

ASP.NET Syntax for HTML Controls

HtmlAnchor
HtmlButton
HtmlForm
HtmlGenericControl
HtmlImage
HtmlInputButton
HtmlInputCheckBox
HtmlInputFile
HtmlInputHidden
HtmlInputImage
HtmlInputRadioButton
HtmlInputText
HtmlSelect
HtmlTable
HtmlTextArea

ASP.NET Syntax for Web Server Controls
ASP.NET Syntax for Validation Controls
ASP.NET Configuration Sections
Global.asax Syntax

ASP.NET Programming Languages Primer

Statements
Comments
Variable Declarations and Initialization
Arrays
Controlling Program Flow
If Statements
The Conditional ? : Operator
Switch Statements
For Loops
While Loops
Foreach Loops
Reusable Statements

ASP.NET Base Types

Converting Types

Base Data Types Table
Type Conversion Tables

Formatting Base Types
Format Specifiers and Providers

Date and Time Format Strings
Numeric Format Strings
Enumeration Format Strings
Customizing Format Strings

Parsing Strings

Parsing Numeric Strings
Parsing Date and Time Strings
Parsing Other Strings

Basic String Operations

Creating New Strings
Trimming and Removing Characters
Padding Strings
Comparing Strings
Changing Case
Using The StringBuilder Class

Regular Expressions

Regular Expressions as a Language
Details of Regular Expression Behavior

Matching Behavior
Backreferences
Backtracking
Nonbacktracking Lookahead and Lookbehind
Quantifiers and Empty Matches
Next Match After an Empty Match
Compilation and Reuse
Thread Safety

Regular Expression Examples

Example: Changing Date Formats
Example: Extracting navigateurl Information
Example: Scanning for HREFs

Web Forms

ASP.NET Web Forms
ASP.NET Web Forms Overview
Web Forms Server Controls

Web Forms Server Controls overview
Controls You Can Use on Web Forms

ASP.NET Data Controls
ASP.NET Data Source Controls
ASP.NET HTML WebControls
ASP.NET Login Controls
ASP.NET Navigation Controls
ASP.NET Standard Controls

Programming Web Forms Server Controls
Web Forms Server Controls Templates
Web Forms Server Controls and CSS Styles
Web Forms Validation
Web Forms User Controls

Data Binding in Web Forms

Introduction to Data Binding in Web Forms
Data Binding Expressions for Web Forms Pages
Data Binding HTML Server Controls

Programming Web Forms

Web Forms Page Processing Stages
Web Forms Events and Handlers
Web Forms State Management

ASP.NET Master Pages

Introduction to Master Pages
Nested Master Pages
Working with Master Pages Programmatically
Referencing Master Page Content
Events in Master and Content Pages

Data Access

Data Access / ADO.NET
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

Web Apps

ASP.NET Applications
ASP.NET Applications Overview

ASP.NET State Management

Application State
Session State

ASP.NET Optimization

ASP.NET Caching Features

Caching ASP.NET Pages

Caching Multiple Versions of a Page

Caching Portions of an ASP.NET Page

Caching Multiple Versions of User Control Output

Caching Application Data

Adding Items to the Cache
Retrieving Values of Cached Items
Deleting Items from the Cache
Notifying an Application When an Item is Deleted from the Cache

Setting the Output Cache Location

ASP.NET Trace Functionality

Page-level Tracing

Writing to the Trace Log
Displaying Trace Messages on the Page

Application-level Tracing

Enabling Application-level Tracing
Viewing Application-level Trace Information

Reading the Trace Log

Developing High-Performance ASP.NET Applications

Monitoring ASP.NET Application Performance
Performance Counters for ASP.NET

ASP.NET Configuration

Format of ASP.NET Configuration Files

ASP.NET Configuration Sections

Hierarchical Configuration Architecture

Configuration Inheritance
Limiting Inheritance with Settings
Locking Configuration Settings

Accessing Configuration Settings
Creating New Configuration Sections

ASP.NET Web Application Security

How ASP.NET Security Works
ASP.NET Architecture
ASP.NET Data Flow
ASP.NET Authentication

The WindowsAuthenticationModule Provider
The Passport Authentication Provider
The Forms Authentication Provider

The Forms Authentication Module
Forms Authentication Control Flow
Creating a Forms Authentication Ticket
Forms Authentication Credentials
Forms Authentication Utilities
Handling FormsAuthentication Events

ASP.NET Authorization
ASP.NET Impersonation
Designing Secure ASP.NET Applications

Using IIS Authentication With ASP.NET Impersonation
Simple Forms Authentication
Forms Authentication Using An XML Users File

ASP.NET Globalization and Localization

Globalization and Localization Primer
ASP.NET Web Page Resources
Using Resources in ASP.NET Web Pages
Setting the Culture for ASP.NET Pages

Web Basics

Abakada: Back to Basics
So You Wanna Build a Web Site

WWW ~ An Overview
Getting Started
Online HyperText Basics
Conceptualizing Your Web
Enhancing Web Site Usability and Appeal
Getting It Together

Authoring Your Web Pages

Web Authoring Basics
Understanding HTML
Using Style Sheets
HTML Elements
Anchors and Links
Using Tables
Frames and Framesets
Using Forms

Basic Scripting

JavaScript Overview
JavaScript Components
JavaScript Basics

Assignment Operators
Comparison Operators
Arithmetic Operators
Bitwise Operators
Logical Operators
String Operators
Special Operators

Programmimg With JavaScript
Data Entry Validation

Check if all form fields are filled out
Checking for alphabet entries only
Checking for numeric entries only
Checking for a valid range of values
Rounding a number to n decimals
Checking for valid date input

Dynamic HTML

DHTML Overview
Understanding Events
Handling Events
Events Bubbling
Dynamic Styles
Dynamic Content
Dynamic Positioning
Working with Windows and Frames

Web Imaging Essentials

Computer Graphics Basics
Colors and Backgrounds
Animation Basics
Creating the Animated GIF File
Optimizing GIF Animation Files

Language References

HTML Elements Reference
HTML Element Attributes
CSS Reference Table
DOM Objects Reference
DOM Object Properties
DHTML Events Reference
DHTML Methods Reference
DHTML Collections Reference

Show Me Search

Thursday, January 9, 2025

Home > Data Access / ADO.NET > Structured Query Language (SQL) Basics

This section focuses on how to retrieve and update information stored in databases using Structured Query Language ( SQL ).

It is organized into the following references:

© 2025 Reynald Nuñez and asp.net.ph. All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note