System.Data.Common Namespace

asp.net.ph

Home
Getting Started

Getting Started
ASP.NET Primer

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

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

Web Forms Server Controls Templates
Web Forms Server Controls and CSS Styles
Web Forms Validation
Web Forms User Controls
Programming Web Forms Server 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

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

Programming Web Forms

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

Data Access

Data Access in Web Forms
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

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
Authoring Your Web Pages

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

Dynamic HTML

DHTML Overview
CSS Visual Effects

Understanding CSS Animations
Understanding CSS Filters
Understanding CSS Transforms
Understanding CSS Transitions

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

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

Language References

HTML Elements

A Element
ABBR Element
ACRONYM Element
ADDRESS Element
APPLET Element
AREA Element
ARTICLE Element
ASIDE Element
AUDIO Element
B Element
BASE Element
BASEFONT Element
BDI Element
BDO Element
BGSOUND Element
BIG Element
BLOCKQUOTE Element
BODY Element
BR Element
BUTTON Element
CANVAS Element
CAPTION Element
CENTER Element
CITE Element
CODE Element
COL Element
COLGROUP Element
HTML Comment Element
DATA Element
DATALIST Element
DD Element
DEL Element
DETAILS Element
DFN Element
DIALOG Element
DIR Element
DIV Element
DL Element
!DOCTYPE Element
DT Element
EM Element
EMBED Element
FIELDSET Element
FIGCAPTION Element
FIGURE Element
FONT Element
FOOTER Element
FORM Element
HEAD Element
HEADER Element
HGROUP Element
Hn Element
HR Element
HTML Element
HTML Comment Element
I Element
IFRAME Element
IMG Element
INPUT Element
INPUT type=button Element
INPUT type=checkbox Element
INPUT type=file Element
INPUT type=hidden Element
INPUT type=image Element
INPUT type=password Element
INPUT type=radio Element
INPUT type=reset Element
INPUT type=submit Element
INPUT type=text Element
INS Element
KBD Element
LABEL Element
LEGEND Element
LI Element
LINK Element
MAIN Element
MAP Element
MARK Element
MARQUEE Element
MENU Element
META Element
METER Element
NAV Element
NOFRAMES Element
NOSCRIPT Element
OBJECT Element
OL Element
OPTGROUP Element
OPTION Element
OUTPUT Element
P Element
PARAM Element
PICTURE Element
PLAINTEXT Element
PRE Element
PROGRESS Element
Q Element
RP Element
RT Element
RUBY Element
S Element
SAMP Element
SCRIPT Element
SECTION Element
SELECT Element
SMALL Element
SOURCE Element
SPAN Element
STRIKE Element
STRONG Element
STYLE Element
SUB Element
SUMMARY Element
SUP Element
TABLE Element
TBODY Element
TD Element
TEMPLATE Element
TEXTAREA Element
TH Element
THEAD Element
TIME Element
TITLE Element
TR Element
TRACK Element
TT Element
U Element
UL Element
VAR Element
VIDEO Element
WBR Element
XMP Element

HTML Element Attributes

