No Nonsense XML Web Development With PHP

Symbols

&= operator, Reading from Text Files
', comments in VB.NET, Code Declaration Blocks
+= operator, Reading from Text Files
//, comments in C#, Code Declaration Blocks
== operator, Operators
@ symbol, denoting parameters, Using Parameters with Queries

A

<a> tag and the HtmlAnchor control, HtmlAnchor

a:hover and a:link pseudo-elements, Create the Corporate Style Sheet

ABS function, SQL, Arithmetic Functions

Access databases

character matching, Operators
creating relationships, One-to-Many Relationships
creating tables, Creating a Table in Access
creating the Dorknozzle database, Creating the Database in Access
data modelling, MSDE and, Installing Microsoft Access
data types, Creating a Table in Access
database diagrams, Relationship Management, One-to-Many Relationships
Datasheet View, Inserting Rows, The SELECT Query
defining primary keys, Defining Keys
Design View, Creating a Table in Access, Inserting Rows, Working with the Query Editor in Access
Expression Builder, Date and Time Functions
INSERT statements, The INSERT Statement
installing Access, Installing Microsoft Access
listing supported functions, Date and Time Functions
namespaces for ADO.NET use, An Introduction to ADO.NET
Query Editor, Working with the Query Editor in Access
security, Security in Access
SQL View feature, Working with the Query Editor in Access
suitability for ASP.NET, Installing the Required Software
UPDATE statements, The UPDATE Statement
views for editing tables, Inserting Rows

account profile page, PayPal, Integrating the Shopping Cart with your PayPal Account

<Ad> tag, AdRotator control, The AdRotator Control

add to cart functionality, Adding to the Cart

Add Watch option, Creating Watches

Add() method

Command object, Using Parameters with Queries
DataSet Tables collection, Creating DataTables Programmatically
DataTable Column collection, Creating DataColumns Programmatically
DataTable Rows collection, Creating DataRows Programmatically

address book page, Dorknozzle database, Binding DataSets to Controls

ADO.NET, ADO.NET-Summary, Summary

common database queries, Performing Common Database Queries
main classes introduced, An Introduction to ADO.NET
new classes, Understanding DataSets
transactions, Working with Transactions

AdRotator control, The AdRotator Control, AdRotator Control

<Advertisement> tag, AdRotator control, The AdRotator Control

aggregate functions, SQL, Aggregate Functions

DataTable.Compute() and, Adding DataColumn Values

aliases as virtual directories, Virtual Directories

<allow> element, Web.config file, Configuring Forms Authorization

AllowPaging property, DataGrid control, Creating a DataGrid that Pages

AllowSorting property, DataGrid control, Sorting Columns in a DataGrid

<AlternatingItemStyle> tag

DataGrid control, Modifying the Appearance of DataGrids with Styles
DataList control, Customizing DataLists Using Styles

<AlternatingItemTemplate> tag, Using the Repeater Control

anonymous users, Working with Forms Authentication, Configuring Forms Authorization

Append() method, StringBuilder class, Consuming the Google Search Service

AppendText() method, File class, Writing to Text Files

application domains, advantages, Overview of ASP.NET Applications

Application logs and error handling, Logging Errors to the Event Log

application state, Using Application State

application variables, Using Application State-Using Application State

Application_Start() method, Working With the Global.asax File

applications (see Web applications)

<apply-templates> tag, XSLT, An Introduction to XML and XSLT

appointment scheduler, Building the Interactive Appointment Scheduler-Building the Interactive Appointment Scheduler

delete functionality, Building the Interactive Appointment Scheduler
methods, Building the Interactive Appointment Scheduler

<appSettings> tag, Using the Web.config File

arithmetic functions, SQL, Arithmetic Functions

ArrayList class

deserialization example, Serialization
serialization example, Serialization

arrays, Arrays

declaring, Arrays
multidimensional, Building the Interactive Appointment Scheduler
PrimaryKey property, DataTable, Setting DataTable Properties Programmatically

ASP (Active Server Pages), What is ASP.NET?, View State

ASP.NET, Your First ASP.NET Page

(see also example ASP.NET pages)
advantages for building Web applications, What is ASP.NET?
checking for correct installation, Determining whether ASP.NET Installed Correctly
manual installation, Determining whether ASP.NET Installed Correctly
page mechanisms, ASP.NET Basics
page structure, ASP.NET Page Structure
software requirements, What Do I Need?, Installing the Required Software
support sites, The ASP.NET Support Site

<asp: (see following term)

asp: prefix

validation controls, Using Validation Controls
Web controls, Introduction to Web Controls

aspnet_wp.exe file, Attaching a Process to the Debugger

.aspx ISAPI DLL, Determining whether ASP.NET Installed Correctly

assemblies, Consuming the Calculator Web Service-Consuming the Calculator Web Service

compiled proxy classes as, Web Service and Database Interaction
compiling proxy classes into, Consuming the Calculator Web Service, Finding the Service and Creating the Assembly
introduced, Overview of ASP.NET Applications

attributes, XML tags, An Introduction to XML and XSLT

Authenticate() method, FormsAuthentication class, Web.config File Authentication, Database Authentication

authentication

methods, Securing ASP.NET Applications
MSDE security, Security in MSDE
using localhost, Using Localhost
Web Data Administrator and, Installing and Configuring Web Data Administrator

authentication tickets (see cookies)

authorization, forms authorization, Configuring Forms Authorization

auto incrementing columns, Primary Keys

Access, Creating a Table in Access
DataColumn element, Auto Incrementing and Making DataColumns Unique
DataTable object, Showing Items and Creating the Cart Structure
MSDE, Creating a Table in Web Data Administrator

AutoGenerateColumns property

DataGrid control, Customizing DataGrid Columns

AVG function, SQL, The AVG Function

B

Background property category, Style Properties

backslash character in C#, An Introduction to ADO.NET, Writing to Text Files

banner advertisements, The AdRotator Control

base classes, Understanding Inheritance

BETWEEN keyword, Selecting Ranges of Values with BETWEEN

bin directories, Overview of ASP.NET Applications

BinaryFormatter class, Serialization

Deserialize() method, Serialization
serialization example, Serialization
Serialize() method, Serialization, Building the Interactive Appointment Scheduler

BindData() method, Handling Updates with Postback, Using the DataList Control

checking query strings using, Creating a Master/Detail Form with the HyperLinkColumn

Block property category, Style Properties

<body> tags and presentational elements, ASP.NET Page Structure

BodyFormat property, MailMessage class, Creating the Company Newsletter Page

Boolean variables, Adding to the Cart

Border property category, Style Properties

BoundColumn control

DataGrid control, Customizing DataGrid Columns, Creating a Master/Detail Form with the HyperLinkColumn

Box property category, Style Properties

breakpoints, Creating Breakpoints and Stepping Through Code

bridge analogy, ADO.NET, ADO.NET, Understanding DataSets

browsers

ASP.NET display in, Your First ASP.NET Page
detecting validation support, Client-Side vs. Server-Side Validation, Configuring Client-Side Validation
display of Web Services, A Simple Calculator Web Service
view of pages being debugged, Creating Breakpoints and Stepping Through Code
view of WSDL, Using WSDL to Consume Third-Party Web Services
views of XML documents, An Introduction to XML and XSLT

built-in classes, .NET, Your First ASP.NET Page

built-in tags, Your First ASP.NET Page

Button control, Button, Button Control

admintools.aspx page, Updating Records, Deleting Records
attributes listed, Control Events and Subroutines
class for, Dorknozzle project, Create the Corporate Style Sheet
setting user control properties dynamically, Exposing Properties and Methods in User Controls
shopping cart application, The Interface, Building the Employee Store Interface

<button> tags and the HtmlButton control, HtmlButton

ButtonColumn control

DataGrid control, Adding ButtonColumns to Delete Rows within a DataGrid, Removing Items from the Cart

ButtonColumn control, DataGrid control, Creating a Master/Detail Form with the HyperLinkColumn

buttons

custom images as, HtmlInputImage
DataGrid columns acting as, Creating a Master/Detail Form with the HyperLinkColumn

C

C# language

data types, Variables and Variable Declaration
FirstPage.aspx example in, Your First ASP.NET Page
operators, Operators

Cache collection, Using Page Data Caching

caching

arrays, appointment scheduler, Building the Interactive Appointment Scheduler
Web applications, Caching ASP.NET Applications

calculations

DataColumn values, Adding DataColumn Values
shopping cart quantity recalculations, Adding to the Cart

Calculator example Web Service, A Simple Calculator Web Service

Calendar control, The Calendar Control, Calendar Control

interactive appointment scheduler, Building the Interactive Appointment Scheduler

Calendar_RenderDay() method

appointment scheduler, Building the Interactive Appointment Scheduler

Camel casing, Web controls, Introduction to Web Controls

cancel functionality, DataGrid edits, Working with the EditCommandColumn, Modifying Cart Quantities

Cascading Style Sheets (see CSS)

cascading updates and deletes, One-to-Many Relationships, Relationships in the Dorknozzle Database

case sensitivity, XML, Types of Errors

CaseSensitive property, DataTable object, Setting DataTable Properties Programmatically

casting, Variables and Variable Declaration

generic controls to TextBoxes, Working with the EditCommandColumn

catching errors (see Try...Catch blocks)

CellPadding attribute, DataGrid control, Modifying the Appearance of DataGrids with Styles

cells, as basis of DataLists, Using the DataList Control

character encoding, Server.UrlEncode() method, Navigation Objects And Their Methods

character matching, Operators

CheckBox control, CheckBox, CheckBox Control

selecting alternative style sheets, Simplifying it All with the Xml Control

checkboxes, HtmlInputCheckbox control, HtmlInputCheckBox

CheckBoxList control, CheckBoxList, CheckBoxList Control

checkout operations, shopping cart application, Processing Orders Using PayPal

CheckOut() method, Integrating the Shopping Cart with your PayPal Account

classes

creating a Web Service, A Simple Calculator Web Service
definitions in code-behind files, Separating Code From Content With Code-Behind
OO programming concept, Classes

classes, .NET

built-in classes, Your First ASP.NET Page
organization into namespaces, Understanding Namespaces

classes, ADO.NET, An Introduction to ADO.NET

DataSet elements, DataSet Elements

classes, CSS

applying style rules using, Types of Styles and Style Sheets
applying to Web forms , Design the Web Form for the Helpdesk Application

client-side validation, Configuring Client-Side Validation

ClientTarget attribute, Page directive, Configuring Client-Side Validation

ClientValidationFunction property, CustomValidator, CustomValidator

Close() method

Connection object, An Introduction to ADO.NET
FileStream object, Serialization
StreamReader class, Reading from Text Files

code

