S

Index
byJohn Kauffman, Fabio Claudio Ferracchiatiet al.?
Wrox Press ?2002

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



Beginning ASP. NET 2.0 and Databases
Beginning ASP.NET 2.0 and Databases (Wrox Beginning Guides)
ISBN: 0471781347
EAN: 2147483647
Year: 2004
Pages: 263

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net