Index_S

S

sample code

downloading, 5

scope, 142

example using an array, 180

where to declare variables, 140

security

cookies, 470

debugging at deployment, 203

Forms based security, 440

IIS, 529

Login Page, 444

Logout Page, 448

Passport based security, 440

security (continued)

validation controls, 83

web.config file, 441

Windows based security, 440

Security template, 24

Select Case statement

example using, 109

If...ElseIf statement alternative, 108

SELECT Data Method code builder

data binding with list controls, 329

displaying data in DataGrid control, 305

displaying selected rows, 318

passing data between pages, 363

selecting rows based on search string, 312

SELECT Data Method wizard, 305

SELECT statement, 253

* (asterisk) symbol, 253, 255

building a rowset, 302

column selection, 255

SqlDataSourceControl control, 269

which tables to execute against, 255

SelectCommand property, SqlDataSourceControl control, 267, 268, 269

SelectedIndex property, MxDataGrid control, 295

SelectedItemStyle property, MxDataGrid control, 296

SelectedItemTemplate type

templated column, list control, 285

selecting multiple items, 40

SelectionChanged event handler

Calendar control, 107

self target attribute, 355

semantic errors, 200

example using variables, 139

sender As Object

Button_Click event parameter, 130

SendMail function

sending an e-mail example, 123

Server object

HtmlEncode method, 154, 155

URLEncode method, 366

server side events, 90

server side processing, 57

how the web works, 56

statelessness, 88

understanding order of events, 88

servers

see web servers.

Server-side sessions

cookies, 475

Session object

properties and methods, 478

session state, 477

Session_End event, 477

Session_Start event, 477

sessions

Server-side sessions, 475

<sessionState> tag, 475

Set method, application state, 479

signature, 121

SignOut method, FormsAuthentication class

Logout Page, 449

Simple Stored Procedure type

Data Pages template, 257

SingleLine value, Rows property, 65

slash (/) character

referencing paths, 348

SmallDateTime data type, 242

SmallInt data type, 241

SmallMoney data type, 242

SMTP (Simple Mail Transfer Protocol)

function sending e-mail example, 122

IP address, SMTP server, 124

Snake Eyes game

using reusable content, 392

SOAP (Simple Object Access Protocol), 492

sort property

KeywordRequest class, 494

SortedList class/objects

System.Collections namespace, 194

SortedList collection

hashtables, 193

SortExpression property, MxDataGridField Collection Editor dialog, 277

source control

limitations of Web Matrix, 508

Split method, String data type, 149

SQL online tutorials, 255

SQL Server

database server software, 515

deploying databases, 519

Enterprise Manager, 271

SQL statements

see also clauses.

CREATE PROCEDURE, 259

INSERT, 248, 255

Preview window, 314

ReDim, 183

SELECT, 253

UPDATE, 255

working with database, 231

SqlClient namespace

see System.Data.SqlClient namespace.

SqlCommand object

see Command classes/objects.

SqlConnection object

see Connection classes/objects.

sqlConnectionString attribute, <sessionState> tag

cookies and state, 476

SqlDataAdapter object

see DataAdapter classes/objects.

SqlDataReader object

see DataReader classes/objects.

SqlDataSourceControl control, 264

addition to standard .NET controls, 299

AutoGenerate properties, 269

AutoGenerateUpdateCommand property, 268

automatic addition in design view, 233

command properties, 269

ConnectionString property, 268

DataAdapter class/object, 300, 304

relationship, 268

DataSet class, 300

DeleteCommand property, 269

HTML created, example, 282

MxDataGrid control property linking, 272

Properties window, 265, 267

SelectCommand property, 267, 268, 269

UpdateCommand property, 268, 269, 293

SqlException exception type, 209

src property, Image control, 347

SSL (Secure Socket Layer), 372

web server software, 513

Start Web Application dialog, 44

state

application state, 478

cookies, 475

session state, 477

stateConnectionString attribute, <sessionState> tag

cookies and state, 476

statelessness

cookies, 469

server side processing, 88

statements

see SQL statements.

stepping through code

run time debugging, 217

step-wise refinement of code, 130

stored procedures, 256

Create Stored Procedure dialog, 256

creating, 256

executing, 256

parameters, 232, 260

testing, 257

working with database, 232

storing data

DataSet object, 303

string conversion

CInt function, 48

String data type, 98, 142

accessing parts of strings, 144

array of strings, declaring, 149

changing case, 150

comparing strings, 149

converting between data types, 169

defining, 142

joining strings, 143

pulling strings apart, 144

quotation marks (") inside, defining, 143

Replace method, 153

Split method, 149

splitting strings, 147

string index length, 162

ToCharArray method, 149

toLower method, 151

toUpper method, 151

using String or Number, 156

strings

case-sensitivity, 150

substrings, 146

style conventions used in this book, 4

Style properties, MxDataGridField Collection Editor dialog, 277

Style Sheet dialog, (General) template, 378

StyleSheets

see CSS (Cascading StyleSheet).

Sub keyword

VB.NET procedures, 127

subfolder

referencing path to, 348

Subject, mailto: parameter, 369

subroutines

see procedures.

substrings

accessing parts of strings, 146

subtraction operator

basic maths using numbers, 158

support

customer support used in this book, 5

errata in this book, 6

p2p.wrox.com, 7

technical support in this book, 6

syntactic errors, 200

System namespace, 195

Array class, 194

System.Collections namespace, 194, 195

System.Data namespace, 196

when used, 301

System.Data.OleDb namespace

when used, 301

System.Data.SqlClient namespace, 301

System.Drawing namespace, 195

Color class, 182

System.Web.UI.WebControls namespace, 195