breaking lines of, Operators
compilation errors and, Types of Errors
isolation, in application domains, Overview of ASP.NET Applications
runtime errors and, Types of Errors
stepping through when debugging, Creating Breakpoints and Stepping Through Code

code declaration blocks, Code Declaration Blocks

connection strings, An Introduction to ADO.NET
example, Your First ASP.NET Page

code render blocks, Code Render Blocks

binding tables to DataLists, Building the Employee Store Interface
code-behind alternative, Separating Code From Content With Code-Behind
contructing URLs dynamically, The Database
templates and, for DataLists, Using the DataList Control

code reuse with stored procedures, Stored Procedures

code-behind files, Code Declaration Blocks, Separating Code From Content With Code-Behind-Separating Code From Content With Code-Behind

collections, Using Parameters with Queries

CollectName() method, user controls, Exposing Properties and Methods in User Controls

Color class, FromName() method, Building the Interactive Appointment Scheduler

columns

adding to database tables, Creating a Table in Access
DataGrid, sorting data, Sorting Columns in a DataGrid
selective presentation with DataGrids, Customizing DataGrid Columns

Command objects, ADO.NET, An Introduction to ADO.NET

CommandName property, Button control, Building the Employee Store Interface

CommandType class, Improving Performance with Stored Procedures

comments

in VB.NET and C# code, Code Declaration Blocks
server-side, Server-Side Comments

committing transactions, Working with Transactions

Company Events Web Service

consuming the service, Consuming the Company Events Service

CompanyEvents table, Dorknozzle database, Inserting Rows, Web Service and Database Interaction

creating, Creating the Remaining Tables
Web Service access, Web Service and Database Interaction

CompareValidator control, CompareValidator, The CompareValidator Control

compilation errors, Types of Errors

compiled technologies, What is ASP.NET?, Consuming the Calculator Web Service

Compute() method

DataTable class, Adding DataColumn Values

conditional logic, Conditional Logic

configuration errors, Types of Errors

configuration sections, Using the Web.config File

configuration settings (see Web.config file)

<configuration> tag, Using the Web.config File

connection strings, An Introduction to ADO.NET

storing in Web.config, Using the Web.config File

ContinueShopping() method, Modifying Cart Quantities

controls, The DataGrid and DataList Controls, Introduction to Rich Controls, Introduction to User Controls

(see also data controls)
(see also HTML controls)
(see also rich controls)
(see also user controls)
(see also validation controls)
(see also Web controls)
binding DataSets to, Binding DataSets to Controls
declaring, code-behind files, Separating Code From Content With Code-Behind
parser errors and, Types of Errors
selective loading, Loading User Controls Programmatically

controls collection

data controls, Working with the EditCommandColumn

controls collection, data controls, Working with the EditCommandColumn

ControlToCompare property, CompareValidator control, CompareValidator

ControlToValidate property

RequiredFieldValidator control, RequiredFieldValidator

ControlToValidate property, RequiredFieldValidator control, Using Validation Controls

ControlValidate property, RangeValidator control, RangeValidator

cookies

basis of forms authentication, Working with Forms Authentication
custom authentication tickets, Building Your Own Authentication Ticket

Cookies collection, Building Your Own Authentication Ticket

CORBA (Common Object Request Broker Architecture), Understanding Web Service Standards

Count property, DataSet Tables collection, Creating DataTables Programmatically

COUNT() function, SQL, The COUNT() Function

CREATE PROCEDURE command, Improving Performance with Stored Procedures

CreateText() method, File class, Writing to Text Files

<credentials> tag, Web.config file, Web.config File Authentication

CSS (Cascading Style Sheets)

a:hover and a:link pseudo-elements, Create the Corporate Style Sheet
Dorknozzle project styling, Create the Corporate Style Sheet
formatting Web controls, Formatting Controls with CSS

CssClass property, The CssClass Property

currency data

display format, Keeping the Order Total
validation, CompareValidator

CurrentPageIndex property, DataGrid control, Creating a DataGrid that Pages

custom authentication tickets, Building Your Own Authentication Ticket

custom error messages, Custom Error Messages

<customErrors> tag, Web.config file, Viewing Error Information

CustomValidator control, CustomValidator, The CustomValidator Control

D

data access

ADO.NET, ADO.NET

data binding, Data Binding

ListBox controls, Deleting Records
Page_Load() method, Handling Updates with Postback
queries to controls, Using the Repeater Control

data controls, ASP.NET, The DataGrid and DataList Controls

(see also DataGrid control)
(see also DataList control)
(see also Repeater control)
controls collection, Working with the EditCommandColumn
shopping cart interface, The Interface

data loss

modifying Global.asax, Working With the Global.asax File

data source binding

CheckBoxList control, DropDownList
ListBox control, ListBox
RadioButtonList control, RadioButtonList, CheckBoxList

data sources

text files as, Reading from Text Files

data types

Access, Creating a Table in Access
C# and VB.NET, tabulated, Variables and Variable Declaration
SQL Server, Creating a Table in Web Data Administrator
validation, CompareValidator
variable declarations and, Variables and Variable Declaration

DataAdapter class

properties, Updating a Database from a Modified DataSet

databases, Installing Microsoft Access, Working with DataGrids

(see also Access databases)
(see also Dorknozzle database)
(see also MSDE)
(see also SQL Server databases)
connections and the DataReader classes, An Introduction to ADO.NET
DataSets as virtual databases, Understanding DataSets
deleting records from a Web application, Deleting Records
deleting records using DataGrids, Adding ButtonColumns to Delete Rows within a DataGrid
deleting records using DataLists, Editing Items within a DataList
design, Database Design and Development
importing into MSDE, Importing a Database into MSDE
inserting records from a Web application, Inserting Records
namespaces and ADO.NET, An Introduction to ADO.NET
shopping cart application, The Database
storing login credentials, Database Authentication
suitable for use with ASP.NET, Installing the Required Software
terminology, An Introduction to Databases
updating from a Web application, Updating Records
updating from modified DataSets, Updating a Database from a Modified DataSet
updating using DataGrids, Working with the EditCommandColumn
Web Services interaction, Web Service and Database Interaction

DataColumn element, DataTables

adding calculated values, Adding DataColumn Values
assigning default values, Assigning Default Values to DataColumns
auto incrementing and uniqueness, Auto Incrementing and Making DataColumns Unique
creating programmatically, Creating DataColumns Programmatically
setting properties programmatically, Setting DataColumn Properties Programmatically
shopping cart application, Showing Items and Creating the Cart Structure

DataField property, BoundColumns control, Customizing DataGrid Columns

DataGrid control, The DataGrid and DataList Controls-Adding ButtonColumns to Delete Rows within a DataGrid, Working with DataGrids, Adding ButtonColumns to Delete Rows within a DataGrid

advantages over Repeater control, The DataGrid and DataList Controls
binding a DataSet to, Creating DataColumns Programmatically
binding event logs to, Logging Errors to the Event Log
binding to DataSets, Working With the Global.asax File
column controls, Creating a Master/Detail Form with the HyperLinkColumn
Company Events Web Service, Consuming the Company Events Service
customizing presentation, Working with DataGrids
directory listing example, Accessing Directories and Directory Information
modifying quantities in, Modifying Cart Quantities
page output caching, Using Page Output Caching
paging functionality, Creating a DataGrid that Pages
restricting editability, Using Templates
shared access to DataSets, Binding DataSets to Controls
shopping cart application, The Intranet Shopping Cart, The Interface, Building the Employee Store Interface
sorting columns in, Sorting Columns in a DataGrid
styling DataGrids, Modifying the Appearance of DataGrids with Styles
using templates, Using Templates

DataItem() method, Repeater class, Using the Repeater Control

DataKeyField property

DataGrid , Working with the EditCommandColumn, Modifying Cart Quantities
DataList, Editing Items within a DataList

DataList control, Using the DataList Control

advantages over Repeater control, The DataGrid and DataList Controls
binding database items to, Showing Items and Creating the Cart Structure
customizing using styles, Customizing DataLists Using Styles
editing items within a DataList, Editing Items within a DataList
navigation menus using, Creating a Navigation Menu using DataLists
shopping cart application, The Intranet Shopping Cart, The Interface, Building the Employee Store Interface

DataMember property

DataGrid control, Binding DataSets to Controls

DataMember property, DataGrid, Binding DataSets to Controls

DataReader classes

database connection and, An Introduction to ADO.NET

DataReader control

binding to a DataGrid, Working with DataGrids
DataSets as alternatives, DataSets, Understanding DataSets

DataRelation class, Defining DataRelations Between DataTables

DataRow element, DataTables

adding items to a shopping cart, Adding to the Cart
creating programmatically, Creating DataRows Programmatically

DataSet object, ADO.NET, DataSets-Creating a DataGrid that Pages, Creating a DataGrid that Pages

binding from within code, Binding DataSets to Controls
binding to a DataGrid, Creating DataColumns Programmatically
binding using application variables, Using Application State
DataTable information display, Creating DataTables Programmatically
elements, DataSet Elements
as memory-resident virtual databases, Understanding DataSets
performance enhancement with application state, Working With the Global.asax File
selectCompanyEvents.asmx, Web Service and Database Interaction
selecting DataTables, Binding DataSets to Controls
shared access, Binding DataSets to Controls
updating databases from, Updating a Database from a Modified DataSet

Datasheet View, Access, Inserting Rows, The SELECT Query

DataTable object, Understanding DataTables-Defining DataRelations Between DataTables, Defining DataRelations Between DataTables

binding to a DataGrid, Adding to the Cart
creating programmatically, Creating DataTables Programmatically
DataRelations between, Defining DataRelations Between DataTables
looping through, Modifying Cart Quantities
modifying, to update the database, Updating a Database from a Modified DataSet
not derived from the database, Understanding DataTables
populating, using DataRows, Creating DataRows Programmatically
setting properties programmatically, Setting DataTable Properties Programmatically

DataTextField property, DataGrid control, Creating a Master/Detail Form with the HyperLinkColumn

DataView object, Understanding DataViews

filtering, Filtering DataViews
filtering navigation, Loading User Controls Programmatically
page data caching, Using Page Data Caching
sorting column data, Using Page Data Caching

date and time functions, Your First ASP.NET Page, Date and Time Functions

date information

date format validation, CompareValidator
multidimensional string arrays, Building the Interactive Appointment Scheduler

DATE() and DATEADD() functions, Date and Time Functions

DATEPART() function, The GROUP BY Clause

DateTime class, Your First ASP.NET Page

DayNameFormat property, Calendar control, The Calendar Control

DayRender event, Calendar control, Building the Interactive Appointment Scheduler

DBMS (Database Management Systems), The Database Management System

DCOM (Distributed Component Object Model), Understanding Web Service Standards

debug mode, Web.config file setting, Viewing Error Information

Debugger, Using the .NET Debugger-Creating Watches, Creating Watches

