Index_S

S

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




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

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