|
|
 |
|
|
|
Web Database Development Step by Step .NET Edition
|
|
|
Author
|
|
Jim Buyens
|
|
|
Pages
|
560
|
|
Disk
|
1 Companion CD(s)
|
|
Level
|
Beg/Int
|
|
Published
|
04/10/2002
|
|
ISBN
|
9780735616370
|
|
Price
|
$39.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
A
Access
AutoNumber fields, 269, 274-80
connection strings, 394
creating SQL statements with, 240
databases, locating, 250
databases, security, 56, 250
parameter directions, 268
vs. SQL Server, 8
access
allowing and denying (see authentication)
rules, specifying, 407
upload (see file uploads)
to Web services, 480
access modifiers, Visual Basic .NET, 196
ActiveX controls
advantages and disadvantages, 328
Add method, 186, 272
AddHeader method, 79
addition operator, when to use, 164
AddNew method, 283
AddressOf operator, 166
administrative tools Start menu, 31
ADO, 243
ADO.NET, 6, 30
connections, 246-47
locking database records, 244
objects, 244, 245
processing transactions in, 285-86
and Recordset objects, 269
resource management, 245
running queries, 263
similarity to Web browser, 245
SQL and, 7
and stateless operation, 244
synchronizing records, 244
transactions, 285
updating records, 245
using with ASP.NET, 247
vs. ADO, 243
And operator 165-66
anonymous user accounts, 55
Apache servers, IIS and, 33
APIs, 244
application, new, creating, 422
application mappings, displaying, 51
Application object, 39-932, 396, 515
application roots, 46, 341, 393
applications, 45, 207
entities, 212-13
new, creating, 460
performance, measuring, 508
arguments
coding, for SELECT statements, 235
coding on Set statement, 196
converting into URLs, 82
arguments, ASP.NET, 15
arithmetic operators, 160
ArrayList object, 182, 514
arrays, 174-79
As keyword, specifying with data type, 175
ASP, 4
API, lack of access to, 60
classic, functioning of, 60
filename extensions, vs. ASP.NET, 7
HTML form elements, 61
limitations of, 4
.NET Framework, effect of installing, 31
program code, 60
sending e-mail, 419
syntax, vs. ASP.NET, 74
threading model, 188
upgrading to ASP.NET, 7
vs. ASP.NET, 61, 511
ASP.NET, 8
advantages of, 5
applications, 46-50
authentication (see authentication)
browser support for, 6
buffer, 76
buttons, 62
caching internal objects, 511
calling method, 480
classes, 13
code (see code)
and common language runtime, 511
compilers (see compilers)
configuring server for, 8
containers, 148
directives, 85
elements, coding, 64-67
environment, verifying, 523
events supported, 147
file, creating new, 10
file uploads, processing, 456
filename extensions (see filename extensions)
flexibility of, 5
GIF picture output, 54
HTML (see HTML)
installing, 38
integrated security, 249
MIME type mapping, 54
monitoring tools, 508
MTA threading model, 188
namespaces, 13
.NET Framework, necessity of, 20
operating systems that support, 8
performance (see performance)
process model settings, configuring, 49
programming languages available for, 5
requirements for running, 37
and reusable components, 328
servers required for, 8, 28
stateless operation, 244
subroutines (see subroutines)
syntax, vs. ASP, 74
tags, 12-13
trace mode, disabling, 515
upgrading from ASP, 7
user controls (see user controls)
using ADO.NET with, 247
vs. ASP, 61, 511
WAS, 509
assemblies, 95, 328
compiled (see compiled assemblies)
controls, assigning tags to, 95
creating, 95
defined, 328
linking to, 96
locating, 96
source code (see source code assemblies)
using, 331
@ Assembly directive, 96-97, 331, 481
assignment operator, 161
Attributes collection, 112
authentication, 402-14, 417
AutoEventWireup attribute, 86
automatic type conversion, 514
AutoPostBack attribute, 129
B
BeginTransaction method, 285
binary data, storing, in database, 520
binding, 515
objects, to DataView object, 283
Bitmap object, 299
Bitmap.FromFile method, 298
blank databases, creating, 218
Boolean data type, 155
Boolean operands, 165
BoundColumn column type, 366
brackets, Like operator and, 163
browser capabilities component, configuring, 49
browsers, caching, controlling, 78
buffer, 76
Buffer property, 76
buffering Web pages, benefits of, 76
Button Web server control, 370
ButtonColumn column type, 366-67
C
caching
controlling, 78
setting length of, 91
calculating size of thumbnail pictures, 299-300
calculators, creating, 200
cascading list boxes, 337, 345-55
Case statements, 190
Catch statements, 197-99
change events, delayed, 148
ChangeExtension method, 292
changes to directory, handling, 312-14
ChildKeyConstraint property, 284
Choose function, 191
Class modules, 328
classes, 193
calling, 481-82
compiling, 331
defining, 195, 483
proxy (see proxy classes)
source files, 331
classes, ASP.NET, 13
Clear method, 76
client-side events, responding to, 149
ClientCertificate property, 74
clients, creating, for Web service, 486, 497-501
closing tags, 12, 13
code
readability of, 258
reusing, 327
code declaration blocks, 64-65, 333, 369, 393
code render blocks, 64, 66, 333
code tables, 215
code-behind classes, defining, 87
collections, 181
methods, 182
organized by hash code, 182
processing, 181
retrieving individually, 74
storing in variable-length list, 182
viewing contents of, 75
colors, specifying, with controls, 124
columns
adding to DataTable object, 307
data grid control, 366
Columns attribute, 130
COM, 290
components, call-intensive, 513
objects, 81, 188
Combine method, 292
command bubbling, 310
command line, compiling files from, 481
Command property, 280
CommandType property, 266
comments, 83
compilation errors with, 83
in Visual Basic .NET, 152
syntax, 83
tags, opening and closing, 83
Commit method, 285
comparison operators, 162
compilation errors, comments and, 83
compiled assemblies, calling classes from, 481
compilers
ASP.NET and, 61
setting options for ASP.NET pages, 13
specifying which to use, 87
components, HTML, 328
computer name, displaying, 400-401
concatenation operator, when to use, 164
configuration sections, in web.config file, 48
confirmation number, 440
Connection property, 280
connection strings, 248, 393-400
assembling, 249
retrieving, 451
connections, database, opening, 393
constants, 158-60
constructor methods, 155
containers, 148
Content-Type headers, 53
Contents collection, 392
ContentType property, 78
continuation character, 257
ControlCollection object, 97
@ Control directive, 93
controls
ActiveX (see ActiveX controls)
clearing ViewState information, 256
customizing (see user controls)
in assemblies, assigning tags to, 95
within user controls, 333
ControlToValidate attribute, 140
cookies, 404-5
Cookies property, 70, 74
Coordinated Universal Time, 167
CopyTo method, 181
CreateObject method, 81
CreateObjectFromClsid method, 82
CreateParameter method, 252
CSS, accessing properties with Web Forms, 113
customErrors setting, 50
mode settings, 51
D
DAO, 269
data
accessing with data reader, 263
binary, storing, in database, 520
caching, 517
displaying, in text boxes, 367
displaying, with data grid control, 365
inserting in drop-down list, 347-53
processing, for other computer, 479
retrieving, on Web, 363
session, storing, 517
sorting, in DataView object, 316
data binding expressions, 312
data entry, 363
data grid controls
columns, defining, 366
columns, types of, 366 (see also individual column type names)
data source, 373
displaying data with, 365
and nonstring values, 367
properties, 365
data readers, 263
creating, 373
data source, of data grid control, 373
data types 175-76
formatting, 368
matching, 267
variable, declaring, 515
data types, Visual Basic .NET, 153-59
DataAdapter object, 270
drawbacks of, 263
updating database with, 278
database connections, 347
database design, 211-18, 518-20
documenting table relationships, 224
numbers vs. text, 338
database-driven Web sites, 3, 4, 8
databases, 207, 218. See also Access; SQL Server
Access vs. SQL Server, 8
connections, opening, 393
copying onto Web servers, 20
datasheet view, 224
design, tuning, 518
entity attributes, repeating, 213
functions for accessing data, 209
indexes, advantages and disadvantages, 521-22
keys, choosing, 213
numeric values, delimiting, 239
records, displaying multiple, 125
relational, 208, 216
searching, 364
SQL view, 233
storing binary data in, 520
updating, with DataAdapter object, 278
usage, tuning, 518
DataBind method, 312, 366
DataGrid server control, 125, 264, 364
attributes, 374-75
customized, creating, 364
interactive queries, creating, 368-78
with custom formatting, 374-77
DataList control, 125, 264
DataReader object, 18, 252, 520
DataRelation object, 246, 271, 283
DataRow object, 272
DataSet object, 271, 273
drawbacks of, 263
similarity to database, 282
DataTable object, 246, 269-77
adding column to, 307
benefits of, 263
drawbacks of, 263
linking, 283
row, adding, 316
sorting, 283
DataTextField property, 350
DataValueField property, 350
DataView object, 246, 271, 282
binding objects to, 283
creating, 316
displaying, 314
sorting, 316
Date data type, 154
date formats, 368
dates
functions supported in Visual Basic .NET, 168-69
manipulating, 154, 167
DateTime method, 167-72
DBMSs, 208-9, 244, 284
Debug attribute, 87, 99
debug mode, disabling, 515
debugging information, in ASP.NET, 13
Decimal data type, 155
default ASP.NET programming language, setting, 13
Delete method, 272, 283
DELETE statement, 238
diagnostic information, appending to Web pages, 88
Dim command, 16
locating, 251
dimensions, array, number allowed, 175
directives, 85-86
directory changes, handling, 312-14
Directory class, 290-91
DirectoryInfo class, 290-91
Display attribute, 140
display constants, 160
DLLs, 481
DNS, 395, 399
Domain Name System. See DNS
drivers, OLE DB, 246, 248
drop-down lists
creating, 127, 129, 345-46
inserting data in, 347-53
values, reading, 353-55
DropDownList Web server control, 349-50
E
e As EventArgs argument, 15
e-mail
creating, in .NET Framework, 420
messages (see e-mail messages)
objects, .NET, 420
sending, 419, 426-29
early binding, 154, 515
EditColumn column type, 366-67
Empty value, 267
encryption keys, configuring, 49
End method, 80
equal sign, 161
equality comparisons, 167
Error event, 68
error handling, 197-98, 253
error messages, 488
ASP.NET pages, 22
comments and, 83
customizing, for ASP.NET applications, 49-50
detailed, creating, 87
ErrorMessage attribute, 140
event arguments, 148
event bubbling, 366
event handlers
activating, 366
arguments, 148
coding, 132, 377
creating, 318, 371-73, 411-14
for change events, 148
event handlers, ASP.NET, 15
event log messages, 524
event sources, 524
EventArgs object, 134
events, ASP.NET, 15
exception handling, 514
Exception object, 199
exceptions, 199
executable directories, 42-44
executable folders, 41-42
Execute method, 82
ExecuteNonQuery method, 250, 252, 263
ExecuteReader method, 251-52
ExecuteScalar method, 251-52, 274, 354
execution time, defined, 508
Expires property, 78
ExpiresAbsolute property, 78
Explicit attribute, 87, 99
exponentiation operator, 161
F
field AutoNumber, getting value of, 275-80
FieldCount property, 265
fields, 208, 220-22
AutoNumber, 269, 274
coding names, 239
identifying, 213
Identity, 268, 269
nonkey, 216
File class, 290, 291
file handling, Visual Basic, 290
file names, displaying, 319
file paths, fully qualified, 394-95
file system, accessing with Visual Basic .NET, 290
file uploads, 456-59
FileInfo class, 290-91
FileInfo object, 315
filename extensions
ASP vs. ASP.NET, 7
ASP.NET, 61
assigning interpreters to, 51
for databases, 218
files
compiling, from command line, 481
text, reading, 293
updating, 394
uploading, 456
web.config, 403
FileStream object, 293
Fill method, 263, 270
floating point division operator, 161
Flush method, 76
folder schemes, 403
folders, list of, generating, 305-309
footers, including, with SSI, 84
For Each command, 272
form field values of HTML server controls, retrieving, 114
Form object, 73
Form property, syntax, 73
format, date, 450
Format function, 387
FormatCurrency function, 387
formatting
custom, for DataGrid server control, 375-77
forms, 105
forms-based authentication, activating, 408-11
framesets, 343
FROM clause, 236
FrontPage Server Extensions, 36-37
FTP servers, installing with IIS, 36
fully qualified domain name, 394
Function methods, vs. Sub functions, 330
functions, 193-95
array, 178
string handling, 173
G
Get Ordinal() method, 265
Get procedure, 195
GetDirectoryName method, 292
GetExtension method, 292
GetFieldType() method, 265
GetFileName method, 292
GetFullPath method, 292
GetName() method, 265
GetPathRoot method, 292
GetTempFileName method, 292
GetTempPath method, 293
GetType operator, 166
GIF files, 301
GIFs, sending with ASP.NET pages, 54
globalization settings, 49
graphic text, displaying with ASP.NET, 301
Graphics object, 299
Greenwich Mean Time, 167
GROUP BY clause, 237
H
HasExtension method, 293
Hashtable object, 182, 514
HAVING clause, 237
header records, 53
headers
adding to Web pages, 79
including, with SSI, 84
headings, table, 388
home pages, creating, 400-401
HTML, 6
ASP.NET and, 11
code tags, 14
comments, 83
editor, choosing, 11
forms, 105
replacing special characters with, 82
separating from source code, 87
span tags, as generic controls, 113
user controls (see user controls)
HTML server controls, 107, 110-14
vs. user controls, 120
event arguments, 148
server-side vs. client-side, 149
for validation, 142
vs. Web server controls, 120
HTML tables
attributes, 374
creating, 309, 401
defining, 370
rule elements, 310
HTML tags, creating with ASP.NET, 5
HTMLcomponents, 328
HTMLEncode method, 82
HtmlForm controls, coding attributes, 109
HtmlInputFile object, 456-57
HTTP, 60
and Web services, 479
SOAP, 485
status codes, 78
HTTP root, 41
HyperLinkColumn column type, 366
properties, 367
I
id attribute, 112
identity, verifying. See authentication
If statements, 189-90
Iif function, 191
IIS, 28
Apache servers and, 33
applications, 46
applications, creating, 46
applications, dividing up, 46
checking if installed, 32-33
configuration, checking, 32
FrontPage Server Extensions, installing, 36
FTP server, installing, 36
installing, 34
newsgroups, installing, 36
NNTP Service, installing, 36
SMTP Service, installing, 36
subcomponents, 35
versions of, 28
Web server, starting, 33
World Wide Web Server, installing, 37
ImageButton control, 311
images. See pictures
@ Implements directive, 94
Import command, 247
@ Import directive, 88-89
indexes, 521-22
Indexing Service, 34
information. See data
session (see session information)
temporary, saving, 391-92, 396
Inherits attribute, 87
Init event, 15
relative usefulness of, 68
InnerHTML property, 113
InnerText property, 113
input validation, 518
INSERT statement, 238
InStrRev function, 313
Integer data type, 155
integrated security, drawbacks of, 249
interactive queries, DataGrid, creating, 368-78
intermediate code, 29
Internet Services Manager, 32, 398
installing, 36
opening, 42
interpreters, assigning to filename extensions, 51
intranets, 396
logging on to, 402
IP addresses, resolving, 395
IsPathRooted method, 293
IsPostBack property, 71
IsValid property, 71
Item property, 283
ItemCommand event, 149
J
join operations, 209, 215
for code tables, 215
keys, naming, 215
result set, 210, 211
syntax, in Oracle, 237
JOIN types, 236
L
Label control, 123-24
Language attribute, 64, 87, 99
late binding, 154, 515
preventing, 88
Length property of arrays, why to avoid, 179
Let statement, replacement for, 162
Like operator, 162-63
links, adding, to Web page, 475
list boxes, cascading. See cascading list boxes
lists, sorting, 317-18
Literal control, 123-24
Literal Web server control, 387
literals, 157-59
Load event, 15, 68
Location attribute, 91
logic statements, coding, 189
logical functions, 190
logical operators, 164-65
logon pages, creating, 409
Long data type, 155
loops, 192, 193
tuning, 512
M
MachineName property, 80
MapPath method, 69
MaxLength attribute, 130
MDAC, 30, 39
memory allocation, for arrays, 175
Message Authentication Code, 404
methods
calling, in ASP.NET, 480
DateTime public instance, 172
DateTime public static, 170
exposing, with user controls, 335-36
metrics, performance, 508
Microsoft Access
vs. SQL Server, 8
Microsoft CLR Debugger, 524-25
Microsoft Personal Web Server, 29
Microsoft Web servers, 32
starting, 33
MIME types, 53-54
modules
private, 329
public, 328
monitoring tools, ASP.NET, 508
MTA threading model, 188
multiple servers, transactions on, 286
multiple transactions, coordinating, 286
N
Name attribute, specifying, in @ Assembly directive, 97
name=value parameters, 248
namespaces, 89
ASP.NET, 13
automatically imported, 89
identifiers, assigning to assembly controls, 95
importing, 89, 481, 490
importing multiple, 89
System.IO (see System.IO namespace)
NAT, 396
natural keys, 213
.NET
objects, instantiating, 82
resource management, 245
.NET Framework, 29, 31
creating e-mail messages, 420
creating proxy class, 487
downloading, 29
e-mail objects, 420
installing, 37
legacy support, 31
operating system support, 29
SDK, setting up, 39
vbc program, 331
Network Address Translation. See NAT
NewRow method, 272
newsgroups, installing, with IIS, 36
nonkey fields, 216
normal forms, 216-17
Not operand, 165
NTFS, 55
Null value, 468
numeric formatting codes, 367
O
Object data type, 155
arrays and, 175
objects
accessing, 187
binding to DataView object, 283
command, troubleshooting, 252
default properties, lack of, 187
e-mail, .NET, 420
OLE DB, 246
SQL, 246
objects, ADO.NET
DataReader, 18
DataReader, working with, 18
objects, ASP.NET, OleDbCommand, 17
obtaining trace report, 510
OLE DB, 13
drivers, 246, 248
objects, 246
OleDbCommand objects, 245-51, 263, 349
creating, 17, 373
OleDbCommandBuilder object, 273
OleDbConnection object, 245-48, 266
OleDbDataAdapter object, 246, 263, 271
OleDbDataReader object, 245, 263, 264
OnSelectedIndexChanged attribute, 129
OnServerClick attribute, 112
onServerClick attribute, 62
OnTextChanged attribute, 130
opening database connections, 347, 393
operand data type, 161
operands, 165
operating systems, supporting ASP.NET, 8
Operator attribute, 140
operators, 160-65
Option Explicit mode, 154
turning on, 87
Oracle, join syntax, 237
ORDER BY clause, 238
OrElse operator, 166
@ OutputCache directive, 91
P
page banner user control
creating, 337-43
displaying, 340-43
functionality, 360
testing, 358-60
@ Page directive, 86
Page object, 67-71
page output caching, 517
Page.IsPostBack property, 256, 516
Page_Init event handler, 15
Page_Load event handler, 15
Page_PreRender event handler, 15
Page_Unload event handler, 15
parameter directions, 268
parameter queries, 229-30
parameters, 248, 267-68
Params property, 74
parentheses, in subroutines, 194
ParentKeyConstraint property, 284
Partition function, 191
passwords, 413
Path class, 291
coding, 291
methods, 292
operating system compatibility, 291
Path object, 296
patterns, comparing to strings, 162
performance
application, measuring, 508
ASP.NET, tuning, 511
metrics, 508
performance counters, displaying, 509
permissions, delimiting, 406
photographs, displaying on Web, 294
Picture Gallery application, 295-96
customizing, 320
thumbnail page, 304-305
picture uploads
creating Web page for, 459-72
saving, 460, 468-72
verifying, 468-72
picture.aspx page
testing, 302
pictures
displaying, 314
loading, 458
thumbnail, calculating size of, 299, 300
thumbnail, creating list of, 314-16
thumbnail, displaying, 297-301, 318-19
thumbnail, generating, 302
uploading, 460 (see also picture uploads)
plus operator, 164
postbacks, 126
counting, 138
forcing immediate, 148
validation, forcing, 144
PreRender event, 15, 68
primary key index, 522
primary keys, 212-14, 275
fields, selecting for, 221
print constants, 160
program code
loops, tuning, 512
tuning, 511
program objects, creating, with ASP.NET, 5
project operation, 209
properties
of uploaded files, 457-58
user control, setting, 334-35
property procedures, 329-30
proxy classes, 487-88, 496
pseudo-random numbers, 258
Q
queries, 227-229
answering, for other computer, 479
current records, 368
interactive (see interactive queries)
optimizing, 519-20
query pages (see query pages)
real-time operation, 244
results, sorting, 364, 368, 373
query pages, 378-88
QueryString object, 73-74
Queue object, 182
quotation marks, in string literals, 159
R
radio buttons, attributes, coding, 115
random numbers, 258
Randomize function, 258
ranks, array, 175
RDO, 269
Read method, 265
ReadOnly property, coding, 195
records, 208
adding to DataTable object, 277
adding, to members table, 422
adding to tables, 253, 255-56, 258-60
changing, 224
creating, 223
deleting, 224
managing, 263
modifying, with DataSet object, 273
retrieving from data reader, 387
saving, 223
selecting, specifying criteria for, 237
Recordset object, 269-70
recursive subroutine/function calls, 195
ReDim command, 176, 513
Redirect method, 80
@ Reference directive, 97
referential integrity, enforcing, 226
@ Register directive, 95-97
registering Web visitors, 444
registration
confirming, 437-41
page (see registration page)
registration page
adding validation controls to, 430-32, 436
Web visitor, creating, 423-25
relational model, 216
Remove method, 272
Repeater object, 125, 264, 367
coding, 309-12
creating, 318-19
Request object, 72, 395
requests
receiving, 479
submitting, to Web service, 484
ResolveUrl method, 69
Response object, 76-79
response time, defined, 508
Response.Write method, 513
result set, 210-11
results
query, sorting, 364, 368, 373
returning (see queries)
Return statements, coding with expressions, 194
reusable components, ASP.NET, 328
reusing code, 327
Rnd function, 480
Rnd() function, 258
Rollback method, 285
round trips, 126
avoiding, 518
Row property, 280
RowFilter property, 282
rows, adding to DataTable object, 316
RowUpdated event, 279
rule elements, 310
rules for creating user controls, 336
runat="server" attribute, 61, 110, 516
running queries, 228
runtime, 29
S
scalability, defined, 508
Script Debugger, 35
Scripting.Dictionary object, 181-82
Scripting.FileSystemObject, 290
ScriptTimeout property, 81
SDK, setting up, 39
search engines, for Web services, 504
security
Access databases and, 56
of Access databases, 250
virtual directory vs. NTFS, 55
Web page, 463-72
Web page, managing, 55
Web service, 489
select operation, 209
SELECT statement, 234-35
self-registration. See registration
Send method, 421
sender As Object argument, 15
server controls
events supported, 147
form field identification, 115
server farms, 397
Server object, 80-82
server-side code, 3
server-side events, responding to, 149
server-side includes (SSIs), 327
server-side programs, 456
Server.MapPath method, 249
servers, multiple, transactions on, 286
ServerVariables property, 74-75
service descriptions, 483
session data, 517
session information, 397
Session object, 391-97
session state, 517
Session variable, 395
Set statement, 196
Short data type, 155
Show Table dialog box, 225
Simple Object Access Protocol. See SOAP
size of thumbnail pictures, calculating, 299-300
SMTP, 429
SMTP Service, installing, with IIS, 36
SOAP, 485
sort order, 371
Sort property, 282
SortedList object, 182
source code
assemblies (see source code assemblies)
compilers, specifying which to use, 87
loading, in ASP.NET, 65
separating from HTML code, 87
source code assemblies, 480
span tags
as generic controls, 113
Label control and, 124
special characters, replacing with HTML equivalent, 82
spreadsheets, pasting data into tables from, 224
SQL, 7, 233
ADO.NET and, 7
commands, 234
dialects, 241
INSERT statements, 260, 268
keywords, capitalizing, 234
LEFT JOIN operator, 386
objects, speed of, 246
pronouncing, 229
SELECT statements, 263
statements, 234, 239-40, 250, 266
SQL Server, 519
Identity fields, 268-269
installing, 37
stored procedures, 268
vs. Access, 8
SqlCommand object, 245, 263, 266
common properties of, 251
properties, 250
SqlConnection object, 245
parameters, 248
SqlDataAdapter object, 246, 263
SqlDataReader object, 245, 263, 264
Src attribute, 65, 87
specifying, in @ Assembly directive, 97
SSIs, 84-85
STA threads, executing pages on, 86
Stack object, 182
Start menu, 31
stateless operation, 244
static Web pages, 4
status codes, 78
Status property, 78
stored procedures, 251, 266-67, 520
stored queries, 520
Strict attribute, 88
Strict mode, 88
String data type, 154
string keys, 182
string literals, quotation marks in, 159
strings
comparing to patterns, 162
concatenating, 162, 164, 513
handling, 173
handling functions, 173
StringWriter objects, 82
structure declarations, 156
Structure End Structure statements, 156
Structure statements, 156
structured exception handling, 197
structures, 156
Styles collection, 113
Sub functions, 330
submitting request, to Web service, 484
subroutines, 61, 193
calling, 194
calling recursively, 195
creating, 15
default reception of, 194
defining, 67
for Page object events, 67
initializing code in, 132
parentheses in, 194
running when text changes, 130
wiring buttons to, 62
Switch function, 192
System.Array object
methods, 181
object, 181
properties, 179
public static, 178
System.Data namespace, 13
System.Data.OleDb namespace, 13
System.IO namespace, 290
T
table names, 386
tables, 208
adding data to, 223
adding records to, 253, 255-56, 258-60
attributes, adding, 213
code, 215
combined view, 209
creating, by entering data, 219
creating, for application entities, 212
creating, in design view, 219
creating, with wizard, 219
definition, displaying, 453
eliminating redundancy, 217
field size property, 221
headings, 388
linking, 283
naming, 212
pasting spreadsheet data into, 224
populating, 223
property settings, 221
relationships, 215, 224-26
saving, 222
viewing specific fields only, 209
tags, form, 107
TemplateColumn column type, 366-67
temporary information, saving, 391-92, 396
test pages, viewing, 486
text box controls, 143
text boxes
displaying data in, 367
setting width of, 130
text files, reading, 293
TextBox control, 130
TextReader object, 293
TextWriter object, 293
third-party Web servers, IIS and, 33
threading model, 188
throughput, defined, 508
thumbnail pictures
creating list of, 314-16
displaying, 297-301, 318-19
generating, 302
size of, calculating, 299-300
times, Coordinated Universal Time vs. Greenwich Mean Time, 167
ToLocalTime method, 173
tools, monitoring, ASP.NET, 508
ToString method, 367
ToUniversalTime method, 173
Trace attribute, 88-99
Trace feature, ASP.NET, 509
trace messages, viewing, 523
trace mode, disabling, 515
Trace property, 71
trace report, obtaining, 510
tracking postbacks, number of, 138
Transact-SQL, 520
Transaction property, 285
transactions 284-86
Transfer method, 82
translating. See resolving
Try...Catch...End Try blocks, 253, 274, 514
txtYear control, validating, 144
type conversion, automatic, 514
types, deriving information on, 166
U
Ubound function, 177
unique sort fields, 373
Unload event, 15, 68
Update method, 273-74
UPDATE statement, 239-40
uploading. See file uploads
URLEncode method, 82
URLs
application root, 341
converting arguments into, 82
fully qualified, 394
redirecting, 80
resolving, 394
usage
ASP.NET, tuning, 515
database, tuning, 518
user controls, 93, 95, 107, 120, 328, 332
caching, setting length of, 91
cascading list box, creating, 345-55
containing other controls, 333
creating, 332-33, 337-43
described, 332
displaying, 339, 340
displaying page banner with, 340-43
exposing methods with, 335-36
vs. HTML server controls, 120
implementing, 93-94
linking pages to, 97
multiple copies, 333
multiple times in same page, 93
page banner (see page banner user control)
with program code, 332
properties, setting, 334-35
@ Register directive and, 94
rules for creating, 336
source file, identifying, 94
transferring data, 333
and Web pages, 334
vs. Web server controls, 120
User property, 71
user-defined types, 155
usernames, displaying, 417
V
validation input, 518
validation controls, adding to registration page, 430-32, 436
Validation Server Controls, 71
validation server controls, 108
coding, 139
implementing, 140
testing, 140
types of, 141
ValidationSummary control, 141
values
adding, to Application object, 393
drop-down list, reading, 353-55
retrieving, 330
storing, 329
VarChar data type, 267
variables
data type, declaring, 515
declaring, 153-54
multiple, pointing to same object, 162
Variant data type, 267
VaryByCustom attribute, 92
VaryByHeader attribute, 92
VaryByParam attribute, 92
vbc program, 331
VBScript, 4
limitations of, 4
ViewState, 108, 137
disabling, for control, 516
saving, 516
server controls, 516
ViewState information
clearing, 256
transmitting, 391
ViewState property, 71, 343, 391
virtual directories, 41
executable, creating, 42-43
security options, 44
security, vs. NTFS security, 55
visitors, identifying. See authentication
Visual Basic
ampersand operator, 16
code, for entering data into DataGrid with, 14
continuing lines, 16
file handling, 290
Option Explicit mode, turning on, 87
script tags, 14
Strict mode, turning on, 88
strings, joining, 16
subroutines, creating, 15
underscore operator, 16
vs. Visual Basic .NET, 16, 151
Visual Basic .NET, 5-6, 151, 290
access modifiers, 196
accessing file system with, 290
built-in constants, 160
comments, 152
date functions, 169
date functions no longer supported, 168
dates, 167
dates, manipulating, 154
declaring variables, 153-54
Dim statements, 16
display constants, 160
literals, 157
logical functions in, 191
namespaces, 290
Option Explicit mode, 154
print constants, 160
redimensioning arrays, 513
Set commands, lack of support for, 188
type conversion functions, 157
variables, declaring, 16
variants, lack of support for, 16
vs. Visual Basic, 16, 151
Visual Basic .NET statements, 152
Visual InterDev
FrontPage Server Extensions and, 37
installing, 37
Visual Studio .NET, installing, 38
W
WAS, 509
Web
displaying photographs on, 294
retrieving data on, 363
Web Application Stress tool. See WAS
Web browsers, file upload support, 456
Web Forms, 107
change events, delayed, 148
creating, 108, 128
CSS properties, accessing, 113
data records, displaying multiple, 125
default form method, 109
defining, 370
drop-down lists, 127, 129
event arguments, 148
event bubbling, 148
event handlers, 125
event handlers, coding, 132
events, responding to, 125
field values, retrieving with HTML server controls, 114
form elements, naming, 115
form fields, 115
form tag, 107-8
HTML server controls and, 107, 112
HTML server controls, retrieving form fields with, 114
linking pages to, 97
loading fresh copies of, 133
maximum number of characters, specifying, 130
method, default, 109
multiple, on same page, 109
performance, 147
postbacks, 126
postbacks, counting, 138
postbacks, forcing immediate, 148
postbacks, forcing validation on, 144
radio buttons, coding attributes of, 115
rendering, 155, 125
round trips, 126
text boxes, setting width of, 130
validation, automatic, 141
Web server controls and, 107
year, validating, 142
Web pages
adding link to, 475
and user controls, 334
appending diagnostic information to, 88
as calculators, 200
ASP.NET, creating, 9-19
ASP.NET, errors displaying, 22
ASP.NET, saving, 19
ASP.NET, testing, 21
buffering, benefits of, 76
caching, setting length of, 91
creating, with Web server controls, 128
debugging interactively, 525
executing on STA threads, 86
for picture upload, URL, 460
forms, 105
header information, adding, 79
linking to custom server controls, 97
linking to Web Forms, 97
locking, 392
on database-driven Web sites, 4
picture upload, creating, 459-72
redirecting, 80
requesting, 395
running length, configuring, 81
security, 463-72
security, managing, 55
stopping execution of, 82
testing, 523
tracing, with ASP.NET, 75
tuning, 478
Web presence providers, finding suitable, 57
@ WebService directive, 482
Web server controls, 107, 121
change events, delayed, 148
child controls, 148
coding, 120
colors, specifying, 124
creating Web pages with, 128
drop-down lists, 129
event arguments, 148
event bubbling, 148
for validation, 142
vs. custom server controls, 120
vs. HTML server controls, 120
Web Forms and, 107
Web servers
Apache, and IIS, 33
applications, benefits of dividing into, 46
applications, creating, 45
configuring, 41
copying ASP.NET pages onto, 20
displaying name of computer running on, 80
flagging folders as executable, 8
supporting ASP.NET, 8
third-party, and IIS, 33
user accounts, anonymous, 55
Web Service Description Language (WSDL), 487
Web services, 479
access to, 480
calling classes as, 482
creating, 482, 490-94
creating client for, 486, 497-501
described, 479
describing, with XML, 486
finding, 504
HTTP, 479
importing namespaces, 490
security, 489
service descriptions, 483
submitting request to, 484
testing, 483
Web visitors
creating registration page for, 423-25
logging in, 444
registering, 444
web.config file, 47-48, 403
WebControls, 12
WHERE clause, 237
white space, in Visual Basic .NET statements, 152
Windows components, adding/removing, 34
Windows XP Professional Start menu, customizing, 31
World Wide Web Server, installing, with IIS, 37
WPPs, finding suitable, 57
Write method, 80
WriteOnly property, coding, 195
X
XML, 404
describing Web service with, 486
XML files, 47
Y
years, validating, 142
Last Updated: April 7, 2002
|