attaching a process, Attaching a Process to the Debugger
breakpoint creation, Creating Breakpoints and Stepping Through Code

Decimal.Round() method, Keeping the Order Total

default page configuration, Virtual Directories

Default.aspx page

custom authentication tickets, Building Your Own Authentication Ticket
Forms Authentication, Working with Forms Authentication

DefaultValue property, DataColumn element, Assigning Default Values to DataColumns

DefaultView property, DataTable class, Understanding DataViews

delete anomalies, Designing Tables for the Intranet Application

delete operations

modified DataSets, Updating a Database from a Modified DataSet
using DataGrids, Adding ButtonColumns to Delete Rows within a DataGrid
using DataLists, Editing Items within a DataList

DELETE statement, SQL, The DELETE Statement

deleting records from a Web application, Deleting Records

Delete() method

DataRow class, Removing Items from the Cart
DataTable class, Updating a Database from a Modified DataSet

<deny> element, Web.config file, Configuring Forms Authorization

Departments table, Dorknozzle database, Inserting Rows

Access query using, Working with the Query Editor in Access
creating, Creating the Remaining Tables
INNER JOIN involving, INNER JOIN
primary key illustration, Foreign Keys
relationship with Employees table, Designing Tables for the Intranet Application, Relationship Management, One-to-Many Relationships
table structure, Designing Tables for the Intranet Application
updating from a DataSet, Updating a Database from a Modified DataSet

DeptLookup table, Dorknozzle database, Many-to-Many Relationships

Deserialize() method, BinaryFormatter class, Serialization

Design View, Access, Creating a Table in Access, Inserting Rows

generating a query, Working with the Query Editor in Access

Dim keyword, Variables and Variable Declaration

directives, Directives, Working With Directives-Working With Directives

(see also server-side include directives)
Import directive, Understanding Namespaces
OutputCache directive, Using Page Output Caching
Register directive, Globalizing Content with User Controls, Exposing Properties and Methods in User Controls
WebService directive, A Simple Calculator Web Service

directories

accessing, Accessing Directories and Directory Information
working with directory paths, Working with Directory and File Paths

directory browsing, Virtual Directories

Directory class

GetFiles() and other methods, Accessing Directories and Directory Information

Directory Listing Denied message, Virtual Directories

disconnected data model, DataSets, Understanding DataSets

Display property

validation controls, RangeValidator, ValidationSummary

DisplayName() method

user controls, Exposing Properties and Methods in User Controls

DISTINCT keyword, SQL, Selecting Unique Data with DISTINCT

distributed computing

Web Services and, Introduction to XML Web Services

<div> tag

Panel control and, Panel

Do loops, Loops

Do While loops, Loops

document wide styles, Types of Styles and Style Sheets

DocumentSource property, XML control, Simplifying it All with the Xml Control

dog analogy, OOP, Objects

doGoogleSearch() method, Consuming the Google Search Service

Google Search Service example, Consuming the Google Search Service

doQuery() function

Google Search Service example, Consuming the Google Search Service

Dorknozzle database, Creating a Table in Access

(see also individual tables)
creating tables, Creating a Table in Access, Creating a Table in Web Data Administrator
creating using Access, Creating the Database in Access
creating using Web Data Administrator, Creating the Database in Web Data Administrator
DataRelations example, Defining DataRelations Between DataTables
defining primary keys, Defining Keys
formatted data from, using DataGrids, Working with DataGrids
relationships, Relationships in the Dorknozzle Database
sorting column data, Sorting Columns in a DataGrid
update functionality using DataLists, Editing Items within a DataList

Dorknozzle Intranet Application

admin tools page, Updating Records, Loading User Controls Programmatically
Company Events page, Web Service and Database Interaction
company newsletter page, Sending Email in ASP.NET, Creating the Company Newsletter Page
defining as a Web application, Database Authentication
designing the Helpdesk application form, Design the Web Form for the Helpdesk Application
employee directory, Using the Repeater Control
forms upload functionality, Uploading Files
functionality, Introducing the Dorknozzle Intranet Application
introduced, A Navigation Menu and Web Form for the Intranet Application
navigation menu, Building the Navigation Menu
shopping cart application, The Intranet Shopping Cart
user controls, Globalizing Content with User Controls
using CompareValidator, CompareValidator
using RangeValidator, RangeValidator
using RequiredFieldValidator, RequiredFieldValidator
using ValidationSummary, ValidationSummary

dot operator, Properties

downlevel setting, ClientTarget attribute, Configuring Client-Side Validation

drop-down menus

binding data sources, Data Binding
HtmlSelect control, HtmlSelect
IsPostBack use, Postback

DropDownList control, DropDownList, DropDownList Control

admintools.aspx page, Updating Records
binding DataViews to, Filtering DataViews
class for, Dorknozzle project, Create the Corporate Style Sheet
directory listing example, Accessing Directories and Directory Information

duplicate data

avoiding, with relationships, Relationship Management
DISTINCT keyword and, Selecting Unique Data with DISTINCT

dynamic display

validation controls, RangeValidator

E

eBay, Creating a PayPal Account

ecommerce sites

master/detail pages, Creating a Master/Detail Form with the HyperLinkColumn

EditButtonColumn control, Editing Items within a DataList

EditCommand event, DataList control, Editing Items within a DataList

EditCommandColumn control, DataGrid, Creating a Master/Detail Form with the HyperLinkColumn, Event Bubbling, Building the Employee Store Interface , Modifying Cart Quantities

EditItemIndex property

DataGrid control, Working with the EditCommandColumn, Modifying Cart Quantities

<EditItemTemplate> tag, Using Templates, Editing Items within a DataList, Building the Employee Store Interface

email

configuring IIS for, Configuring IIS to Send Email
creating the interface, Creating the Company Newsletter Page
rendering HTML in, Creating the Company Newsletter Page
sending from ASP.NET, Sending Email in ASP.NET

email address validation

using CustomValidator, CustomValidator
using regular expressions, RegularExpressionValidator, Some Useful Regular Expressions

email programs

appointment schedulers, Building the Interactive Appointment Scheduler
serialization and deserialization, Serialization

Employees table, Dorknozzle database, Inserting Rows

Access query using, Working with the Query Editor in Access
column and data types, Columns and Data Types
creating, Creating a Table in Web Data Administrator
INNER JOIN involving, INNER JOIN
login credentials within, Database Authentication
primary and foreign key illustration, Foreign Keys
relationship with Departments table, Designing Tables for the Intranet Application, Relationship Management, One-to-Many Relationships
table structure, An Introduction to Databases

EmployeeStore table, Dorknozzle database, Inserting Rows

basic SQL query against, Basic SQL, The SELECT Query
changing data, The UPDATE Statement
creating, Creating the Remaining Tables
inserting data, The INSERT Statement
removing records, The DELETE Statement
shopping cart application, The Intranet Shopping Cart, The Database

empty methods in development and testing, Showing Items and Creating the Cart Structure

EnableClientScript property, Configuring Client-Side Validation

EnableViewState property, Page directive, View State

enctype property, <form> tag, Uploading Files

entities, deriving database tables from, Designing Tables for the Intranet Application

environment variables

Path, Consuming the Calculator Web Service

equality operator, C#, Operators

error handling, Error Handling, Handling Errors

.NET Debugger, Using the .NET Debugger
exceptions, Catching and Handling Exceptions
intuitive error information, Viewing Error Information
logging errors, Logging Errors to the Event Log
reading from error logs, Logging Errors to the Event Log
types of error, Types of Errors
viewing error information, Viewing Error Information

error messages

custom error messages, Custom Error Messages
display position, RequiredFieldValidator
‘friendly’ error pages, Viewing Error Information
message box display, ValidationSummary

ErrorMessage property

RangeValidator control, RangeValidator
RequiredFieldValidator control, RequiredFieldValidator
validation controls, Using Validation Controls

event bubbling, Event Bubbling, Editing Items within a DataList

event handlers, Creating DataTables Programmatically

(see also Page_Load() method)
Application_Start() method, Working With the Global.asax File
data controls, Event Bubbling
DataGrid control, Working with the EditCommandColumn
DataGrid paging, Creating a DataGrid that Pages
Global.asax file, Working With the Global.asax File
HTML controls, HtmlButton
Web controls, Button

EventArgs parameter, Control Events and Subroutines

not used for DataGrid controls, Working with the EditCommandColumn

EventLog class, .NET, Logging Errors to the Event Log

events

introduced, Programming Basics
OO programming concept, Events
page events, Page Events

example ASP.NET pages

