Training
Certifications
Books
Special Offers
Community




 
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.
 

More Information

About the Book
Table of Contents
Sample Chapter
Index
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books

 

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
Top of Page