SA account, 316
sample code, 4
scalability, 22
schema elements, XSDL, 152
schemas, databases, 86-91
schemas, XML, 150-52
SDK, .NET Framework, 27
second normal form (see 2NF)
security, 313-17 query strings, 314-16 SA account, 316 SQL stored procedures, 260-61
SELECT statements, SQL, 261 FROM clauses, 47 WHERE clauses, 172-73
SelectCommand property, ADO.NET data adapter objects, 239
SelectedDate property, Calendar controls, 184
SelectedDates property, Calendar controls, 184
SelectedIndex property, ListBox controls, 187
SelectedIndexChanged event, CheckBoxList controls, 121
SelectedItem property, ListBox controls, 107
SelectionMode property, ListBox controls, 112
sequence elements, XSD, 152
server controls (see controls)
ServerVariables property, HttpRequest class, 443
SET clauses, SQL UPDATE statements, 50
SET statements, SQL, 271
ShippingCharge class (example), 327
ShippingChargeCalculator class (example), 338-39
sites (see web sites)
Solution Explorer, Visual Studio .NET, 393-94
Sort method, ArrayList class, 329
Sort property, ADO.NET DataView class, 177-78
SortedList class, 350
SortExpression property, DataGridSortCommandEventArgs class, 179
SourceVersion property, ADO.NET parameter objects, 239
Split method, String class, 328-29
spreadsheets (see also 14
SQL, 39-40 aliasing, 128 DDL (Data Definition Language), 43 DML (Data Manipulation Language), 43 multiple users, 317 stored procedures, 356 parameters, 270-77 transactions, 300-304 variables, 270-72 global variables, 270
SQL Server, 26-27 .NET data provider, 63-70 Access vs SQL Server, 55-56 connection pooling, 363-67 TDS (Tabular Data Stream), 62
SqlCommand class, ADO.NET (see also 238
SqlCommandBuilder class, ADO.NET (see also 378-79
SqlConnection class, ADO.NET (see also 79-81
SqlDataAdapter class, ADO.NET (see also 378-79
SqlDataReader class (see also 413
SqlDbType enumeration, ADO.NET, 275
SqlException class, ADO.NET, 294-97 properties, 295
SqlParameter class, ADO.NET (see also 277
State property, ADO.NET SqlException class, 295
stateless applications, 24
stored procedures, SQL, 356 ALTER PROCEDURE statements, 269 atomicity, 260 CREATE PROCEDURE statements, 269 DROP PROCEDURE statements, 269 EXECUTE statements, 264 modularization, 261 parameters, 270-77 output parameters, 277-83 security, 260-61 transaction scope, 260
String class Split method, 328-29 ToUpper method, 330
support from Wrox, 5
sustainabillty, 323
system catalogs, 41
system tables, 41
System.Data namespace, 63
System.Data.ODBC namespace, 63
System.Data.OleDb namespace, 63
System.Data.SqlClient namespace, 63
System.Diagnostics namespace, 373 |