AccessingDirectoryInfo/index.aspx, Accessing Directories and Directory Information-Accessing Directories and Directory Information
AccessingPathInfo/index.aspx, Working with Directory and File Paths-Working with Directory and File Paths
AddingDataColumnValues.aspx, Adding DataColumn Values
addressbook.aspx, Working with DataGrids
addressbookDS.aspx, Binding DataSets to Controls-Binding DataSets to Controls
admintools.aspx, Updating Records-Handling Updates with Postback, Handling Updates with Postback, Uploading Files, Exposing Properties and Methods in User Controls
AdRotator.aspx, The AdRotator Control
AdRotatorControl/AdRotator.aspx, The AdRotator Control
AdvancedXMLControl/sample.aspx, Simplifying it All with the Xml Control
AdvancedXMLControl/titlesTransformAll.aspx, Simplifying it All with the Xml Control
ApplicationState/ApplicationState.aspx, Using Application State-Using Application State
AppointmentScheduler/sample.aspx, Building the Interactive Appointment Scheduler-Building the Interactive Appointment Scheduler
Arrays.aspx, Arrays
BoundColumns.aspx, Customizing DataGrid Columns
calculate.aspx, Consuming the Calculator Web Service
Calculate/calculate.aspx, Consuming the Calculator Web Service
CalendarControl/CalendarControl.aspx, The Calendar Control
CatchingExceptions.aspx, Catching and Handling Exceptions
ClickEvent.aspx, Control Events and Subroutines
CompareValidator1.aspx, CompareValidator
CompareValidator2.aspx, CompareValidator
CompareValidator3.aspx, CompareValidator
CreatingDataColumnsProgrammatically.aspx, Creating DataColumns Programmatically
CreatingDataRowsProgrammatically.aspx, Creating DataRows Programmatically-Creating DataRows Programmatically
CreatingDataTablesProgrammatically.aspx, Creating DataTables Programmatically-Creating DataTables Programmatically
CustomAuthenticationTicket/Default.aspx, Building Your Own Authentication Ticket
CustomAuthenticationTicket/login.aspx, Building Your Own Authentication Ticket-Building Your Own Authentication Ticket
CustomValidator.aspx, CustomValidator
DataColumnPropertiesProgrammatically.aspx, Assigning Default Values to DataColumns
DataGridDelete.aspx, Adding ButtonColumns to Delete Rows within a DataGrid
DataGridPaging.aspx, Creating a DataGrid that Pages
DataGridTemplates.aspx, Using Templates
DataGridWithStyles.aspx, Modifying the Appearance of DataGrids with Styles-Modifying the Appearance of DataGrids with Styles
DataListWithStyles.aspx, Customizing DataLists Using Styles
DataRelations.aspx, Defining DataRelations Between DataTables-Defining DataRelations Between DataTables
DataTablePropertiesProgrammatically.aspx, Setting DataTable Properties Programmatically-Setting DataTable Properties Programmatically
DataViewsFiltering.aspx, Filtering DataViews-Filtering DataViews
DataViewsSorting.aspx, Sorting Columns in a DataGrid-Sorting Columns in a DataGrid
deserialize.aspx, Serialization
EditDataList.aspx, Editing Items within a DataList-Editing Items within a DataList
EditUpdateCancel.aspx, Working with the EditCommandColumn-Working with the EditCommandColumn
employeedirectory.aspx, Using the Repeater Control-Data Binding, Data Binding
employeestore.aspx, The Intranet Shopping Cart, The Database, Building the Employee Store Interface -Integrating the Shopping Cart with your PayPal Account, Integrating the Shopping Cart with your PayPal Account
FirstPage.aspx, Your First ASP.NET Page
Functions.aspx, Functions
GoogleSearch/search.aspx, Consuming the Google Search Service-Consuming the Google Search Service
HandlingErrorsEventLog.aspx, Logging Errors to the Event Log-Logging Errors to the Event Log
helpdesk.aspx, Design the Web Form for the Helpdesk Application, RequiredFieldValidator-RequiredFieldValidator, CompareValidator-CompareValidator, RangeValidator-ValidationSummary, ValidationSummary, Data Binding-Inserting Records, Inserting Records, Improving Performance with Stored Procedures-Improving Performance with Stored Procedures, Attaching a Process to the Debugger
hrupload.aspx, Uploading Files
index.aspx (Dorknozzle project), Consuming the Company Events Service
index.aspx, (Dorknozzle project), Building the Navigation Menu
index.aspx, logout functionality, Logging Users Out
index.aspx, web service example, Consuming the Company Events Service
listing directories, Accessing Directories and Directory Information
login.aspx, Working with Forms Authentication, Web.config File Authentication, Database Authentication
MasterDetail.aspx, Creating a Master/Detail Form with the HyperLinkColumn-Creating a Master/Detail Form with the HyperLinkColumn
nav.aspx, Creating a Navigation Menu using DataLists-Creating a Navigation Menu using DataLists, Globalizing Content with User Controls
newsletterarchive.aspx, Creating the Company Newsletter Page
PageDataCaching/CachedGrid.aspx, Using Page Data Caching-Using Page Data Caching
PageEvents.aspx, Page Events
PageOutputCaching/CachedGrid.aspx, Using Page Output Caching
PageOutputCaching/CachedTime.aspx, Using Page Output Caching
PostBack.aspx, Postback
queriesUsingParameters.aspx, Using Parameters with Queries
RangeValidator.aspx, RangeValidator
RegularExpressionValidator.aspx, RegularExpressionValidator
repeaterControl.aspx, Using the Repeater Control
RequiredFieldValidator.aspx, Client-Side vs. Server-Side Validation, RequiredFieldValidator
respondingToUserInteraction.aspx, Responding to User Interaction
sample.aspx, without code, Separating Code From Content With Code-Behind
search.aspx, Consuming the Google Search Service
Serialization/deserialize.aspx, Serialization-Serialization
Serialization/serialize.aspx, Serialization-Serialization
serialize.aspx, Serialization
SessionState/Global.aspx, Working with User Sessions
SessionState/SessionState.aspx, Working with User Sessions
SimpleDataGrid.aspx, Working with DataGrids-Working with DataGrids
SimpleDataList.aspx, Using the DataList Control
simpleDataReader.aspx, An Introduction to ADO.NET
SimpleForm.aspx, Processing a Simple Form
SimpleLogin/Default.aspx, Working with Forms Authentication
SimpleLogin/login.aspx, Working with Forms Authentication
SimpleXMLControl/sample.aspx, Simplifying it All with the Xml Control
SpecificExceptions.aspx, Catching and Handling Exceptions
template.aspx, location, Using the Repeater Control
TextFileReadWrite/index.aspx, Writing to Text Files-Reading from Text Files, Reading from Text Files
TryCatch.aspx, Handling Errors-Catching Errors with Try…Catch, Catching Errors with Try…Catch
UpdatingDatabaseUsingDataSet.aspx, Updating a Database from a Modified DataSet-Updating a Database from a Modified DataSet
UserControlsLoadingProgrammatically/sample.aspx, Loading User Controls Programmatically-Loading User Controls Programmatically
UserControlsMethods/CollectName.aspx, Exposing Properties and Methods in User Controls
UserControlsProperties/sample.aspx, Exposing Properties and Methods in User Controls-Exposing Properties and Methods in User Controls
UsingGlobalASAX/Global.aspx, Working With the Global.asax File
UsingGlobalASAX/index.aspx, Working With the Global.asax File
ValidationSummary.aspx, ValidationSummary
ViewState.aspx, View State
WebConfigAuthentication/login.aspx, Web.config File Authentication

example project (see Dorknozzle Intranet Application)

example user controls

nav.ascx, Globalizing Content with User Controls
UserControlsLoadingProgrammatically/nav.ascx, Loading User Controls Programmatically
UserControlsLoadingProgrammatically/navadmin.ascx, Loading User Controls Programmatically
UserControlsLoadingProgrammatically/sample.ascx, Loading User Controls Programmatically
UserControlsMethods/DisplayName.ascx, Exposing Properties and Methods in User Controls
UserControlsProperties/datetime.ascx, Exposing Properties and Methods in User Controls
UserControlsProperties/sample.ascx, Exposing Properties and Methods in User Controls

example Web Services

calculate.asmx, A Simple Calculator Web Service
Calculate/calculate.asmx, A Simple Calculator Web Service-A Simple Calculator Web Service
selectCompanyEvents.asmx, Web Service and Database Interaction

example XSLT style sheets

titlesTransform.xsl, An Introduction to XML and XSLT, Simplifying it All with the Xml Control
titlesTransformAll.xsl, Simplifying it All with the Xml Control

Exception class, .NET, Catching and Handling Exceptions

more specific exceptions, Catching and Handling Exceptions

ExecuteNonQuery() method, Inserting Records

ExecuteReader() method, Command object, An Introduction to ADO.NET, Inserting Records

Expression Builder, Access, Date and Time Functions

expressions, SQL, Expressions

external stye sheets, Types of Styles and Style Sheets

F

File class

AppendText() method, Writing to Text Files
CreateText() method, Writing to Text Files
MapPath() method, Writing to Text Files
OpenText() method, Reading from Text Files

file extensions

IIS processing of Web requests and, Determining whether ASP.NET Installed Correctly
Notepad, preserving, Your First ASP.NET Page
user controls, Globalizing Content with User Controls
Web Services, A Simple Calculator Web Service

file paths, Working with Directory and File Paths

file permissions, setting for Access databases, Inserting Records

file streams, Writing to Text Files

files, Uploading Files

(see also text files)
uploading from Web applications, Uploading Files
Web applications, location, Where Do I Put My Files?

FileStream class, serialization example, Serialization

Fill() method, DataAdapter class, Creating DataTables Programmatically

filtering results

DataTable.Compute() method and, Adding DataColumn Values
DataViews and, Filtering DataViews
parameterized ADO.NET queries, Using Parameters with Queries

FindControl() method, DataGrid control, Modifying Cart Quantities

FirstDayOfWeek property, Calendar control, The Calendar Control

Font property category, Style Properties

fonts

changing using DataGrids, Modifying the Appearance of DataGrids with Styles

<FooterTemplate> tag, Using the Repeater Control

For Each loops, Loops

iterating through an ArrayList, Serialization
iterating through DataTables, Modifying Cart Quantities
iterating through error messages, Catching and Handling Exceptions
writing table contents to Label controls, Defining DataRelations Between DataTables

For loops, Loops

foreign keys, Foreign Keys

<form> tag

enctype property, Uploading Files
HtmlForm control and, HtmlForm

form validation (see validation controls)

formatting data using DataGrids, Working with DataGrids

forms (see Web forms)

forms authentication, Working with Forms Authentication

compared with other modes, Securing ASP.NET Applications
configuring, Configuring Forms Authentication
cookies as basis of, Working with Forms Authentication

forms authorization, Configuring Forms Authorization

<forms> element, Web.config file, Configuring Forms Authentication

FormsAuthentication class

Authenticate() method, Web.config File Authentication, Database Authentication
custom authentication tickets, Building Your Own Authentication Ticket
RedirectFromLoginPage() method, Working with Forms Authentication, Database Authentication
SignOut() method, Logging Users Out

FormsIdentity class, Building Your Own Authentication Ticket

‘friendly’ error pages, Viewing Error Information

FROM clause

required in SELECT queries, The SELECT Query

FromName() method, Color class, Building the Interactive Appointment Scheduler

functions

declaring in VB.NET and C#, Functions
distinguished from subroutines, Functions

functions, SQL, Functions

aggregate functions, Aggregate Functions
arithmetic functions, Arithmetic Functions
string functions, String Functions
supported in Access, Date and Time Functions

G

GAC (Global Assembly Cache), Overview of ASP.NET Applications

GetChildRows() method, DataRow class, Defining DataRelations Between DataTables

getData() method, Responding to User Interaction

getDate() method, Using Parameters with Queries

GetFileName() method, Path class, Working with Directory and File Paths

GetFiles() method, Directory class, Accessing Directories and Directory Information

GetItemTotal() function, Modifying Cart Quantities, Removing Items from the Cart

global variables, Using the DataList Control

Global.asax file, Overview of ASP.NET Applications, Working With the Global.asax File

globalizing content with user controls, Globalizing Content with User Controls

Google Search Service

consuming the service, Consuming the Google Search Service
example Web Service, Introduction to XML Web Services
interface, Consuming the Google Search Service
registering, Registering to Use the Google Search Service
Web application based on, Finding the Service and Creating the Assembly

graphics, Dorknozzle project navigation, Building the Navigation Menu

GridLines attribute, DataGrid control, Modifying the Appearance of DataGrids with Styles

GROUP BY clause, SQL, The GROUP BY Clause

H

HAVING clause, SQL, The HAVING Clause

<head> tag, code declaration block location, Code Declaration Blocks

code declaration block location, Control Events and Subroutines

<HeaderTemplate> tag, Using the Repeater Control

HeaderText property, BoundColumns control, Customizing DataGrid Columns

