|
|
S (Shared) locking mode, 501
Save method
in SqlTransaction, 486, 488
in XmlDocument, 603-604
Save Query dialog box, 62
SAVE TRANSACTION statement, 486-487
Savepoint.cs program, 489-492
Savepoint.sql script, 487-488, 489
savepoints
SqlTransaction objects for, 488-492
T-SQL for, 486-488, 489
saving
passwords, 202
statements, 62
tables, 52, 52
sbyte type, 269
scalar user-defined functions, 119-121, 121
Scale field, 52
Schema Editor, 450, 451
Schema modification (Sch-M) locking mode, 502
schema relationships, 450-452, 451-452
Schema stability (Sch-S) locking mode, 502
SchemaOnly value, 215, 217-223
SchemaOnlyCommandBehavior.cs program, 220-223
schemas, 30
SchemaType enumeration, 362
SCOPE_IDENTITY function, 385
SDK (Software Development Kit)
for documentation, 23-25, 24-25
installing, 4
Search Online link, 18
Search Results window, 25, 25
Search tab, 25
Search window, 25
searching
for DataRow objects, 367-368
for DataRowView object indexes, 463
for DataRowView objects, 464-466
in documentation, 25
Security folder, 32
security functions, 107
Security tab, 587, 588
Select method, 347
SELECT permission, 38
SELECT statement, 61-62
AS clause, 78-79, 78
BETWEEN operator, 69
with browsers, 590-591, 591
calculated fields in, 79
DISTINCT keyword, 74-75, 75
ExecuteReader with, 212-223
ExecuteScalar with, 225-226
ExecuteXMLReader with, 227-229
FROM clause, 63-64, 63
GROUP BY clause, 76-77, 77
HAVING clause, 77, 78
IN operator, 68-69, 69
IS NULL operator, 70, 70
JOIN operator, 79-81, 80
LIKE operator, 65-68, 66-68
logical operators in, 71-72, 71-72
multiple, 282-288
NOT operator, 70
ORDER BY clause, 72-73, 73-74
for populating objects, 302-306
running, 8
storing rows locally with, 144-151
TOP keyword, 74, 75
UNION operator, 76, 76
views in, 81-82
WHERE clause, 64-65, 64
for XML, 567-568
SelectCommand property
in DataAdapter, 398
in SqlDataAdapter, 146, 168, 168, 296, 339
Selected property
for DropDownList controls, 529
for RadioButtonList controls, 529
SelectIntoDataSet.cs program, 148-149
SelectNodes method, 603-604
SelectSingleNode method, 603-604, 607
semicolons (;) for multiple statements, 312
SequentialAccess value, 215
SERIALIZABLE isolation level, 492-494
serializable transactions, blocking, 506-509
Serializable value,i493
server element in connection strings, 7
Server Explorer, 91-92
servers, Web state information on, 556-559
ServerVersion property, 188
Service Manager tool, 30-31, 31
services, Web, 613
creating, 613-617, 614
registering, 626-630, 627-631
testing, 621-622, 622-623
using, 624-626, 624-626
VS.NET for, 17
WSDL files for, 617-621, 618
Session objects, 556-558
SessionObjectTest.aspx file, 557-558
SET DEADLOCK_PRIORITY statement, 510, 514
SET LOCK_TIMEOUT statement, 505
SET NOCOUNT ON statement, 129, 389-390
SET TRANSACTION ISOLATION LEVEL statement, 493-494
SetContactNameNull method, 414
SetDefault value, 439
SetNull method in DataRow, 349
SetNull value in Rule, 439
SetParentRow method, 349
Settings tab, 589, 589
setup.exe file, 4
SetupCustomersDA method, 431
Shared (S) locking mode, 501
Shared with intent exclusive (SIX) locking mode, 502
shopping cart application, 560, 560
Buy button in, 560-562, 561-562
code for, 563-565
shopping cart in, 563, 563
short type, 269-270
Show Diagram option, 92
Show Navigation Buttons property, 538
Show SQL Pane option, 92
SIGN function, 111
SIN function, 112
single-line comments, 97
Single type, 268
SingleResult value, 215
SingleRow command behavior, 215-217
SingleRowCommandBehavior.cs program, 215-217
SIX (Shared with intent exclusive) locking mode, 502
slashes (/)
for comments, 97
in URLs, 591
in XPath expressions, 580-581
smalldatetime type in SQL Server, 43, 270
SmallDateTime value in SqlDbType, 241
smallint type in SQL Server, 43, 270
SmallInt value in SqlDbType, 241
smallmoney type, 43, 270
SmallMoney value in SqlDbType, 242
software, obtaining, 4
Software Development Kit (SDK)
for documentation, 23-25, 24-25
installing, 4
Solution Explorer
for Web services, 624, 625
for Windows applications, 163-164, 163
Sort Expression field, 537
Sort property, 454, 460, 463-464, 476
sorting
DataRow objects, 368-373
DataView objects, 460
in retrieving rows, 72-73, 73-74
SOUNDEX function, 114
Source value in SchemaType, 362
sp_xml_preparedocument procedure, 597
sp_xml_removedocument procedure, 597
SPACE function, 114
spaces in names, 64
special characters in URLs, 591
SQL (Structured Query Language), 3, 59-60
automatic generation of statements in, 398-399
data manipulation language statements in, 62
multiple statement execution in, 282-288
Query Analyzer for. See Query Analyzer
Transact-SQL. See Transact-SQL (T-SQL)
SQL Server, 29
documentation in, 26, 27
Enterprise Manager for. See Enterprise Manager
managed provider classes in, 138
SqlConnection connections for, 189-190
connection pooling with, 192-195
connection state with, 195-196
events for, 196-200
opening and closing, 190-192
VS.NET for, 200-204, 200-205
starting and stopping, 30-31, 31
stored procedures in, 35, 35, 245-255
for transaction locks. See locks for transactions types in, 42-44
for updates and deletes, 438, 439
for XML. See XML
SQL Server Login dialog box, 175, 175
sql_variant type, 44, 270
SqlBinary type, 276
SqlBoolean type, 276
SqlByte type, 276
SqlClient namespace, 141
SqlCommand objects, 139
closing, 9
CreateCommand for, 211
creating, 8, 146, 209-211, 255-256, 257
properties and methods in, 207-209
SqlCommandBuilder class, 140, 398
SqlConnection objects, 139, 187-189
creating, 7-8, 145
for forms, 166-167, 167
opening, 8
SQL Server database connections with, 189-190
connection pooling with, 192-195
connection state with, 195-196
events for, 196-200
opening and closing, 190-192
VS.NET for, 200-204, 200-205
SqlDataAdapter objects, 140, 146
creating, 297-298
for forms, 166-167, 167
properties and methods for, 294-297
SqlDataReader objects, 140
closing, 9
creating, 262-263
displaying column values from, 9
properties and methods for, 259-262
reading rows from, 263-266
SqlDateTime type, 276
SqlDbType enumeration, 241
SqlDecimal type, 276
SqlDouble type, 276
SqlException class, 7, 9-10
SqlGuid type, 276
SqlInt16 type, 276
SqlInt32 type, 276
SqlInt64 type, 276
SqlMoney type, 276
SqlParameter class, 140
SqlParameterCollection class, 140
SqlRowUpdatedEventArgs class, 403
SqlRowUpdatingEventArgs class, 401-402
SqlSingle type, 276
SqlString type, 276
SqlTransaction objects, 140, 236
creating, 237
properties and methods for, 486
for savepoints, 488-492
for transaction isolation levels, 496-500
SqlTypes namespace, 262
SQRT function, 112-113
square brackets ([])
in pattern matching, 65
in table names, 64
in XPath expressions, 581
SQUARE function, 112-113
StackTrace property, 10
Start page in VS.NET, 17, 18
Start Page tab, 626
Start without Debugging option, 23, 157, 158, 171, 182
state information for Web applications
on client, 552-556, 554
on server, 556-559
state of Connection object, 195-196
State property
in Connection, 195
in SqlConnection, 188
StateBag object, 554
StateChange.cs program, 197-198
StateChange event
coding, 203-204, 203-205
in SqlConnection, 189
working with, 196-198
StateChangeHandler method, 196
statements
entering and running, 60-62, 61
grouping, 87-89, 88
saving and loading, 62
StatementType property, 402
Status column for transaction locks, 503
Status property, 402
STDEV function, 108
STDEVP function, 108
stored procedures, 124-125, 386
with browsers, 592-593, 592-593
creating, 125-126, 126, 387-390
DataAdapter objects for, 390-392
for DataRow objects, 393-397
for populating objects, 309-311
result sets with
not returning, 245-252
returning, 252-255
with RETURN, 102
running, 127
in SQL Server, 35, 35, 245-255
triggers in, 127-128
DeleteProductTrigger, 133-134
InsertProductTrigger, 129-131, 130
UpdateUnitPriceProductTrigger, 131-133
Stored Procedures node, 126
StoredProcedure value, 210
storing data
DataSet objects for. See DataSet objects
locally, 144-151
SqlDataAdapter objects for, 294-298
STR function, 114-115
Strikeout property, 538
string functions, 113-116
string type, 269-270
strongly typed column values, 266-268
DataSet objects for
modifying data, 413-415
reading data, 332-337, 333-335, 337
Get* methods for, 268-275, 272
GetSql* methods for, 276-281
StronglyTypedColumnValues.cs program, 273-275
StronglyTypedColumnValueSql.cs program, 279-281
StronglyTypedDataSet directory, 332
StronglyTypedDataSet2 directory, 414
Structured Query Language (SQL), 3, 59-60
automatic generation of statements in, 398-399
data manipulation language statements in, 62
multiple statement execution in, 282-288
Query Analyzer for. See Query Analyzer
Transact-SQL. See Transact-SQL (T-SQL)
STUFF function, 114, 116
stylesheets, 594-596, 596
subqueries, 69
SUBSTRING function, 114, 116
SUM function, 108, 110
Support Services folder, 32
System namespace, 7
System.Data namespace, 143
System.Data.DataSet class, 138
System.Data.Odbc namespace, 141
System.Data.OleDb namespace, 12-13, 141
System.Data.SqlClient namespace, 141
System.Data.SqlTypes namespace, 262
System.EventArgs class, 400
system functions, 117-119
system statistical functions, 107
System.Windows.Forms namespace, 161
|
|