|
|
 |
|
|
|
Building Web Solutions with ASP.NET and ADO.NET
|
|
|
Author
|
|
Dino Esposito (Wintellect)
|
|
|
Pages
|
416
|
|
Disk
|
1 Companion CD(s)
|
|
Level
|
Int/Adv
|
|
Published
|
02/06/2002
|
|
ISBN
|
9780735615786
|
|
Price
|
$49.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
Send feedback about this index to mspindex@microsoft.com
Symbols and Numbers
<> (angle brackets), 5
- (dash), 300
# (number symbol), 5
% (percent sign), 5
+ (plus sign operator), 94
' (single quote), 5
_ (underscore character), 300
A
absolute file system path, 93-94
AcceptChanges method, 227-28, 234, 239, 250
Access, 126
ACLs (access control lists), 307
ActiveX Data Objects. See ADO
adapters, 68, 72-73, 239, 341-42
Add method, 33, 70
add-row feature, 126-35, 127, 129-30, 133
AddRows.aspx, 132
AddSelectColumn function, 189-90
AddWithKey option, 134, 264
ADO (ActiveX Data Objects), 211, 214
code reusability and, 168
exposing data and, 334, 339
in-memory changes and, 250
interoperable Web applications and, 256, 257-62
server cursors, 261
SQL commands and, 240
AdoAdapterFromCOM.aspx, 268
ADODB assembly, 258-59
adodb.dll, 257-58
adOpenDynamic cursors, 261
adOpenKeyset cursors, 261
aggregates, 201-9
align attribute, 179
AllowCustomPaging property, 45, 54
AllowDBNull property, 223
AllowMultiSelect property, 187-88
AllowMultiSelectFooter property, 187-88, 190
AllowPaging property, 44, 45, 47, 54
AllowSorting property, 59-60
AlternatingItem template, 14
AlternatingItemStyle property, 30, 178
<AlternatingItemStyle> tag, 76
AND operator, 186
angle brackets (<), 5
Application object, 44, 213, 214, 308
ApplyView command, 91, 92
ArrayList object, 193
arrays, 11, 100-103, 193
Arrays.aspx, 103
ASCII (American Standard Code for Information Interchange), 216
ASCX
file extension, 88, 152
user control, 89
.ASMX file extension, 288, 289, 293-94
aspnet_isapi.dll, 293-94
@ Assembly directive, 258, 302
asynchronous calls, 310-12
AsynchState property, 312
attributes
align, 179
border, 179
cellpadding, 83-84
Class, 288
ClassName, 152, 161
CommandName, 176
filter, 40
frameborder, 39
href, 85
IDENTITY_INSERT, 225
ImageUrl, 99
Inherits, 142
Mode, 46
Name, 289, 302-3
OnCancelCommand, 107
OnEditCommand, 107
OnUpdateCommand, 107
runat, 142, 150
SerializableAttribute, 278
ShowFooter, 90
Size, 155
SortExpression, 87-88
src, 89, 142
TagPrefix, 187
title, 155
Visible, 51, 53
WebMethod, 290-92, 308
WebService, 288-89
Attributes collection (DirectoryInfo class), 42, 92
Attributes property, 327
authentication, 306-8
authorization, 306-8
AutoGenerateColumns property, 31, 32
auto-generated commands, 242-46
AutoIncrement property, 223, 225
AutoReverse.aspx, 63-64
auto-reverse sorting, 61-66
B
BackColor property, 48, 153, 197
backgrounds, 20, 48, 153, 196-97
base keyword, 144
batch updates, 133-35, 214, 219-28, 246. See also updates
BeginGetEmployees method, 310-11
BeginTransaction method, 338
binary format, 277-78, 280
BinaryFormatter class, 278, 280
Binder property, 280
binding. See data binding
BizTalk, 255
<body> tag, 152
Boolean
AND operator, 186
arguments, 208
columns, 198-201
flags, 164
properties, 10, 31, 274
values, displaying, 97-99
Booleans.aspx, 99
border attribute, 179
borders, 48, 179
data binding and, 20
frame, 39-40
size of, 155
BorderSize property, 155
BorderStyle property, 48
BoundColumn class, 33-34, 79, 82. See also BoundCol.umn column type
BoundColumn column type, 31, 109, 117, 120. See also BoundColumn class
browsers, 155-56, 212, 298
BufferResponse property, 291
buffers, offline, 229-33
Building XML Web Services for the Microsoft .NET Platform (Short), 287
button columns, 31, 34-37, 176-79
ButtonColumn class, 34-37, 176-77, 179
buttons. See also button columns
command, 20-23
link, 155, 192
text for, 46
ButtonType property, 34
BWSLib database, 222
ByCondition.aspx, 200
ByCondition.cs, 200
C
C++ (high-level language), 262, 318
C# (high-level language), 95, 282, 341
code reusability and, 142, 144, 167
type operator, 51
Web services and, 300, 314-15
Cache object, 44, 68, 70-71, 213-16, 229, 308. See also caching
CacheDuration property, 291-92
caching, 213-16, 229. See also Cache object
batch updates and, 219
code reusability and, 168
double-level, 214-15
Calendar control, 124, 125, 153, 156-57
CallGetEmployeeGET.vbs, 299
CallGetEmployeePOST.vbs, 299
cancel command, 22
Cancel link button, 108
Cancel method, 341
CancelCommand event, 22, 111
CancelText property, 108, 110
cascading style sheets. See CSS
case-sensitivity, 237
cellpadding attribute, 83-84
CellPadding property, 83-84
cells
padding, 83-84, 84
spacing, 84
CellSpacing property, 84
changes
detecting, 233-35
in-memory, applying, 221-24, 250
rejecting, 235
submitting, 233-42
viewing, 235-29, 236
check boxes. See also CheckBox control; CheckBoxList control
created from rows, in the Recordset object, 260
interoperable Web applications and, 260-64, 272, 274-76
rendering Boolean data with, 97-99, 98
CheckBox control, 9-10, 98, 193
CheckBoxList control, 6, 9-11, 79, 262-64, 274-76
Checked property, 98
circular references, 9
Class attribute, 288
classes
BinaryFormatter, 278, 280
BoundColumn, 33-34, 79, 82
ButtonColumn, 34-37, 176-77, 179
ContextUtil, 293
Control, 189
DataBinder, 15, 76
DataGridCommandEventArgs, 36
DataGridItem, 177, 194
DataGridPageChangedEventArgs, 37
DataGridSortCommandEventArgs, 60
DataReader, 68
DataRowCollection, 218
DataSet, 4, 72
DataTable, 4, 62
DataView, 4, 19, 62, 169
DateChangedEventArgs, 158, 160-61
DirectoryInfo, 326
DirectoryListing, 319-24, 330-33, 338, 344, 346
EditCommandColumn, 106-7
EventArgs, 158-59, 170
ExecuteResultSet, 261
FileAttributes, 327
FileInfo, 326
FileSystemDataAdapter, 348, 353
FormsIdentity, 306
HttpGetClientProtocol, 301
HttpPostClientProtocol, 301
HttpRuntime, 295
HyperLinkColumn, 37-40, 123
Label, 164
ListItemCollection, 10
MyBasePage, 146
MySoapExtension, 313
NorthwindInfoService, 300, 303
Object, 55
OleDbDataAdapter, 262-63, 267
Order, 278
Page, 88, 142
PageHandlerFactory, 295
PassportIdentity, 306
Recordset, 258
Registry, 329-40
RegularExpressionValidator, 118
SerializationBinder, 280
SoapExtension, 313
SoapFormatter, 278, 280
SqlCommand, 55
SqlDataAdapter, 57
SqlDataReader, 57, 73
SqlParameter, 340
SqlParameterCollection, 340
SqlResultSet, 261
StringBuilder, 10, 94, 273
SuperGrid, 191
TemplateColumn, 76, 78-79, 85, 117
WebClientProtocol, 301
WebMethod, 303
WebService, 288, 306
WindowsIdentity, 306
XmlDataDocument, 319
XmlReader, 319
XmlSerializer, 277, 281
XmlWriter, 319
XPathNavigator, 319
ClassName attribute, 152, 161
ClearAll method, 185
ClearSelection method, 191-93
Click event, 192
client/server model, 68
Clone method, 218, 232
Close method, 338, 340
CmdColumns.aspx, 36
code. See also code reusability
blocks, ASP-style, 150-51
lasagna/spaghetti, 139, 140-41, 167
mobile, 314
sections, defined, 139-40
code reusability. See also code; code-behind approach
Calendar control and, 156-57
DataBox control and, 153-57
DataGrid control and, 167-70
firing events and, 157-61
overview of, 139-77
SortExpression property and, 171-72
UpdateView event and, 170-71
writing custom controls and, 162-72
writing user controls and, 147-53
code-behind approach
described, 141-61
embeddable Web forms and, 147
enabling, 142
loading pagelets and, 151-52
simple example of, 143
visual inheritance and, 145-147
writing user controls and, 147-53
colors
changing, 196-97
indicating, expression formats, 20
item selection and, 177
names for, 20
ColumnMapping property, 231
columns. See also templated columns
adapting, to data, 97-103
adding extra, 198-201
autoincrementing, 223-26, 244
binding, 32-40
button, 31, 34-37, 176-79
captionless, 106-7
DataGrid control and, 27, 31-32
displaying simple information in, 78
editing, 121-26
grouping, 81-83
headers for, 81-83, 85-88
image, 121-23
link, 37-40, 123
margins for, adjusting, 83-85
multiple views for, managing, 89-93
nondisplayed, 123-26
read-only, 109
returning calculated, with SQL Server, 8
sorting, 59-68, 80-81
Columns collection, 31, 33, 40, 63, 120, 326
Columns property, 155
<columns> tag, 32, 40
ColumnSpan property, 54, 83
ColumnView.aspx, 92
COM (Component Object Model)
components, 70, 272-73
exposing data and, 318, 334-35
Interop Services (CIS) layer, 256-57, 334
interoperable Web applications and, 256-60, 266-68, 272-73
objects, linking to, 266-67
methods, invoking, 267-68
Web services and, 286, 292-93, 305
command buttons, 20-23
CommandBehavior enumeration, 340
CommandButtons.aspx, 22
CommandName attribute, 176
CommandName property, 17, 34, 36, 91, 176-77
commands. See also command buttons
building, 242-46
generating, 239-46
implementing, 340-41
names of, 17, 22-23, 34, 36, 91, 176-77
CommandSource property, 16-17, 36, 47
CommandText property, 244, 340
CommandTimeout property, 244
Component Object Model. See COM
concurrency exceptions, 246-48
conditions
evaluating, 197-98
selecting by, 195-201
.CONFIG extension, 302
configuration files, 302
conflicts, 246-51
Connection property, 244
ConnectionString property, 338-39
ConnectionTimeout property, 338
ContextUtil class, 293
contract design, 304-5
Control class, 189
@ Control directive, 151-52, 161
Controls collection, 50, 94, 96, 146
Copy method, 218
CORBA (Common Object Request Broker Language), 309
Count property, 19
CreateChildControls method, 164
CreateCommand method, 338
CreateDataSource function, 73
CreateParameter method, 341
CSS (cascading style sheets), 20, 22. See also styles
associating, with page bar buttons, 50
frame borders and, 39-40
labels and, 164
margins and, 84-85, 120
text boxes and, 155
CurrentPageIndex property, 45, 47, 48, 130, 132
cursors, 261
CustomPaging.aspx, 57
D
dash (-), 300
data. See also data binding; data pagination; data report.ing
adapters, 68, 72-73, 239, 341-42
adapting columns to, 97-103
adding layouts to, 120-26
bound .NET controls, 3-28
conflicts, 246-51
exposing, to .NET applications, 317-54
fields, concatenating, 79-80
offline buffers for, 229-33
persistence, 68, 72-73
proprietary, exposing, 318-35
providers, 335-44
readers, 72-73, 341-42
types, 276
views, rendering, to XML, 332
data binding
complex, 6-7
described, 6-7, 32-42
dynamic, 41-42
editing controls and, 108, 123, 130
programmatic, 40-42
simple, 5-6
sources, feasible, 4-5
templated controls and, 96
data pagination, 43-48 (see also pagination)
data reporting
advanced, 175-209
aggregates and, 201-9
item selection and, 175-95
SuperGrid control and, 187-88
summary rows and, 201-9
Database property, 338
DataBind method, 5, 14, 17, 48, 93, 108, 130
DataBinder class, 15, 76
DataBinder.Eval method, 15-16, 18
DataBinding event, 96-97
DataBox control, 153-157
DataColumn object, 225-26, 231, 326, 346
DataField property, 33, 76
DataFormatString property, 33, 85, 116, 120
DataGrid control, 26-31, 262, 267-68
aggregates and, 201-9
binding columns and, 32-42
button columns and, 34-37
code reusability and, 167-70
column types supported by, 31-32
columns created with, 27
constituent items of, 29-31
data pagination and, 43-59, 73
data persistence and, 68, 72-73
data reporting and, 175-209
described, 6-7, 26-27
disconnected Web applications and, 213-14, 223, 234-35
editing, 105-36
exposing data and, 347-48, 351-53
filtered views and, 185-86
item selection and, 178, 185-201
pager bar and, 45-46
sorting columns and, 59-68
summary rows and, 201-9
templated controls and, 74-104
updating rows and, 223
<datagrid> tag, 92
DataGridCommandEventArgs class, 36
DataGridItem class, 94, 177, 192-94
DataGridPageChangedEventArgs class, 37
DataGridSortCommandEventArgs class, 60
DataKeyField object, 194
DataKeyField property, 23, 180, 182
DataKeys collection, 23, 182, 223
DataKeys property, 180, 194
DataList control, 43-44, 175-76
described, 6-7, 19-26
events, 21-23
relating graphical and data elements with, 23-26
support for predefined command names, 22-23
templates specific to, 20
DataMember property, 4, 7-9, 12-13
DataNavigateUrlField property, 37, 39
DataNavigateUrlFormatString property, 37, 39
DataReader class, 68
DataReader object, 214, 248, 341-42
DataRelation object, 102, 208
DataRow object, 180, 183-85, 352-53
data reporting and, 185, 194-95, 208
deleting rows and, 224
disconnected Web applications and, 218-19, 223-28, 235, 237, 247-49
editing controls and, 128-29, 131-32
updating rows and, 223
DataRowCollection class, 218, 224, 226
DataRowState enumeration, 130, 239
DataRowView object, 101-2, 120
DataSet class, 4, 5, 25, 72, 102, 131, 212-45, 250
adapting, 262-69
commit model, 130-31
exposing data and, 317, 319, 322-23, 332, 336-38, 342-49
implications of, for Web applications, 212-14
inserting rows and, 222-23
interoperable Web applications and, 261-76
loading, from XML, 229-30
loading a Recordset object into, 263-64
purpose of, 212-14
serializing, to Recordset objects, 269-70
summitting changes and, 233-42
XML schema for, 270-76
Web services and, 312
DataSetIndex property, 177
DataSetName property, 230
DataSource property, 4, 7-9, 12-15, 19, 44-45, 48
data pagination and, 57
data persistence and, 68
data reporting and, 199-200
DataTable class, 4, 8, 58, 62 102, 217-38, 264-68
data reporting and, 184, 194-98, 200
deleting rows and, 224
editing controls and, 120, 128-29, 133, 134
exposing data and, 317, 319-24, 343, 345-47, 352
in-memory tables and, 324-30
loading a Recordset object into, 264-65
DataTextField property, 4, 7-9, 12-13, 34, 37-39, 76
DataTextFormatString property, 8-9, 12-13, 34, 38, 39
datatype element, 276
DataValueField property, 7-9, 12, 13
DataView class, 4, 19, 62, 64-65, 169, 236, 237
data reporting and, 183, 185, 196
exposing data and, 331, 332
DataViewManager object, 185
DateBox control, 153-61
DateBox.ascx, 160-61
DateChanged event, 153, 157, 158, 160, 161
DateChangedEventArgs class, 158, 160-61
DateTime property, 124
DBConcurrencyException exception, 246-47
DefaultView property, 62
delete command, 22
DELETE command, 227, 241, 244, 343
Delete method, 224, 226-28
DeleteCommand event, 22
DeleteCommand property, 240, 243-44, 343
Description keyword, 289
Description property, 291
deserialization process, 279-80
Deserialize method, 279
desktop.ini file, 327-28
DHTML (Dynamic HTML), 147, 299, 310
DiffGram format, 215, 229-33, 235
dir command, 320
directives. See also directives (listed by name)
code-behind approach and, 141
custom controls and, 165
described, 139-40
loading pagelets and, 151-52
sharing user controls and, 152
writing user controls and, 148-49
directives (listed by name). See also directives
@ Assembly directive, 258, 302
@ Control directive, 151-52, 161
@ Import directive, 258-59
@ Page directive, 141, 142, 152
@ Reference directive, 152
@ Register directive, 148-49, 165
directory information, 93-94, 326-27
DirectoryInfo class, 326
DirectoryList.cs, 322
DirectoryListing class, 319-24, 330-33, 338, 344, 346
DirectoryListing.cs, 328
disconnected Web applications
autoincrement fields and, 224-26
described, 211-52
batch updates and, 219-28
data conflicts and, 246-51
generating commands and, 239-42
in-memory changes and, 221-24, 250
offline data buffers and, 229-33
submitting changes and, 233-42
transparent data sources and, 215-19
discovery (.DISCO) files, 309
Dispose method, 340
DLLs (Dynamic Link Libraries)
interoperable Web applications and, 257-58, 266
Web services and, 286, 293-94
Document Type Definitions. See DTDs
Down Arrow button, 155, 156
drill-down, 183-85
drop-down lists, generating, 8-10, 103
DropDown.aspx, 9
DropDownList control, 6, 7-10
DTDs (Document Type Definitions), 270
dump files, 216
Dynamic HTML. See DHTML
Dynamic Link Libraries. See DLLs
E
Edit command, 22, 31, 106, 107
Edit link button, 108
edit mode
DataGrid control in, 108
graphical rendering of, 22
switching to, 129-30
EditCommand event, 22, 111, 119
EditCommandColumn class, 106-7
EditCommandColumn column type, 31, 106-7, 176- 77
editing. See also editing controls
adding layouts to data, 120-26
adding new rows, 126-35
canceling updates, 131-32
columns, 121-26
in-place, 106-17
saving changes made when, 132-35
stripping off unneeded text, 120
templates and, 117-26
updating tables and grids, 130-35
editing controls. See also editing
changing row styles when, 109-10
described, 105-36
stored procedures and, 113-14
triggers and, 115-16
updating data sources and, 113-14
EditItemIndex property, 108, 119, 129-30
EditItemStyle property, 30, 109-10
EditItemTemplate property, 75-77, 88
EditItemTemplate template, 20, 76-77, 88, 117-18
EditRowsWithUpdateSP.aspx, 115
EditText property, 106, 108, 110, 150
EditWithImages.aspx, 135
EmployeeManagerWithImages.aspx, 186
Employees Manager, 186, 215-36
Employees table, 6, 101-2
disconnected Web applications and, 222, 225
editing controls and, 113-14, 124, 133
EmpMan.aspx, 215
EnableSession property, 291, 308
errors
checking, 157
disconnected Web applications and, 216
event handling and, 157, 160
OnClick event and, 191
Eval method, 197
event handlers. See also specific event handlers
programmatic binding and, 40-41
registering, 107-8
EventArgs class, 158-59, 170
eventDateChanged structure, 159
EventHandler event handler, 157
events. See also specific events
code reusability and, 158-61
custom arguments for, 158-60
DataGrid control and, 26
DataList control and, 21-23
firing, 157-61
Repeater control and, 16-19
Excel, 26, 105
ExecuteReader method, 57
ExecuteResultSet class, 261
ExecuteScalar method, 55
exporting, data to XML, 281-82
Expression property, 200
ExtendedProperties collection, 245
eXtensible Markup Language. See XML
ExtensionType property, 313
F
FETCH statement, 58
fidelity, type, 281
fields
auto-increment, 224-26
concatenating, 79-80
edited, reading text from, 111-12
sorting, 64
values for, selecting rows with, 182-83
file system path, 93-94
<File> tag, 323
FileAttributes class, 327
FileInfo class, 326
FileInfo method, 328-29
FileSystemDataAdapter class, 348, 353
FileSystemDataAdapter.cs, 353
Fill method, 242, 262-65, 320-24, 331, 342-43, 346-50
FillSchema method, 223, 346
filter attribute, 40
filtered views, 4, 185-86
Find method, 183, 184
FindControl method, 92, 111, 118-19, 192
FIRST clause, 56
firstname field, 6, 24, 80, 124
<Folder> tag, 323
Font property, 48
fonts, 48, 155. See also text
footers
DataGrid control and, 30
enabling, 53-54
setting up, 90-91
templates for, 14, 18-19, 75-77, 189-91
FooterStyle property, 30, 33, 53, 78
FooterTemplate property, 75-77, 190
<FooterTemplate> tag, 90
FooterTemplate template, 189-90
FooterText property, 33, 34, 38, 53
FOR XML clause, 340
ForeColor property, 153
<form> tag, 152
forms, 6, 152, 168, 306
Web forms, 68, 147, 332-33
Windows Forms, 302-4, 312, 330-33
Forms control, 168
FormsIdentity class, 306
FormViewer.aspx, 6
frameborder attribute, 39
frames, 39-40
G
get accessor, 154
GET command, 296-99, 301
GetBoundData method, 6
GetChanges method, 130, 228, 233-34, 238-39, 250
GetChildRows method, 102, 208
GetDataFromCache method, 222-23
GetDeleteCommand method, 244
GetDirectories method, 326
GetFiles method, 328
GetInitializer method, 314
GetInsertCommand method, 244
GetObjectData method, 279
GetString method, 342
GetTerritories function, 101-3
GetType method, 257
GetUpdateCommand method, 244
GetValues method, 248, 342
Go button, 182-83, 331
graphical elements. See images
GridLines property, 84
grids. See also pageable data grids
add-row feature and, 126-27
editable, 110
updating, 130-35
GROUP BY clause, 203
GROUPING function, 203
GroupingColumns.aspx, 83
H
HandleItemCommand function, 21-22
HasChanges method, 130, 132, 228, 234-35
Header template, 18
HeaderImageUrl property, 33-34, 38
headers, 81-83, 85-88
custom layouts for, 86-87
sorting columns and, 61
styles for, 30, 33, 78
templates for, 14, 18, 75-77, 88
HeaderStyle property, 30, 33, 78
HeaderTemplate property, 75-77, 88
HeaderTemplate template, 14
HeaderText property, 33, 34, 38
href attribute, 85
<html> tag, 152
HTTP (HyperText Transfer Protocol), 86, 307
code reusability and, 142, 150, 167
GET command, 296-99, 301
pipeline, 294-95
POST command, 296-99, 301
Runtime, 167, 295
Web services and, 285, 287, 292-98, 303, 307, 309
HttpContext object, 288
HttpGetClientProtocol class, 301
HttpPostClientProtocol class, 301
HttpRuntime class, 295
HyperLink control, 85
HyperLinkColumn class, 37-40, 37-38, 123
HyperLinkColumn column type, 32, 37-40, 123
Hyperlinks.aspx, 39
HyperText Transfer Protocol. See HTTP
I
IAsyncResult interface, 311-12
ICollection interface, 4, 8
IDataAdapter interface, 336-38, 342, 344-46, 349
IDataParameter interface, 337
IDataReader interface, 337
IDbCommand interface, 337
IDbConnection interface, 337, 338
IDbDataAdapter interface, 337, 343
IDbTransaction interface, 337, 338
IDE (integrated development environment), 142
IDENTITY_INSERT attribute, 225
IDeserializationCallback interface, 280
<iframe> tag, 39, 42, 275
IHttpModule interface, 295
IIS (Internet Information Services), 289, 293-94, 306- 7
ILDASM (Intermediate Language Disassembler), 267
images, 23-26, 121-26, 179. See also <img> tag
displaying, 99-100
editing, 110
Images.aspx, 99
ImageUrl attribute, 99
<img> tag, 122, 143, 179. See also images
@ Import directive, 258-59
ImportAdo.aspx, 260
importing
ADO code, 260, 262
namespaces, 329-30
rows, 218-19, 332
ImportRow method, 218-19, 332
IN operator, 197
INamingContainer interface, 95
InferXMLSchema method, 229-30
infidelity, type, 281
information
directory, 93-94, 326-27
drill-down, 183-85
file, 328-30
inheritance, 145-47
Inherits attribute, 142
Init event handler, 189
in-memory tables
described, 324-30
desktop.ini file and, 327-28
directory information and, 326-27
file information and, 328-29
INNER JOIN command, 102, 243
in-place editing
described, 106-17
enabling, 105-10
templates and, 117-26
INSERT command, 225, 227, 240-41, 244
Insert method, 70
INSERT statement, 233-34, 343
InsertCommand property, 240, 243-44, 343
InstantiateIn method, 94, 95
IntelliSense, 259
internal keyword, 341
Internal_CreateTable function, 347
Internal_FillTable function, 347
Internet Explorer browser, 155, 212, 298. See also browsers
Internet Protocol. See IP
interoperable Web applications
ADO and, 257-62
cross-framework, 277
exposing data and, 318-35
overview of, 255-83
Web services and, 285-315
XML object serialization and, 278-82
XML schema and, 270-76
IP (Internet Protocol), 291
IPrincipal interface, 307
ISAPI filters, 293-94
IsDate function, 125
ISerializable interface, 278-80
IsInRole method, 307
IsLastPage function, 127
ISNULL function, 99, 233
Is operator, 51
Item property, 36
item selection
enabling, 176-79
formatted text and, 178-79
images and, 179
overview of, 175-86
retrieving selected items, 193-95
SelectedIndexChanged event and, 179-80
selecting multiple items, 186-95
SuperGrid control and, 187-93
views and, 185-86
Item template, 14
ItemArray property, 219, 231
ItemCommand handler, 35-36
ItemCreated event, 16, 31, 48-50, 61, 63, 76
code reusability and, 170
data reporting and, 206-7, 192, 197
editing controls and, 119-20, 127
footers and, 90-91
handler, 53, 67
templated controls and, 82-83, 86, 88, 90-91
ItemCommand event, 16-17, 21, 34-36, 91-92, 180- 81, 207
ItemDataBound event, 16, 88, 207, 208
ItemIndex property, 194
ITemplate interface, 88-89, 94-97, 189, 190
ITemplateClass.aspx, 97
Items collection, 12-13, 126, 177, 193, 274
Items property, 10, 14-15, 54, 57
ItemStyle property, 33, 78, 177, 178
ItemTemplate property, 75-77, 94
<ItemTemplate> tag, 89
ItemTemplate template, 189-90
ItemType property, 49, 83
iterative controls, 15
J-K
JavaScript, 85, 176
Jet engine, 335
keywords, 144, 289, 341
L
Label control, 76, 79, 85, 146, 151, 164
LabelBox control, 163-66
LabelBox.cs, 166
LabelText property, 150
lasagna code, 140-41, 167
<layer> tag, 39
layers, of pages, 139-41
LIKE operator, 197
link buttons, 155, 192
link columns, 37-40, 123
LinkButton object, 192
ListBox control, 7, 12-13
ListBox.aspx, 13
ListItem object, 10
ListItemCollection class, 10
ListItemType enumeration, 29, 49
lists, drop-down, 8-10, 103
LiteralControl control, 80, 85
loading
code-behind files, 141-42
data from generic sources, 216-17
pagelets programmatically, 151-52
templates, 88-90, 93-94, 189
LoadTemplate method, 88, 93-94, 189
login
authentication, 306-8
programmatic, 307-8
Login method, 308
M
managed providers. See .NET data providers
MappingType enumeration, 231
margins, 83-85, 120
MemberwiseClone method, 218
memory. See also caching
batch updates and, 133-35
in-, changes, applying, 221-24, 250
in-, tables, 324-30
locking rows and, 220-21
scalability and, 69
variable-to-variable assignments and, 218
MessageName property, 291, 303
methods
defining, for Web services, 290-93
minimizing roundtrips and, 305-6
signatures for, avoiding, 305
transactional, 292-93
writing, golden rule for, 305
MfieldSorting.aspx, 67
Microsoft ADO.NET (Core Reference) (Sceppa), 133
Microsoft BizTalk, 255
Microsoft Excel, 26, 105
Microsoft IIS (Internet Information Services), 289, 293-94, 306-7
Microsoft IntelliSense, 259
Microsoft Jet engine, 335
Microsoft Passport, 306
Microsoft SQL Server, 335-38, 340-41, 348. See also SQL
data pagination and, 56, 58, 73
disconnected Web applications and, 214, 217, 222, 225, 244-45
editing controls and, 132-34
Enterprise Manager, 126
inefficiency of, 9
returning calculated columns with, 8
Session object and, 70
summary rows and, 204
templated controls and, 93, 98
TOP clause and, 56
virtual item counts and, 55
Web services and, 315
Microsoft VBScript (Visual Basic Scripting Edition), 11
Microsoft Visual Basic, 68, 70, 89, 95
code reusability and, 141-42
COM objects, linking to, 266-67
components, caution with, 268-69
IDE (integrated development environment), 142
interoperable Web applications and, 262, 266-69, 276, 282
Web services and, 315
Microsoft Visual Studio, 258-59, 282, 300, 335
Microsoft Windows 3.x, 255
Microsoft Windows 95, 327
Microsoft Windows 98, 327
Microsoft Windows 2000, 327
Microsoft Windows Explorer, 327, 329, 353
Microsoft Windows Forms, 302-4, 312, 330-33
Microsoft Windows NT, 327, 329
Microsoft Windows XP, 327-28, 351
Microsoft XML Parser (MSXML), 298
migration
issues, 262
scenarios, 265-69
MissingMappingAction property, 343, 345
MissingSchemaAction property, 134, 223, 225, 264, 343, 345-46
mobile code, 314
Mode attribute, 46
MoveNext method, 211
MovePrevious method, 211
MS-DOS, 320
MyBase keyword, 144
MyBasePage class, 146
MyComp component, 266-67
MyComp.dll, 266
MySampleUpdate procedure, 115
MySoapExtension class, 313
N
Name attribute, 289, 302-3
named pipes, 294-95
namespaces, 160-61, 168
exposing data and, 317, 319, 326, 329-30, 334
importing, 258-59
interoperable Web applications and, 258-59, 262, 273-74, 278
Web services and, 288-90, 293, 300, 314
NamingContainer property, 97
NavigateUrl property, 37, 38
.NET. See also .NET Framework; .NET Web services
applications, exposing data to, 317-54
data providers, 335-44
.NET Framework
exposing data and, 320-24, 335
interoperable Web applications and, 256-62
migration issues and, 262
proxy classes and, 302-4
server cursors and, 261
Web services and, 302-4, 314-16
.NET Web services
invoking, 296-99
.NET Framework and, 302-4, 314-16
overview of, 288-304
Netscape Navigator, 156. See also browsers
new operator, 341
NewPageIndex property, 47
NewRow method, 219
NorthwindInfoService class, 300, 303
NotSupportedException exception, 338, 346
n-tier applications, 211
null values, 124-25, 232-33
nullvalues.aspx, 233
number symbol (#), 5
nwservice.asmx, 292
NWServiceCallback method, 312
O
Object class, 55
object serialization
enabling, 278-81
type binding and, 280-81
XML, 278-82
ObjectContext object, 269
ODBC (Open Database Connectivity), 73, 255, 335
OK button, 108, 112
OLE DB, 73, 255, 260, 262-63
exposing data and, 317-19, 333-38, 343-44
Simple Provider Toolkit, 318
OleDbDataAdapter class, 262-63, 267
OnCancelCommand attribute, 107
OnClick event, 21, 181, 191-93
OnClick event handler, 191-93
OnDeserialization method, 280
OnEditCommand attribute, 107
OnInit event, 146
OnItemCommand attribute, 35, 92
OnRemove event, 70
OnUnselect event handler, 192
OnUpdateCommand attribute, 107
Open Database Connectivity. See ODBC
Open method, 259, 338, 339
optimistic
concurrency, principle of, 246-47
lock model, 215, 221
ORDER BY clause, 59
Order class, 278
OrderID field, 206
Orders table, 207
OrdersSummary table, 206-7
P
Page class, 88, 142
@ Page directive, 141, 142, 152
page layout
described, 139-40
lasagna code and, 140-41
Page object, 93, 189
pageable data grids. See also grids
binding columns and, 32-42
Cache object and, 70-71
data adapters and, 72-73
data pagination and, 43-59, 73
data persistence and, 68, 72-73
data readers and, 72-73
overview of, 29-74
pager bar and, 45-46
scalability and, 69, 73
Session object and, 69-70
sorting columns and, 59-68
sorting fields and, 64
XML and, 71-72
PageButtonCount property, 46
PageCount property, 45
PageHandlerFactory class, 295
PageIndexChanged event, 26, 45, 47-48, 169-70, 182
PageletDynamicBinding.aspx, 151
pagelets, 88, 147, 151. See also user controls
Page_Load event, 40-41, 54, 146, 150
Page_Load event handler, 40-41, 146, 150
pager bars
custom, 48-53, 50, 52
DataGrid control and, 30
described, 30, 45-46
PagerStyle property, 30, 46, 48, 50
PageSize property, 45
pagination
custom, 54-59
disconnected Web applications and, 214
enabling, 47-48
obtaining page counts, 55-58
overview of, 43-48
paradox of, 73
properties, 45
semiautomatic, 43-45
setting the virtual item count for, 54-55
Parameters collection, 241, 341
Parameters property, 340
parentFolder property, 350
Passport, 306
PassportIdentity class, 306
Path property, 320-21
percent sign (%), 5
PersonalPage.aspx, 52
pessimistic lock model, 220-21
pipes, named, 294-95
plus sign (+) operator, 94
POST command, 296-99, 301
PowerGrid control, 169-72, 186-87
PowerGrid.cs, 171
Prepare method, 341
PrepareSortExpression routine, 65
PrimaryKeys collection, 134
printf function, 38
ProcessMessage method, 313
ProcessSortExpression routine, 65
ProductID field, 56
Products table, 56
ProgBinding.aspx, 42
properties. See also DataSource property; Text property
AllowCustomPaging, 45, 54
AllowDBNull, 223
AllowMultiSelect, 187-88
AllowMultiSelectFooter, 187-88, 190
AllowPaging, 44, 45, 47, 54
AllowSorting, 59-60
AlternatingItemStyle, 30, 178
AsynchState, 312
Attributes, 327
AutoGenerateColumns, 31, 32
AutoIncrement, 223, 225
BackColor, 48, 153, 197
Binder, 280
BorderSize, 155
BorderStyle, 48
BufferResponse, 291
ButtonType, 34
CacheDuration, 291-92
CancelText, 108, 110
CellPadding, 83-84
CellSpacing, 84
Checked, 98
ColumnMapping, 231
Columns, 155
ColumnSpan, 54, 83
CommandName, 17, 34, 36, 91, 176-77
CommandSource, 16-17, 36, 47
CommandText, 244, 340
CommandTimeout, 244
Connection, 244
ConnectionString, 338-39
ConnectionTimeout, 338
Count, 19
CurrentPageIndex, 45, 47, 48, 130, 132
Database, 338
DataField, 33, 76
DataFormatString, 33, 85, 116, 120
DataKeyField, 23, 180, 182
DataKeys, 180, 194
DataMember, 4, 7-9, 12-13
DataNavigateUrlField, 37, 39
DataNavigateUrlFormatString, 37, 39
DataSetIndex, 177
DataSetName, 230
DataTextField, 4, 7-9, 12-13, 34, 37-39, 76
DataTextFormatString, 8-9, 12-13, 34, 38, 39
DataValueField, 7-9, 12, 13
DateTime, 124
DefaultView, 62
DeleteCommand, 240, 243-44, 343
Description, 291
EditItemIndex, 108, 119, 129-30
EditItemStyle, 30, 109-10
EditItemTemplate, 75-77, 88
EditText, 106, 108, 110, 150
EnableSession, 291, 308
Expression, 200
ExtensionType, 313
Font, 48
FooterStyle, 30, 33, 53, 78
FooterTemplate, 75-77, 190
FooterText, 33, 34, 38, 53
ForeColor, 153
GridLines, 84
HeaderImageUrl, 33-34, 38
HeaderStyle, 30, 33, 78
HeaderTemplate, 75-77, 88
HeaderText, 33, 34, 38
InsertCommand, 240, 243-44, 343
Item, 36
ItemArray, 219, 231
ItemIndex, 194
Items, 10, 14-15, 54, 57
ItemStyle, 33, 78, 177, 178
ItemTemplate, 75-77, 94
ItemType, 49, 83
LabelText, 150
MessageName, 291, 303
MissingMappingAction, 343, 345
MissingSchemaAction, 134, 223, 225, 264, 343, 345- 46
NamingContainer, 97
NavigateUrl, 37, 38
NewPageIndex, 47
PageButtonCount, 46
PageCount, 45
PagerStyle, 30, 46, 48, 50
PageSize, 45
Parameters, 340
parentFolder, 350
Path, 320-21
RadioButtonList, 12
ReadOnly, 33, 223
RecordsAffected, 342
RepeatColumns, 12
RepeatDirection, 12
RepeatLayout, 12
Row, 237, 247
RowFilter, 185
RowSelectFilter, 196, 198-99
RowState, 228, 236
RowStateFilter, 236
SelectBackColor, 196
SelectCommand, 242, 243-44
Selected, 10, 274
SelectedDate, 124, 153, 154, 159
SelectedIndex, 7, 26, 120, 177, 180-82
SelectedItem, 7, 11-12, 177, 180
SelectedItemIndex, 176
SelectedItems, 187, 193, 194
SelectedItemStyle, 20, 24, 30, 176-77
Separator, 153
ShowFooter, 53, 77, 127
Sort, 62
SortExpression, 33-34, 38, 60-61, 80, 87, 171-72
SourceColumn, 240
SourceVersion, 240
State, 338
Table, 219
TableMappings, 343, 345
Target, 38, 39
ToolTip, 66-67
Transaction, 244, 340
TransactionOption, 291
Unique, 223
UpdateCommand, 240, 243-44, 343
UpdateText, 108, 110
Url, 301
Value, 9, 92, 275
ViewState, 41-44, 64-66, 68
VirtualItemCount, 45, 54-55
VisibleDate, 124
Properties dialog box, 329
proprietary data, exposing, 318-35
protocols. See also HTTP; SOAP
choosing, 301
IP (Internet Protocol), 291
proxy classes, 300-304, 312
ProxyClass.aspx, 303
Q
queries. See also SQL
correct implementation of, 202
disconnected Web applications and, 214
relations between tables and, 202-9
typical result set generated by, 202
R
RadioButton control, 11
RadioButtonList control, 6, 11-12
RadioButtonList property, 12
Read method, 342
readers, data, 72-73, 341-42
ReadMode method, 230
ReadOnly property, 33, 223
ReadSchema option, 229
ReadXml method, 229
ReadXmlSchema method, 270
RecordsAffected property, 342
Recordset class, 258
adapting, 262-69
checkboxes created from rows in, 260
interoperable Web applications and, 258-75
loading, 263-65
migration issues and, 266
serializing DataSet objects to, 269-70
status of, 264
recordsets, getting, 259-60. See also Recordset object
@ Reference directive, 152
refreshing
schema, 244
views, 92-93
RefreshSchema method, 244
@ Register directive, 148-49, 165
registry, 329-40
Registry class, 329-40
RegularExpressionValidator class, 118
Reject button, 235
reject command, 237
RejectChanges method, 131, 224, 227-28, 235
Relations collection, 102
Remove method, 224, 226-28
Render method, 165
RepeatColumns property, 12
RepeatDirection property, 12
Repeater control
accessing data-bound information with, 14-19
described, 6-7, 14-19
events, 16-19
templated controls and, 97
RepeaterItem object, 14-15
RepeatLayout property, 12
ReportsTo field, 98-99
ROLLUP operator, 203
root information, writing, 273
roundtrips, to Web servers, 301, 305-6
Row property, 237, 247
RowFilter property, 185
rows
adding, 126-35, 205-6, 222-23
blank, 128-29
deleting, 224, 226-28, 241-42
deselecting, 181-82
determining control height based on the number of, 13
identifying, 231-32
importing, 218-19, 332
locking, 220-21
restoring modified, 237-29
selecting, 176, 181-83
states of, 228
styles for, 109-10, 177-78
summary, 201-9
updating, 223-24, 241
Rows collection, 218-19, 224, 326
RowSelectFilter property, 196, 198-99
RowState method, 226
RowState property, 228, 236
RowStateFilter property, 236
RowUpdated event, 239, 250
RowUpdating event, 239
runat attribute, 142, 150
S
saving changes, 132-35
scalability, 69, 73
Sceppa, David, 133
schema, 269-76, 281-82, 287, 298, 321, 323
<script> tag, 95, 140, 143-45, 167
scripts, invoking Web services from, 298-99
security, 306-8, 314
Select column, 189-90
select command, 22, 176
SELECT command, 58
Select method, 184-86, 195, 197-98, 352
restoring rows and, 237
updating rows and, 223
select mode, 22
SELECT statement, 55, 203, 246
SelectBackColor property, 196
SelectCommand object, 244-45
SelectCommand property, 242, 243-44
Selected property, 10, 274
SelectedDate property, 124, 153, 154, 159
SelectedIndex property, 7, 26, 120, 177, 180-82
SelectedIndexChanged event, 24, 177, 179-84
SelectedIndexChangedCommand event, 22
SelectedItem property, 7, 11-12, 177, 180
SelectedItemIndex property, 176
SelectedItems property, 187, 193, 194
SelectedItemStyle property, 20, 24, 30, 176-77
<SelectedItemStyle> tag, 76
SelectedItemTemplate template, 20, 176
SelectionChanged event, 156, 158-59
sender parameter, 97
Separator property, 153
Separator template, 14
SerializableAttribute attribute, 278
serialization, object
enabling, 278-81
type binding and, 280-81
XML, 278-82
SerializationBinder class, 280
SerializationInfo structure, 279
Serialize method, 279
server cursors, 261
servers
disconnected Web applications and, 212, 215
roundtrips to, 301, 305-6
security and, 314
selection events and, 176
Session Manager, 70
Session object, 6, 44, 62, 68-72, 128, 277
Cache object and, 216
disconnected Web applications and, 213, 216
Web services and, 308
XML and, 71-72
set accessor, 154
SET ROWCOUNT statement, 56
SetAbort method, 293
SetComplete method, 293
Short, Scott, 287
ShowFooter attribute, 90
ShowFooter property, 53, 77, 127
Simple Object Access Protocol. See SOAP
single quote ('), 5
Size attribute, 155
SOAP (Simple Object Access Protocol), 277-79, 319
extensions, 312-14
Web services and, 287, 295-96, 301, 309, 312-14
SoapClientMessage argument, 313
SoapExtension class, 313
SoapFormatter class, 278, 280
Sort property, 62
SortableTemplateColumns.aspx, 80
SortColumns.aspx, 60
SortCommand event, 26, 60, 64-65, 170
SortExpression attribute, 87-88
SortExpression property, 33-34, 38, 60-61, 80, 87, 171-72
sorting
auto-reverse, 61-66
columns, 59-68, 80-81
multiple fields, 64
setting up, 60-64
SourceColumn property, 240
SourceVersion property, 240
spaghetti code, 139, 140-41
<span> tag, 85, 120
SQL (Structured Query Language). See also queries; SQL Server
data pagination and, 55-59
disconnected Web applications and, 220, 240, 244- 45
Distributed Management Objects (SQL-DMO), 315
editing controls and, 113-15, 132-33
generic, 58-59
Profiler, 245
relations between tables and, 202-9
statements, saving changes with, 132-33
templated controls and, 98-101
SQL Server, 335-38, 340-41, 348. See also SQL
data pagination and, 56, 58, 73
disconnected Web applications and, 214, 217, 222, 225, 244-45
editing controls and, 132-34
Enterprise Manager, 126
inefficiency of, 9
returning calculated columns with, 8
Session object and, 70
summary rows and, 204
templated controls and, 93, 98
TOP clause and, 56
virtual item counts and, 55
Web services and, 315
SqlCommand class, 55, 240
SqlDataAdapter class, 57
SqlDataReader class, 25, 57, 73
SqlParameter class, 340
SqlParameterCollection class, 340
SqlResultSet class, 261
src attribute, 89, 142
srcTable argument, 263
STAs (single-threaded apartments), 268
state management, 308
State property, 338
stored procedures, 113-14
strFilter variable, 331
String object, 10
StringBuilder class, 10, 94, 273
strings
command names and, 22
comma-separated, 65
concatenating, 94
data binding and, 20
indicating colors with, 20
loading templates from, 93-94
Structured Query Language. See SQL
styles. See also CSS
footer, 30, 33, 53, 78
header, 30, 33, 78
item, 33, 78, 177, 178
row, 109-10, 177-78
subtables, creating, 217-19
summary rows, 201-9. See also rows
Summary.aspx, 208
Summary.cs, 208
SuperGrid control, 186-93, 191
SuperGrid.cs, 200, 208
symbols
adding, to link buttons, 155
angle brackets (<>), 5
dash (-), 300
number symbol (#), 5
percent sign (%), 5
single quote ('), 5
underscore character (_), 300
wildcard characters, 331
System.Data.OleDb namespace, 262
System.Drawing namespace, 20
T
Table property, 219
<table> tag, 83-84
TableCell control, 49, 50
TableMappings property, 343, 345
TableRow control, 50
TableRow class, 49
tables
creating relations between, 202-9
in-memory, 324-30
mapping mechanisms for, 345-46
schema for, cloning, 218
updating, 130-35
TagPrefix attribute, 187
tags (listed by name)
<AlternatingItemStyle>, 76
<body>, 152
<columns>, 32, 40
<datagrid>, 92
<File>, 323
<Folder>, 323
<FooterTemplate>, 90
<form>, 152
<html>, 152
<iframe>, 39, 42, 275
<img>, 122, 143, 179
<ItemTemplate>, 89
<layer>, 39
<script>, 95, 140, 143-45, 167
<SelectedItemStyle>, 76
<span>, 85, 120
<table>, 83-84
<td>, 85, 111
<TemplateColumn>, 75-76
<tr>, 50, 85
<xml>, 273
Target property, 38, 39
<td> tag, 85, 111
TemplateColumn column type, 32, 75-79, 85, 117
TemplateColumn class, 76, 78-79, 85, 117
<TemplateColumn> tag, 75-76
TemplateColumns.aspx, 79
templated columns. See also templates
adapting, to data, 97-103
arrays and, 100-103
building, 75-78
concatenating data fields and, 79-80
displaying images and, 99-100
editing, 117-26
enabling, 78-88
footers for, setting up, 90-91
grouping, 81-83
margins for, adjusting, 83-85
multiple views for, managing, 89-93
sorting, 80-81
templates. See also templated columns
DataGrid control and, 26, 74-104
DataList control and, 20
dynamic creation of, 88-97
footer, 14, 18-19, 75-77, 189-91
header, 14, 18, 75-77, 88
in-place editing with, 117-26
loading, 88-90, 93-94, 189
Repeater control and, 14
text for, writing, 94-95
Territories table, 102
TestDateBox.aspx, 161
TestLabelBox.aspx, 166
TestPowerGrid.aspx, 171
TestPowerGrid.cs, 171
text. See also text boxes
data reporting and, 178-79
font for, 48, 155
formatted, 120, 178-79
page button, 46
reading, from edited fields, 111-12
template, writing, 94-95
text boxes, 6, 111-12, 162-65
borderless, 154-55
fonts for, 155
Text property, 4-5, 9-10, 34, 76, 79, 92
code reusability and, 150, 151
data reporting and, 176, 179
DataTextField property and, as mutual exclusive, 37
described, 38
TextBox control, 162-65
title attribute, 155
tlbimp.exe, 257, 266
ToolTip property, 66-67
tooltips, 66-67, 110, 155, 327
TOP clause, 56, 59
ToString method, 236, 257, 327
<tr> tag, 50, 85
tracing, enabling, 180-81
Transaction property, 244, 340
TransactionOption property, 291
transparent data sources, 215-19
triggers, 115-16
try/catch blocks, 12, 70, 157, 184, 216
T-SQL, 58-59, 135
GROUPING function, 203
ISNULL function, 99, 233
type
binding, 280-81
fidelity/infidelity, 281
U
UDA (Universal Data Access), 317
UDDI (Universal Description, Discovery, and Integra.tion), 287, 308-9
underscore character (_), 300
Uniform Resource Identifers. See URIs
Uniform Resource Locators. See URLs
Uniform Resource Names. See URNs
Unique property, 223
Universal Data Access. See UDA
Universal Description, Discovery, and Integration. See UDDI
Unselect button, 25
update command, 22
UPDATE command, 227, 241, 247
Update method, 133, 135, 219, 227, 343, 346-53
command builders and, 243
data adapters and, 239
in-memory changes and, 250
UPDATE statement, 233-34, 244, 246, 343
UpdateCommand event, 22, 111-12, 132, 134, 352
UpdateCommand event handler, 111-12, 132, 134, 352
UpdateCommand property, 240, 243-44, 343
updates. See also batch updates
cancelling, 131-32
detecting, 349-50
data sources and, 348-53
exposing data and, 343, 346, 348-53
implementing, 350-51
rows and, 223, 241
tables and, 130-35, 223, 241
user interfaces and, 351-53
UpdateText property, 108, 110
UpdateView event, 170-71
UpdateView method, 129-30
URIs (Uniform Resource Identifers), 290
Url property, 301
URLs (Uniform Resource Locators), 94, 216
code reusability and, 142, 146
default namespaces and, 289-90
image, 99-100
indicating fully qualified, 93
parameters for, 216
underlying, accessing, 301-2
Web services and, 286, 289-90, 294, 296, 299-303
URNs (Uniform Resource Names), 290
user controls
code reusability and, 147-53
preparing to share, 152
programming, declaratively, 149-50
writing, 147-53
user interfaces, updating, 351-53
User object, 288
UsingGenericSql.aspx, 59
V
Value property, 9, 92, 275
variable-to-variable assignments, 218
VBScript (Visual Basic Scripting Edition), 11
ViewPanel control, 184-85
views
applying, 91-92
creating, based on file extensions, 331
exposing data and, 331-32
filtered, 4, 185-86
managing, 89-93
refreshing, 92-93
rendering, to XML, 332
ViewState collection, 60, 62, 171, 196
ViewState object, 42
ViewState property, 41-44, 64-66, 68
virtual
item count, 45, 54-55
path, 93-94, 189
VirtualItemCount property, 45, 54-55
Visible attribute, 51, 53
VisibleDate property, 124
visual inheritance, 145-47
Visual Basic, 68, 70, 89, 95
code reusability and, 141-42
COM objects, linking to, 266-67
components, caution with, 268-69
IDE (integrated development environment), 142
interoperable Web applications and, 262, 266-69, 276, 282
Web services and, 315
Visual Studio, 258-59, 282, 300, 335
W
W3C (World Wide Web Consortium), 270, 287
Web farm architectures, 70, 71
Web forms, 68, 147, 332-33
Web Services
asynchronous calls and, 310-12
authentication and, 306-8
authorization and, 306-8
contract design and, 304-5
default namespaces and, 289-90
defining Web methods for, 290-93
deploying, 308-9
Description Language (WSDL), 287, 289-90, 300- 302, 305, 309
implementation of, 304-9
optimization of, 308-15
overview of, 285-315
proxy classes and, 300-304
publishing, 308-9
security for, 307
SOAP extensions and, 312-14
specifications for, 286-87
state management and, 308
underlying technologies for, 287
WebClientProtocol class, 301
WebMethod attribute, 290-92, 308
WebMethod class, 303
WebService attribute, 288-89
WebService class, 288, 306
WHERE clause, 55-56, 241, 245-47
wildcard characters, 331
Win32 applications, 255, 294, 313, 328-30, 334
Windows 3.x, 255
Windows 95, 327
Windows 98, 327
Windows 2000, 327
Windows Explorer, 327, 329, 353
Windows Forms, 302-4, 312, 330-33
Windows NT, 327, 329
Windows XP, 327-28, 351
WindowsIdentity class, 306
WITH ROLLUP extension, 203-3
World Wide Web Consortium. See W3C
WriteXmlSchema method, 270
WSDL (Web Services Description Language), 287, 289-90, 300-302, 305, 309
wsdl.exe, 300-302
X
XML (eXtensible Markup Language)
code reusability and, 168
data persistence and, 68
Data Reduced (XDR), 269-70, 274, 276
data types and, 276
DiffGram format, 215, 229-33, 235
disconnected Web applications and, 211-17, 229-33
disk files, 217
documents, binding, 5
exporting data to, 281-82
exposing data and, 318-24, 332-35
interoperable Web applications and, 255-56, 269-70, 276-77, 281-82
loading the DataSet object from, 229-30
null values and, 232-33
object serialization, 278-82
pageable data grids and, 71-72
rendering data views to, 332
schema, 269-76, 281-82, 287, 298, 321, 323
Schema Definition (XSD), 269-70, 274, 281-82
serialization, 269-70
templated controls and, 93
Transformations (XSLT), 273
Web services and, 286-87, 298, 312
<xml> tag, 273
XmlCreator.aspx, 217
XmlDataDocument class, 319
XmlReader class, 319
XmlReadMode enumeration, 229
XmlSerializer class, 277, 281
XmlWriteMode enumeration, 229
XmlWriter class, 319
XPathNavigator class, 319
XSD (XML Schema Definition), 269-70, 274, 281-82
xsd.exe, 270, 281
XSLT (XSL Transformations), 273
Last Updated: January 30, 2002
|