headings, styling in DataGrids, Modifying the Appearance of DataGrids with Styles

helpdesk request page, Dorknozzle

design, Design the Web Form for the Helpdesk Application
using CompareValidator, CompareValidator
using RangeValidator, RangeValidator
using RequiredFieldValidator, RequiredFieldValidator
using ValidationSummary, ValidationSummary

HelpDesk table, Dorknozzle database, Creating the Remaining Tables

HelpDeskCategories table, Dorknozzle database, Creating the Remaining Tables, Inserting Rows

HelpDeskStatus table, Dorknozzle database, Creating the Remaining Tables, Inserting Rows

HelpDeskSubjects table, Dorknozzle database, Creating the Remaining Tables, Inserting Rows

hidden form fields

view state and, View State

hidden form fields and view state, View State

hiding controls (see Visible property)

hit counter, Using Application State

HTML

comments, server-side comments and, Server-Side Comments
contrasted with XML, An Introduction to XML and XSLT
formatting XML as, An Introduction to XML and XSLT, Simplifying it All with the Xml Control
generating tables with the Repeater control, Using the Repeater Control
invalid, derived from Response.Write(), Performing Common Database Queries
markup in ASP.NET pages, Literal Text and HTML Tags
rendering in emails, Creating the Company Newsletter Page

HTML controls, Working with HTML Controls

full list, HTML Control Reference-HtmlTextArea Control, HtmlTextArea Control
survey form example, Processing a Simple Form

HTML forms

Web forms and, Introduction to Web Forms

HtmlAnchor control, HtmlAnchor, HtmlAnchor Control

HtmlButton control, HtmlButton, Processing a Simple Form, HtmlButton Control

HtmlForm control, HtmlForm, HtmlForm Control

HtmlGeneric control, HtmlGenericControl, HtmlGeneric Control

HtmlImage control, HtmlImage, HtmlImage Control

HtmlInputButton control, HtmlInputButton, HtmlInputButton Control

HtmlInputCheckBox control, HtmlInputCheckBox, HtmlInputCheckBox Control

HtmlInputFile control, HtmlInputFile, Uploading Files, HtmlInputFile Control

uploading files, Uploading Files

HtmlInputHidden control, HtmlInputHidden, HtmlInputHidden Control

HtmlInputImage control, HtmlInputImage, HtmlInputImage Control

HtmlInputRadioButton control, HtmlInputRadioButton, HtmlInputRadioButton Control

HtmlInputText control, HtmlInputText, Processing a Simple Form, HtmlInputText Control

HtmlSelect control, HtmlSelect, Processing a Simple Form, HtmlSelect Control

HtmlTable control, HtmlTable, HtmlTableRow and HtmlTableCell, HtmlTable Control

HtmlTableCell control, HtmlTable, HtmlTableRow and HtmlTableCell, HtmlTableCell Control

HtmlTableRow control, HtmlTable, HtmlTableRow and HtmlTableCell, HtmlTableRow Control

HtmlTextArea control, HtmlTextArea, HtmlTextArea Control

HTTP status codes and ‘friendly’ error messages, Viewing Error Information

HttpCookie class, Building Your Own Authentication Ticket

HttpPostedFile class, Uploading Files

HyperLink control, HyperLink, Using The HyperLink Control, HyperLink Control

DataList navigation menu, Creating a Navigation Menu using DataLists
Dorknozzle project navigation, Building the Navigation Menu

HyperLinkColumn control, DataGrid, Creating a Master/Detail Form with the HyperLinkColumn-Creating a Master/Detail Form with the HyperLinkColumn

hyperlinks

DataGrid columns acting as, Creating a Master/Detail Form with the HyperLinkColumn
LinkButton and HyperLink controls, LinkButton
page navigation and, Handling Page Navigation
within DataGrids, Creating a Master/Detail Form with the HyperLinkColumn

I

identity columns, MSDE, Creating a Table in Web Data Administrator

If... Else statements, Conditional Logic

IIS (Internet Information Services), Working with Forms Authentication

(see also Web applications)
ASP.NET requirement, What Do I Need?
checking ASP.NET integration, Determining whether ASP.NET Installed Correctly
configuring, Configuring IIS
configuring to send email, Configuring IIS to Send Email
creating a Web application, Overview of ASP.NET Applications
enabling directory browsing, Virtual Directories
installation, Installing Internet Information Services (IIS)
stopping and starting, Stopping and Starting IIS

Image control, Image, Image Control

ImageButton control, ImageButton, ImageButton Control

images

adding to navigation menus, Creating a Navigation Menu using DataLists
changing dynamically, HtmlImage

<img> tags and the HtmlImage control, HtmlImage

Import directive, Working With Directives, Understanding Namespaces

IN operator, SQL, The IN Operator

incrementing counters, Loops

inheritance

code-behind files, Separating Code From Content With Code-Behind
OO programming concept, Understanding Inheritance

inline code/expression render blocks, Code Render Blocks

inline styles, Types of Styles and Style Sheets

INNER JOINs, INNER JOIN

<input> tag

HtmlInput* controls and, HtmlInputButton
TextBox control and, Introduction to Web Controls

insert operations

data loss and transactions, Working with Transactions
modified DataSets, Updating a Database from a Modified DataSet

INSERT statement, SQL, The INSERT Statement

inserting records from a Web application, Inserting Records
stored procedure for, Improving Performance with Stored Procedures

instance methods, Writing to Text Files

Instant Payment Notification (IPN), Integrating the Shopping Cart with your PayPal Account

instantiation of classes, Classes

interface, shopping cart application, The Interface

Internet

interoperability and, XML Web Services
scalability and Web Services, Understanding Web Service Standards

Internet Explorer versions and installation, Installing Internet Explorer

Internet Services Manager, Overview of ASP.NET Applications

interoperability, XML Web Services

Intranet Project (see Dorknozzle Intranet Application)

Invoke button, Web Service browser tool, A Simple Calculator Web Service

ISAPI extension DLLs, Determining whether ASP.NET Installed Correctly

IsPostBack property, Postback

shopping cart application, Showing Items and Creating the Cart Structure

Item() method, DataReader class, An Introduction to ADO.NET

<ItemStyle> tag

DataGrid control, Modifying the Appearance of DataGrids with Styles

ItemTemplate class, Using the Repeater Control

<ItemTemplate> tag, Using the Repeater Control

Repeater control subtag, Using the Repeater Control
use with DataLists, Using the DataList Control

J

JavaScript and client-side validation, Client-Side vs. Server-Side Validation
joins, Joins-OUTER JOIN, OUTER JOIN

K

Kazaa, Stopping and Starting IIS
keys (see foreign keys) (see primary keys)

L

Label control, Label, Label Control

as a built-in tag, Your First ASP.NET Page
Calandar control example, The Calendar Control
custom error messages and, Custom Error Messages
displaying authentication information, Building Your Own Authentication Ticket
reading from text files, Reading from Text Files
retrieving path information, Working with Directory and File Paths
running total display, Adding DataColumn Values, Keeping the Order Total
writing table contents to, Defining DataRelations Between DataTables

language attribute, <script> tag and Page directive, Code Declaration Blocks

languages (see programming languages)

LIKE keyword, Matching Patterns with LIKE

line continuation symbols, Operators

<link> element

Dorknozzle project styling, Create the Corporate Style Sheet
external style sheet use, Types of Styles and Style Sheets

LinkButton control, LinkButton, LinkButton Control

DataLists, Editing Items within a DataList
Google Search Service example, Consuming the Google Search Service
logging users out, Logging Users Out
shopping cart application, The Interface, Building the Employee Store Interface , Modifying Cart Quantities, Integrating the Shopping Cart with your PayPal Account
shopping cart checkout, Integrating the Shopping Cart with your PayPal Account
Visible property, Consuming the Google Search Service

Linux, What is ASP.NET?

list boxes and the HtmlSelect control, HtmlSelect

List property category, Style Properties

ListBox control, ListBox, ListBox Control

deleting records from a Web application, Deleting Records

Literal control, Literal Control

literal text in ASP.NET pages, Literal Text and HTML Tags

LoadControl() method, Loading User Controls Programmatically

localhost, Using Localhost

IIS for email, Configuring IIS to Send Email

login credentials

database storage, Database Authentication
storage in Web.config, Web.config File Authentication

login pages

example, Working with Forms Authentication
HtmlInputText control use, HtmlInputText
logging users out, Logging Users Out

LoginUser() method, example login page, Working with Forms Authentication, Database Authentication, Custom Error Messages

look-up tables, Many-to-Many Relationships

loopback IP address, Using Localhost

loops, Loops-Loops

(see also Do loops)
(see also For Each loops)
exiting, Loops

M

Machine.config file, Using the Web.config File

MailMessage class

introduced, Sending Email in ASP.NET
newsletterarchive.aspx, Creating the Company Newsletter Page
properties, Sending Email in ASP.NET

many-to-many relationships, Many-to-Many Relationships

MapPath() method, Writing to Text Files, Serialization

master/detail forms, Creating a Master/Detail Form with the HyperLinkColumn

MAX function, SQL, The MIN and MAX Functions

MaximumValue property, RangeValidator control, RangeValidator

memory requirement, DataSets, Understanding DataSets

message boxes, error messages, ValidationSummary

methods

OO programming concept, Objects, Methods
shared/static methods, Writing to Text Files
user controls, Exposing Properties and Methods in User Controls
Web Methods, Understanding Web Service Standards

Microsoft Corporation, Installing the Required Software

(see also .NET)
(see also Access databases)
(see also ASP)
(see also Internet Explorer)
(see also MSDE)
(see also SQL Server databases)
disconnected data model, DataSets, Understanding DataSets
Web application definition, Overview of ASP.NET Applications

MIN function, SQL, The MIN and MAX Functions

MinimumCapacity property, DataTable object, Setting DataTable Properties Programmatically

MinimumValue property, RangeValidator control, RangeValidator

MSDE, Installing the Required Software, Installing Microsoft Access

(see also Web Data Administrator)
character matching, Operators
importing databases, Importing a Database into MSDE
installing, Installing SQL Server Desktop Engine (MSDE)
namespaces for ADO.NET use, An Introduction to ADO.NET
security, Security in MSDE
suitability for ASP.NET, Installing the Required Software

music catalog

illustrating the Xml control, Simplifying it All with the Xml Control
illustrating XSLT, An Introduction to XML and XSLT

N

namespaces, Understanding Namespaces

(see also System.*)
importing into ASP.NET, An Introduction to ADO.NET
required for ADO.NET use, An Introduction to ADO.NET

navigation menus