ABBR Attribute
ACCEPT-CHARSET Attribute
ACCEPT Attribute
ACCESSKEY Attribute
ACTION Attribute
ALIGN Attribute
ALIGN Attribute
ALIGN Attribute
ALIGN Attribute
ALIGN Attribute
ALIGN Attribute
aLink Attribute
ALT Attribute
ASYNC Attribute
AUTOCAPITALIZE Attribute
AUTOCOMPLETE Attribute
AUTOCORRECT Attribute
AUTOPLAY Attribute
BACKGROUND Attribute
BACKGROUND Attribute
BACKGROUND Attribute
BACKGROUND Attribute
BALANCE Attribute
BEHAVIOR Attribute
BGCOLOR Attribute
BGCOLOR Attribute
BGPROPERTIES Attribute
BORDERCOLOR Attribute
BORDER Attribute
BORDER Attribute
BOTTOMMARGIN Attribute
CELLPADDING Attribute
CELLSPACING Attribute
CHARSET Attribute
@charset Rule
CHECKED Attribute
CITE Attribute
CLASSID Attribute
CLASS Attribute
CLEAR Attribute
CODE Attribute
CODEBASE Attribute
CODETYPE Attribute
COLOR Attribute
COLOR Attribute
COLSPAN Attribute
COLS Attribute
COLS Attribute
COLS Attribute
COMPACT Attribute
CONTENT Attribute
CONTROLS Attribute
COORDS Attribute
DATA Attribute
DEFER Attribute
DIR Attribute
DIRECTION Attribute
DIRECTION Attribute
DOWNLOAD Attribute
FACE Attribute
FRAME Attribute
FRAMEBORDER Attribute
FRAMESPACING Attribute
HEIGHT Attribute
HREF Attribute
HREFLANG Attribute
HREF Attribute
HREF Attribute
HREF Attribute
HSPACE Attribute
FOR Attribute
HTTP-EQUIV Attribute
ID Attribute
ISMAP Attribute
LANG Attribute
LANGUAGE Attribute
LEFTMARGIN Attribute
LINK Attribute
LOOP Attribute
LOOP Attribute
LOWSRC Attribute
Abakada DHTML Properties Reference: map Property
MARGINHEIGHT Attribute
MARGINWIDTH Attribute
MAXLENGTH Attribute
MEDIA Attribute
METHOD Attribute
METHODS Attribute
MULTIPLE Attribute
MUTED Attribute
NAME Attribute
NAME Attribute
NAME Attribute
NAME Attribute
NOHREF Attribute
NORESIZE Attribute
NOSHADE Attribute
NOWRAP Attribute
PING Attribute
PLUGINSPAGE Attribute
READONLY Attribute
REFERRERPOLICY Attribute
REL Attribute
REV Attribute
RIGHTMARGIN Attribute
ROWSPAN Attribute
ROWS Attribute
ROWS Attribute
Abakada CSS Properties Reference: ruby-align Attribute
Abakada CSS Properties Reference: ruby-overhang Attribute
Abakada CSS Properties Reference: ruby-position Attribute
RULES Attribute
SCROLL Attribute
SCROLLAMOUNT Attribute
SCROLLDELAY Attribute
SCROLLING Attribute
SELECTED Attribute
SHAPE Attribute
SIZE Attribute
Abakada DHTML Properties Reference: size Property
SIZE Attribute
SIZE Attribute
Abakada DHTML Properties Reference: size Property
SPAN Attribute
SRC Attribute
SRC Attribute
SRC Attribute
START Attribute
TABINDEX Attribute
TARGET Attribute
TEXT Attribute
Abakada DHTML Properties Reference: text Property
TITLE Attribute
TITLE Attribute
TOPMARGIN Attribute
TRUESPEED Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
TYPE Attribute
UNITS Attribute
URL Attribute
URN Attribute
USEMAP Attribute
VALIGN Attribute
VALIGN Attribute
Abakada DHTML Properties Reference: value Property
VALUE Attribute
VALUE Attribute
VCARD_NAME Attribute
VLINK Attribute
VOLUME Attribute
VSPACE Attribute
WIDTH Attribute
WRAP Attribute
XMLNS Attribute

CSS Properties

Animation Properties
At-Rules
Box Properties
Color and Background Properties
Display and Position Properties
Filter Functions
Font Properties
Layout Properties
Lists Properties
Printing Properties
Pseudo-Classes
Text Properties
Transform Functions
Transition Properties

DHTML Events Reference

Show Me

Sunday, June 1, 2025

System.Data Namespace

The System.Data.Common namespace consists of the classes shared by the OLE DB and the SQL Server™ .NET data providers.

A .NET data provider describes a collection of classes used to manage connections between an ASP.NET Web application and a data store, such as a relational database or a hierarchical XML file.

DataAdapter DBDataPermission DbParameterCollection
DataColumnMapping DBDataPermissionAttribute DbProviderConfigurationHandler
DataColumnMappingCollection DbDataReader DbProviderFactories
DataTableMapping DbDataReaderExtensions DbProviderFactoriesConfigurationHandler
DataTableMappingCollection DbDataRecord DbProviderFactory
DbColumn DbDataSourceEnumerator DbProviderSpecificTypePropertyAttribute
DbCommand DbEnumerator DbTransaction
DbCommandBuilder DbException RowUpdatedEventArgs
DbConnection DbMetaDataCollectionNames RowUpdatingEventArgs
DbConnectionStringBuilder DbMetaDataColumnNames SchemaTableColumn
DbDataAdapter DbParameter SchemaTableOptionalColumn

CatalogLocation IdentifierCase SupportedJoinOperators
GroupByBehavior

IDbColumnSchemaGenerator

For further information on how this namespace can help you, see Accessing Data with ADO.NET.

System.Data.OleDb System.Data.SqlClient

Check out related books at Amazon

© 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