Dorknozzle Intranet Application, Building the Navigation Menu
inappropriate for login pages, Database Authentication
selective display using user controls, Loading User Controls Programmatically
selective loading, Loading User Controls Programmatically
styling, Creating a Navigation Menu using DataLists
user control example, Introduction to User Controls, Globalizing Content with User Controls
using DataLists, Creating a Navigation Menu using DataLists

navigation objects, Navigation Objects And Their Methods

.NET Framework, Using the .NET Debugger

(see also Debugger)
.NET assemblies, Consuming the Calculator Web Service
class library, Your First ASP.NET Page
classes for serialization and deserialization, Serialization
Exception class, Catching and Handling Exceptions
rich controls, Introduction to Rich Controls
user controls, Introduction to User Controls

.NET Framework Redistributable

ASP.NET requirement, Installing the Required Software
installing, Download and Install the Redistributable

.NET platform, significance, Introduction to .NET and ASP.NET

NewRow() method, DataTable class, Creating DataRows Programmatically, Updating a Database from a Modified DataSet, Adding to the Cart

newsletter page, Dorknozzle project, Creating the Company Newsletter Page

Newsletters table, Dorknozzle database, Creating the Remaining Tables

NextPrevFormat property, Calendar control, The Calendar Control

normalization, Designing Tables for the Intranet Application

Notepad, preserving file extensions, Your First ASP.NET Page

number conversion to strings, Functions

O

Object parameter, Control Events and Subroutines

objects as an OO programming concept, Objects

OLE DB Provider for Access, An Introduction to ADO.NET

OleDbCommandBuilder class, Updating a Database from a Modified DataSet

OleDbConnection class

Open() method, Methods

OleDbException class, Catching and Handling Exceptions

OnClick event handler

Button control, Control Events and Subroutines
Button control attribute, Database Authentication
logging errors, Logging Errors to the Event Log
Web controls and, Button

OnDataBinding attribute, Button control, Control Events and Subroutines

one-to-many relationships, One-to-Many Relationships

one-to-one relationships, One-to-One Relationships

OnServerClick event handler, HtmlButton, Uploading Files

OnSortCommand property, DataGrid control, Sorting Columns in a DataGrid

OOP (Object Oriented Programming), Object Oriented Programming Concepts

Open() method

Connection object, An Introduction to ADO.NET
OleDbConnection class, Methods

OpenText() method, File class, Reading from Text Files

operating systems, ASP.NET restrictions, What is ASP.NET?

Operator property, CompareValidator control, CompareValidator

operators

&= operator, Reading from Text Files
+= operator, Reading from Text Files
C# and VB.NET, tabulated, Operators
dot operator, Properties
SQL IN operator, The IN Operator
SQL queries using, Row Filtering with WHERE
SQL, tabulated, Operators

ORDER BY clause, SQL, The ORDER BY Clause

order processing, shopping carts, Processing Orders Using PayPal

OUTER JOINs, OUTER JOIN

OutputCache directive, Using Page Output Caching

P

Page class and code-behind files, Separating Code From Content With Code-Behind

page data caching, Using Page Data Caching-Using Page Data Caching

example, Using Page Data Caching

Page directive

disabling client-side validation, Configuring Client-Side Validation
EnableViewState property, View State
function of, Working With Directives
language attribute, Code Declaration Blocks
pages referring to code-behind files, Separating Code From Content With Code-Behind

page events, Page Events

page hit counter, Using Application State

page navigation, Handling Page Navigation

page output caching, Using Page Output Caching

page structure, ASP.NET, ASP.NET Page Structure-Literal Text and HTML Tags, Literal Text and HTML Tags

Page_Init() method, Page Events

Page_Load() method, Page Events

appointment scheduler example, Building the Interactive Appointment Scheduler
DataTables, Creating DataTables Programmatically
handling updates, Handling Updates with Postback
IsPostBack use, Postback

Page_PreRender() method, Page Events

Page_Unload() method, Page Events

PageSize property, DataGrid control, Creating a DataGrid that Pages

paging

DataGrids, Working with DataGrids, Creating a DataGrid that Pages
Google Search Service example, Consuming the Google Search Service

Panel control, Panel, Panel Control

Google Search Service example, Consuming the Google Search Service
shopping cart application, The Interface, Building the Employee Store Interface

parameters

ADO.NET queries, Using Parameters with Queries
functions, Functions
subroutines, Control Events and Subroutines

parser errors, Types of Errors

Passport authentication, Securing ASP.NET Applications, Introduction to XML Web Services

passwords

confirming entry of, CompareValidator
database storage, Database Authentication
HtmlInputText control use, HtmlInputText
protecting an Access database, Security in Access
storing within Web.config, Web.config File Authentication
TextMode property and entering, Working with Forms Authentication

Path class, System.IO, Working with Directory and File Paths

GetFileName() and other methods, Working with Directory and File Paths

Path environment variable, Consuming the Calculator Web Service

pattern matching with LIKE, Matching Patterns with LIKE

(see also regular expressions)

payment systems, Processing Orders Using PayPal

PayPal

account profile page, Integrating the Shopping Cart with your PayPal Account
Instant Payment Notification feature, Integrating the Shopping Cart with your PayPal Account
shopping cart integration with, Processing Orders Using PayPal
variables and values accepted, Integrating the Shopping Cart with your PayPal Account
Web Service potential, Introduction to XML Web Services

performance enhancement

caching Web applications, Caching ASP.NET Applications
DataSets, with application state, Working With the Global.asax File
using stored procedures, Improving Performance with Stored Procedures

permissions (see file permissions)

persisting information

application state and, Using Application State
between pages, methods for, Navigation Objects And Their Methods
using query strings, Creating a Master/Detail Form with the HyperLinkColumn
view state and, View State

phone number validation using RegExps, Some Useful Regular Expressions

PlaceHolder control, PlaceHolder, Loading User Controls Programmatically, PlaceHolder Control

Positioning property category, Style Properties

postback, Postback

updates using, Handling Updates with Postback

postback checking, Postback

shopping cart application, Showing Items and Creating the Cart Structure

PostedFile property, HttpPostedFile class, Uploading Files

primary keys, Primary Keys

creating programmatically, Setting DataTable Properties Programmatically
defining, Defining Keys
look-up tables, Many-to-Many Relationships

PrimaryKey property, DataTable object, Setting DataTable Properties Programmatically

processes, attaching to the Debugger, Attaching a Process to the Debugger

programming languages

alternatives for ASP.NET, ASP.NET Languages
specifying in Page directives, Directives
supported within .NET, What is .NET?, What is ASP.NET?
VB.NET and C# basics, VB.NET and C# Programming Basics

properties

OO programming concept, Properties

properties, in OO programming, Objects

proxy classes

compiling into assemblies, Consuming the Calculator Web Service, Finding the Service and Creating the Assembly, Web Service and Database Interaction
consuming Web Services, Consuming the Calculator Web Service
generating, Consuming the Calculator Web Service, Finding the Service and Creating the Assembly, Web Service and Database Interaction

public methods, user controls, Exposing Properties and Methods in User Controls

PWS (Personal Web Server), What Do I Need?

Q

queries

copying, using SQL View, Working with the Query Editor in Access
filtering search results, Row Filtering with WHERE
introduced, Queries
ranges of values, Selecting Ranges of Values with BETWEEN
SQL clauses for refining, Other Clauses
subqueries, Subqueries
using ADO.NET, Performing Common Database Queries
using parameters with ADO.NET, Using Parameters with Queries
using SQL, Structured Query Language

Query Editor, Access, Working with the Query Editor in Access

Query Editor, Web Data Administrator, Working with the Query Editor in Web Data Administrator

query strings

DataGrid-based master/detail pages, Creating a Master/Detail Form with the HyperLinkColumn
passing information with Response.Redirect(), Navigation Objects And Their Methods

question mark symbol, Working with Forms Authentication, Configuring Forms Authorization

QuickWatch window, Creating Watches

R

radio buttons, creating, HtmlInputRadioButton

RadioButton control, RadioButton, RadioButton Control

RadioButtonList control, RadioButtonList, RadioButtonList Control

RangeValidator control, RangeValidator, The RangeValidator Control

Read() method, DataReader class, An Introduction to ADO.NET

ReadLine() method, StreamReader class, Reading from Text Files

ReadOnly property

BoundColumn control, Using Templates
DataTable object, Building the Employee Store Interface

RedirectFromLoginPage() method, FormsAuthentication class, Working with Forms Authentication, Database Authentication

redirection with HyperLink controls, Using The HyperLink Control

referential integrity, One-to-Many Relationships

refreshLog() method, error logging example, Logging Errors to the Event Log

Register directive

function of, Working With Directives
user controls, Globalizing Content with User Controls, Exposing Properties and Methods in User Controls

registry editing, Installing and Configuring Web Data Administrator

regular expressions, Some Useful Regular Expressions

RegularExpressionValidator control, RegularExpressionValidator, The RegularExpressionValidator Control

relational database model, An Introduction to Databases

relationship diagrams, Relationships in the Dorknozzle Database

Relationship Editor, Access, One-to-Many Relationships

relationships between tables

Dorknozzle database, Designing Tables for the Intranet Application, Relationships in the Dorknozzle Database
managing, Relationship Management
relationship diagrams, Relationship Management, One-to-Many Relationships
types of relationship, Relationship Management

Remove() method

Application object, Using Application State

Repeater control, Using Parameters with Queries, Using the Repeater Control

DataList compared to, Using the DataList Control
employeedirectory.aspx, Using the Repeater Control
limitations, The DataGrid and DataList Controls

Request.Form() method, View State

required form fields (see validation controls)

RequiredFieldValidator control, Using Validation Controls, RequiredFieldValidator, Using Templates, The RequiredFieldValidator Control

Response.Redirect() method, Navigation Objects And Their Methods, Integrating the Shopping Cart with your PayPal Account

Response.Write() method

invalid HTML from, Performing Common Database Queries
legitimate use, An Introduction to ADO.NET
Repeater control alternative, Using Parameters with Queries

result sets, accessing, Using the Repeater Control

return type, functions, Functions

rich controls, Introduction to Rich Controls

the AdRotator control, The AdRotator Control
the Calendar control, The Calendar Control
the Xml control, Simplifying it All with the Xml Control

rolling back transactions, Working with Transactions

RowFilter property, DataView class, Filtering DataViews

Rows() collection, DataTable class, Updating a Database from a Modified DataSet

RPC (Remote Procedure Call), Understanding Web Service Standards

runat="server" attribute

HTML controls distinguished by, Working with HTML Controls
introduced, Your First ASP.NET Page
script tag, Code Declaration Blocks
server controls and, ASP.NET Server Controls

running totals

displaying, Adding DataColumn Values, Keeping the Order Total

runtime errors, Types of Errors

debug mode and, Viewing Error Information

S

sample ASP.NET pages (see example ASP.NET pages)

Save_Click() method

appointment scheduler example, Building the Interactive Appointment Scheduler

Save_Click() method, appointment scheduler, Building the Interactive Appointment Scheduler

SaveAs() method, HttpPostedFile class, Uploading Files

scalability and Web Services, Understanding Web Service Standards

scope

methods and properties, Scope
subroutines, Control Events and Subroutines

<script> tag

attributes, Code Declaration Blocks
code elements located between, ASP.NET Page Structure, Code Declaration Blocks
FirstPage.aspx use, Your First ASP.NET Page

SDK (Software Development Kit), Using the .NET Debugger

(see also Debugger)
installing for .NET, Download and Install the SDK
wsdl.exe utility, Consuming the Calculator Web Service

security

Access and MSDE, Security
directory browsing and, Virtual Directories
logging users out, Logging Users Out
securing Web applications, Securing ASP.NET Applications
server-side validation and, Configuring Client-Side Validation

SecurityException, registering event log source, Logging Errors to the Event Log

Select Case statements

directory listing example, Accessing Directories and Directory Information

SELECT statements

embedded SELECTs, The Embedded SELECT Statement
significance in SQL, The SELECT Query
specifying fields, Selecting Certain Fields
WHERE clause, Row Filtering with WHERE

<select> tag

DropDownList and ListBox controls, DropDownList
HtmlSelect control, HtmlSelect

SelectCommand property

DataAdapter class, Binding DataSets to Controls

SelectedDate property, Calendar control, The Calendar Control, Building the Interactive Appointment Scheduler

SelectionChanged event handler, Calendar control, The Calendar Control

SelectionChanged event, Calendar control, Building the Interactive Appointment Scheduler

SelectionMode property, Calendar control, The Calendar Control

SelectMonthText property, Calendar control, The Calendar Control

SelectWeekText property, Calendar control, The Calendar Control

Send() method, SmtpMail class, Creating the Company Newsletter Page

separating presentation and logic

facilitated by ASP.NET, What is ASP.NET?
server controls and, ASP.NET Server Controls
using code-behind files, Separating Code From Content With Code-Behind

<SeparatorTemplate> tag, Using the Repeater Control

use with DataLists, Using the DataList Control

serialization, Serialization

Serialize() method, BinaryFormatter object, Serialization, Building the Interactive Appointment Scheduler

server controls, ASP.NET Server Controls

server-side include directives, Server-Side Include Directives

navigation menus and, Creating a Navigation Menu using DataLists
user controls and, Exposing Properties and Methods in User Controls

Server.Execute() method, Navigation Objects And Their Methods

Server.Transfer() method, Navigation Objects And Their Methods

Server.UrlEncode() method, Navigation Objects And Their Methods

servers

ASP.NET as a server-side technology, What is ASP.NET?
names, MSDE connection, Installing and Configuring Web Data Administrator, An Introduction to ADO.NET

Service Manager Dialog, MSDE, Installing SQL Server Desktop Engine (MSDE)

session state and application state, Using Application State

session variables, Working with User Sessions, Consuming the Google Search Service

shared methods, VB.NET, Writing to Text Files, Accessing Directories and Directory Information

shopping cart application, Building an ASP.NET Shopping Cart

add to cart functionality, Adding to the Cart
checkout operation, Processing Orders Using PayPal
database, The Database
interface controls, The Interface
interface HTML, Building the Employee Store Interface
keeping the order total, Keeping the Order Total
methods, The Methods
modifying cart quantities, Modifying Cart Quantities
removing items from the cart, Removing Items from the Cart

shopping carts

calculated DataColumn values, Adding DataColumn Values
DataTable usefulness, Understanding DataTables
DefaultValue property and, Assigning Default Values to DataColumns

ShowDayHeader property, Calendar control, The Calendar Control

ShowGridLines property, Calendar control, The Calendar Control

ShowMessageBox property, ValidationSummary control, ValidationSummary

ShowNextPrevMonth property, Calendar control, The Calendar Control

ShowTitle property, Calendar control, The Calendar Control

SignOut() method, FormsAuthentication class, Logging Users Out

SMTP (Simple Mail Transfer Protocol), Configuring IIS to Send Email

SmtpMail class, Sending Email in ASP.NET

SmtpServer property, SmtpMail class, Creating the Company Newsletter Page

SOAP (Simple Object Access Protocol), Understanding Web Service Standards

Social Security Number validation, Some Useful Regular Expressions

sorting data

DataGrid capability, Working with DataGrids
DataGrid columns, Sorting Columns in a DataGrid
ORDER BY clauses, The ORDER BY Clause
page data caching example, Using Page Data Caching

spacing, validation control effects, RangeValidator

<span> tag, Your First ASP.NET Page

special characters in regular expressions, Some Useful Regular Expressions

spoofing, Logging Users Out

SQL (Structured Query Language), Structured Query Language

DELETE statements, The DELETE Statement
expressions, Expressions
functions, Functions
INSERT statements, The INSERT Statement
operators, Operators
overheads of executing, Improving Performance with Stored Procedures
SELECT statements, The SELECT Query
subqueries, Subqueries
UPDATE statements, The UPDATE Statement

SQL Server databases

data types, Creating a Table in Web Data Administrator
MSDE and, Installing SQL Server Desktop Engine (MSDE)

SQL Server Desktop Engine (see MSDE)

SQL View feature, Access, Working with the Query Editor in Access

src attribute, <script> tag, Code Declaration Blocks

standardization and Web Services, Understanding Web Service Standards

state, application and session, Using Application State

static methods, C#, Writing to Text Files, Accessing Directories and Directory Information

status codes, HTTP, and ‘friendly’ error messages, Viewing Error Information

stepping through code, Creating Breakpoints and Stepping Through Code

stored procedures, Stored Procedures, Improving Performance with Stored Procedures-Improving Performance with Stored Procedures

StreamReader class

Close() method, Reading from Text Files
ReadLine() method, Reading from Text Files

StreamWriter class, System.IO, Writing to Text Files

WriteLine() method, Writing to Text Files

String class, reading from text files, Reading from Text Files

string concatenation

C# and VB.NET operators, Operators
SQL & operator, Expressions

string conversions, Functions

string functions, SQL, String Functions

StringBuilder class, Consuming the Google Search Service

Append() method, Consuming the Google Search Service
Google Search Service example, Consuming the Google Search Service

strings, manipulating with regular expressions, RegularExpressionValidator

Structured Query Language (see SQL)

style attributes, Types of Styles and Style Sheets

style properties, customizable, Style Properties

style sheets

loading, using the Xml control, Simplifying it All with the Xml Control
presenting XML using XSLT, An Introduction to XML and XSLT
selecting alternatives, Simplifying it All with the Xml Control

<style> tag, Types of Styles and Style Sheets

styling DataGrids, Modifying the Appearance of DataGrids with Styles

styling DataLists, Customizing DataLists Using Styles

navigation menus, Creating a Navigation Menu using DataLists

styling Web pages, Types of Styles and Style Sheets

Dorknozzle project, Create the Corporate Style Sheet

subclasses, Understanding Inheritance

submitting a form, Button

subqueries, SQL, Subqueries

subroutines

distinguished from functions, Functions
structure, Control Events and Subroutines

SUM function, SQL, The SUM Function

Switch and Switch Case statements, Conditional Logic

switch statements, directory listing example, Accessing Directories and Directory Information

System.Data namespace

CommandType class, Improving Performance with Stored Procedures

System.Data.OleDb namespace, Understanding Namespaces, Database Authentication

ADO.NET use with Access, An Introduction to ADO.NET
classes tabulated, An Introduction to ADO.NET
code example using, Understanding Namespaces

System.Data.SqlClient namespace

ADO.NET use with MSDE, An Introduction to ADO.NET
classes tabulated, An Introduction to ADO.NET

System.Diagnostics namespace, Logging Errors to the Event Log

System.Drawing namespace, Building the Interactive Appointment Scheduler

System.IO namespace

classes for accessing directories, Accessing Directories and Directory Information
groups of classes, Writing to Text Files
Path class, Working with Directory and File Paths
working with files and directories, Working with Files and Email

System.Runtime.Serialization.Formatters.Binary namespace, Serialization, Building the Interactive Appointment Scheduler

System.Text namespace, Consuming the Google Search Service

System.Web.Mail namespace, Sending Email in ASP.NET

System.Web.Security namespace

authentication classes, Working with Forms Authentication
FormsIdentity class, Building Your Own Authentication Ticket

System.Web.Services namespace, A Simple Calculator Web Service

System.Web.UI.HtmlControls namespace, Working with HTML Controls

System.Web.UI.WebControls namespace, Properties

T

table joins, Joins-OUTER JOIN, OUTER JOIN

<table> tag and Html controls, HtmlTable, HtmlTableRow and HtmlTableCell

tables, database

creating using Access, Creating a Table in Access
creating using Web Data Administrator, Creating a Table in Web Data Administrator
designing, for the Dorknozzle database, Designing Tables for the Intranet Application
structure of, An Introduction to Databases

tables, HTML

Dorknozzle navigation layout, Building the Navigation Menu
generating with the Repeater control, Using the Repeater Control
tabular structure of DataGrids, Working with DataGrids

tables, virtual (see table joins)

tag redefinition, Types of Styles and Style Sheets

tags, child tags and subtags, Using the Repeater Control

<template> tag, XSLT, An Introduction to XML and XSLT

template.aspx page, location, Using the Repeater Control

TemplateColumn control

DataGrid control, Using Templates

TemplateColumn control, DataGrid, Creating a Master/Detail Form with the HyperLinkColumn

templates

Repeater control use, Using the Repeater Control
required for DataList controls, Using the DataList Control
using with DataGrids, Using Templates

text boxes, passing query parameters, Using Parameters with Queries

text display

changing dynamically, HtmlGenericControl
Label control and, Label

text files

ASCII standard format, Working with Files and Email
reading from, Reading from Text Files
writing to, Writing to Text Files

<textarea> tags, HtmlTextArea

TextBox control, Introduction to Web Controls, TextBox, TextBox Control

admintools.aspx page, Updating Records
appointment schedular, Building the Interactive Appointment Scheduler
binding data to, Updating Records
casting generic controls to, Working with the EditCommandColumn
class for, Dorknozzle project, Create the Corporate Style Sheet
DataGrid edit functionality, Working with the EditCommandColumn
editing within DataLists, Editing Items within a DataList
email interface example, Creating the Company Newsletter Page
password TextMode, Working with Forms Authentication
user text input, Writing to Text Files

TextMode property, TextBox control, Working with Forms Authentication

Timeout property, Session object, Working with User Sessions

TitleFormat property, Calendar control, The Calendar Control

titlesTransform.xsl stylesheet, An Introduction to XML and XSLT, Simplifying it All with the Xml Control

titlesTransformAll.xsl stylesheet, Simplifying it All with the Xml Control

TodaysDate property, Calendar control, The Calendar Control

ToString() method, Functions

transactions, Working with Transactions

TransformSource property, XML control, Simplifying it All with the Xml Control

Try...Catch blocks

error handling using, Catching Errors with Try…Catch
exception handling, Catching and Handling Exceptions
Try-Catch-Finally statements and transactions, Working with Transactions

type conversion, Variables and Variable Declaration

Type property, RangeValidator control, RangeValidator

U

UDDI (Universal Description, Discovery, and Integration)

basis in XML, Understanding Web Service Standards
directories, Finding the Service and Creating the Assembly
role, Understanding Web Service Standards

underscore line continuation symbol, Operators

unique data and the DISTINCT keyword, Selecting Unique Data with DISTINCT

unique identifiers, Setting DataTable Properties Programmatically

(see also primary keys)
DataLists, Editing Items within a DataList
setting within DataGrids, Working with the EditCommandColumn

Unique property, DataColumn element, Auto Incrementing and Making DataColumns Unique

update anomalies, Designing Tables for the Intranet Application

update operations

data loss and transactions, Working with Transactions
global, with user controls, Globalizing Content with User Controls
modified DataSets, Updating a Database from a Modified DataSet
shopping cart DataGrid, Modifying Cart Quantities
using DataGrid controls, Working with the EditCommandColumn

UPDATE statement, SQL, The UPDATE Statement

inserting records from a Web application, Updating Records

Update() method, DataAdapter class, Updating a Database from a Modified DataSet

uplevel setting, ClientTarget attribute, Configuring Client-Side Validation

uploading files, Uploading Files

URLs (Uniform Resource Locators)

generating dynamically, The Database, Integrating the Shopping Cart with your PayPal Account
validation using RegExps, Some Useful Regular Expressions

usability and postback, Deleting Records

user controls, Introduction to User Controls

datetime.ascx, Exposing Properties and Methods in User Controls
dynamic possibilities of, Exposing Properties and Methods in User Controls
loading programmatically, Loading User Controls Programmatically
nav.ascx, Globalizing Content with User Controls
properties and methods, Exposing Properties and Methods in User Controls
server-side includes and, Server-Side Include Directives, Exposing Properties and Methods in User Controls
UserControlsLoadingProgrammatically/nav.ascx, Loading User Controls Programmatically
UserControlsLoadingProgrammatically/navadmin.ascx, Loading User Controls Programmatically
UserControlsLoadingProgrammatically/sample.ascx, Loading User Controls Programmatically
UserControlsMethods/DisplayName.ascx, Exposing Properties and Methods in User Controls
UserControlsProperties/datetime.ascx, Exposing Properties and Methods in User Controls
UserControlsProperties/sample.ascx, Exposing Properties and Methods in User Controls

user interaction, responding to, Responding to User Interaction

user names

database storage, Database Authentication
storing within Web.config, Web.config File Authentication

user sessions, Working with User Sessions

V

validation

always performed server-side, Configuring Client-Side Validation
client-side and server-side, Client-Side vs. Server-Side Validation
disabling client-side, Configuring Client-Side Validation

validation controls, Validation Controls, Using Validation Controls

adding to DataGrids with templates, Using Templates
effect on page layout, RangeValidator
full list, Validation Control Reference-The CustomValidator Control, The CustomValidator Control

validation of logins (see authentication)

ValidationExpression property, RegularExpressionValidator, RegularExpressionValidator

ValidationSummary control, ValidationSummary, The ValidationSummary Control

<value-of> tag, XSLT, An Introduction to XML and XSLT

variable declarations, Variables and Variable Declaration

arrays, Arrays

variables, Variables and Variable Declaration

accepted by PayPal, Integrating the Shopping Cart with your PayPal Account
application variables, Using Application State
Boolean, Adding to the Cart
incrementing counters, Loops
initialization, Variables and Variable Declaration
session variables, Working with User Sessions, Consuming the Google Search Service
usefulness of global variables, Using the DataList Control
viewing values in Debugger, Creating Watches

VB.NET

compared to Visual Basic, VB.NET
data types, Variables and Variable Declaration
FirstPage.aspx example in, Your First ASP.NET Page
operators, Operators

VBScript, VB.NET as successor to, ASP.NET Languages

video library XML illustration, An Introduction to XML and XSLT

View Source feature, IE, Your First ASP.NET Page

view state, View State

ViewDriveInfo() method, directory listing example, Accessing Directories and Directory Information

views, editing tables (see Access databases)

virtual directories, Virtual Directories

configuring with the IIS console, Virtual Directories
introduced, Where Do I Put My Files?

Virtual Directory Creation Wizard, Virtual Directories

virtual server-side includes, Server-Side Include Directives

virtual shopping carts (see shopping cart applications)

Visible property, LinkButton control, Consuming the Google Search Service

Visible property, Panel control, Modifying Cart Quantities

shopping cart application, Showing Items and Creating the Cart Structure, Adding to the Cart

VisibleDate property, Calendar control, The Calendar Control

Visual Basic

VB.NET compared to, VB.NET

Visual Basic.NET (see VB.NET)

W

watches, creating when debugging, Creating Watches

Web applications

authentication and, Working with Forms Authentication
caching, Caching ASP.NET Applications
consuming a Web Service, Consuming the Calculator Web Service
defined, Overview of ASP.NET Applications
defining the Dorknozzle project as, Database Authentication
file locations, Where Do I Put My Files?
linking to databases, An Introduction to ADO.NET
security, Security and User Authentication
stored procedures and performance, Improving Performance with Stored Procedures

Web controls, Introduction to Web Controls

applying CSS classes, The CssClass Property, Design the Web Form for the Helpdesk Application
basic Web controls, Basic Web Controls
data binding, Data Binding
data display in response to, Performing Common Database Queries
formatting with CSS, Formatting Controls with CSS
full list, Web Control Reference-Xml Control, Xml Control
refreshing after database updates, Handling Updates with Postback

Web Data Administrator

Access data modelling and, Installing Microsoft Access
creating stored procedures, Improving Performance with Stored Procedures
creating tables, Creating a Table in Web Data Administrator
creating the Dorknozzle database, Creating the Database in Web Data Administrator
defining primary keys, Defining Keys
example database listing, Creating the Database for the Intranet Application
INSERT statements, The INSERT Statement
installing, Installing and Configuring Web Data Administrator
Query Editor, Working with the Query Editor in Web Data Administrator
UPDATE statements, The UPDATE Statement
usefulness, Installing the Required Software

Web forms, Introduction to Web Forms

ASP.NET meaning, Introduction to Web Forms
Helpdesk request form, Dorknozzle, Design the Web Form for the Helpdesk Application
master/detail forms, Creating a Master/Detail Form with the HyperLinkColumn
survey form example, Processing a Simple Form

Web Methods, Understanding Web Service Standards

Web Service browser tool, A Simple Calculator Web Service, Using WSDL to Consume Third-Party Web Services

Web Services, Web Service and Database Interaction

(see also example Web Services)
applications consuming, Consuming the Calculator Web Service
browser display, A Simple Calculator Web Service
calculator example, A Simple Calculator Web Service
consuming the Company Events service, Consuming the Company Events Service
consuming third-party, Using WSDL to Consume Third-Party Web Services
database access, Web Service and Database Interaction
directories, Finding the Service and Creating the Assembly
interoperability and, XML Web Services
locating a suitable service, Finding the Service and Creating the Assembly
standards, Understanding Web Service Standards

Web.config file, Using the Web.config File

authentication information stored in, Web.config File Authentication
configuration errors and, Types of Errors
configuring Forms authentication, Configuring Forms Authentication
configuring Forms authorization, Configuring Forms Authorization
error information settings, Viewing Error Information
example, Using the Web.config File
introduced, Overview of ASP.NET Applications
setting authentication modes, Working with Forms Authentication

WebControl class, Web Control Reference, Validation Control Reference

<WebMethod ()> / [WebMethod] tag, A Simple Calculator Web Service

WebUIValidation.js file, aspnet_client folder, Configuring Client-Side Validation

WHERE clauses

embedded SELECTs, The Embedded SELECT Statement
HAVING compared to, The HAVING Clause
operators for, Operators
RowFilter property resembles, Filtering DataViews
SELECT statements, Row Filtering with WHERE
UPDATE statements, Updating Records

While loops, Loops

data display, An Introduction to ADO.NET
reading from text files, Reading from Text Files

wildcard characters, Operators

SQL queries, Matching Patterns with LIKE

Windows authentication, Securing ASP.NET Applications

Windows Explorer and ASP.NET pages, Using Localhost

worker process, ASP.NET, Attaching a Process to the Debugger

write permissions, enabling, Writing to Text Files

WriteEntry() method, error logging example, Logging Errors to the Event Log

WriteLine() method, StreamWriter class, Writing to Text Files

WriteText() method, Writing to Text Files

WSDL (Web Service Definition Language)

basis in XML, Understanding Web Service Standards
browser tool view, Using WSDL to Consume Third-Party Web Services
consuming third-party Web Services, Using WSDL to Consume Third-Party Web Services
role, Understanding Web Service Standards

wsdl.exe utility, Consuming the Calculator Web Service, Finding the Service and Creating the Assembly, Web Service and Database Interaction

X

XML, XML Web Services

(see also Web Services)
AdRotator advertisement files as, The AdRotator Control
appearance in a browser, An Introduction to XML and XSLT
further information on, An Introduction to XML and XSLT
Web Services results format, A Simple Calculator Web Service
Web Services standards and, Understanding Web Service Standards
XSLT and, introduced, An Introduction to XML and XSLT

Xml control, Simplifying it All with the Xml Control, Xml Control

XML markup and configuration errors, Types of Errors

<xsl: (see following term)

XSLT (Extensible Stylesheet Language for Transformations), An Introduction to XML and XSLT

titlesTransform.xsl, An Introduction to XML and XSLT
titlesTransformAll.xsl, Simplifying it All with the Xml Control

Z

zero-based arrays, Arrays
ZIP code validation, Some Useful Regular Expressions

Edition:	1st
Price:	$39.95
Pages:	354
ISBN:	0-9752402-0-X
Pub:	April 2006

Product Overview

No Nonsense XML Web Development With PHP

Index

Symbols

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Z

About SitePoint

Product Information

Features

Features

Customer Reviews

Manon Ghiurco, USA

Product Details

[+] Enlarge Image

Special Bonus

Bonus $9.95 PHP Poster!

FREE with every purchase of ‘No Nonsense XML Web Development With PHP’ made through sitepoint.com (Hard copy only)

Take a closer look »

* Note: Hard copy purchases only

Questions?

Claim Your PDF

Code Archive

SitePoint Books

Editorial Reviews