Index_D

D

data

passing data between pages, 360

data access method

populating DataGrid, 308

data access objects, ADO.NET, 300

data access tier

creating, 455

Data area, main window, 32

data binding

<% # ... %> tags, 286

controls, 278

DataReader object, 303

hashtable values, 193

implementing menu using data bound control, 390

list controls, 327, 328

templates, 279

Data Explorer window, 227

see also icons.

inserting and editing data, 250

viewing data, 253

Data Pages template, 24

Add New File dialog, 248

Editable Data Grid type, 248

Simple Data Report type, 409

Simple Stored Procedure type, 257

Data Report type, Data Pages template

guest book case study, 409

data types

Boolean, 161, 163

declaring variables, 136

floating point, 156

functions converting, 169

integer, 156

Number, 156

String, 142

table of, 240

DataAdapter classes/objects, 302

connecting to databases using, 303

Fill method, 303, 318

selecting rows based on search string, 317

SqlDataSourceControl control, 268, 300, 304

database server software, 512, 515

installation, 16

licensing, 516

databases

accessing data using code, 299

adding data, 255

amending data, 255

centralizing database configuration, 407

columns, 237

connecting DataSet object, 303

connecting to a database, 228

exceptions, 207

guest book case study, 410

connecting to multiple databases, 232

connecting using DataAdapter object, 303

connection strings, 270

creating, 236

Data Explorer inserting and editing data, 250

data presentation, 272

deployment, 519

disconnecting from, 235

displaying data from database, 233

extracting data, 264

limitations of Web Matrix, 510

primary key, 238

rows, 237

tables, 237

updating, 292

viewing data, 253

DataBind method, DataGrid control

binding to an array, 187

data binding with list controls, 336

displaying selected rows in DataGrid control, 319

Page_Load event, 309

DataBinder class/objects

Eval method, 286

databinding, 187

DataField property, MxDataGridField Collection Editor dialog, 277

DataFormatString property, MxDataGrid, 274, 278

DataGrid control, 328

automatic addition in design view, 233

DataBind method, 309

DataSource property, 309

displaying data in, 305

displaying selected rows in, 318

formatting, 422

guest book case study, 422

MxDataGrid control, 300

populating, example, 305

Simple Stored Procedure type, 257

DataGrid Properties dialog, 320

DataList control, 328

data binding with list controls, 330

displayed in browser, 339

DataNavigateUrlField item, MxDataGrid, 278

DataReader classes/objects, 302

accessing rowsets, 302

data binding, 303

DataSet object compared, 303

diagrammatic representation, 302

populating DataGrid, 308

DataSet class/objects, 302

connecting to database, 303

DataReader object compared, 303

SqlDataSourceControl control, 300

storing data, 303

DataSource property

DataGrid control, 309

MxDataGrid control, 294

DataSourceControlID property, MxDataGrid control, 272

DataTextField item, MxDataGrid control, 278

Date and Time data types, 164, 242

converting between data types, 169

converting text into dates, 165

Date data type, 164

Now function, 166

DateTime data type, 242

displaying dates, 165

getting dates from user, 165

International Settings, 251

DBMS (database management system), 517

debugging

breakpoints, 220

deployment, 203

help, 221

launching debugger, 218

limitations of Web Matrix, 510

run time debugging, 217

turning on, 203

Decimal data type, 242

Single or Double, 156, 157

decision making, 98

If...Then statement, 98

declaring constants, 168

declaring variables, 136

choosing incorrect data types, example, 139

declaring arrays, 179, 180

declaring then defining a Number, 158

declaring then defining a String, 143

hashtables, 192

inside or outside procedures/functions, 142

ReDim statement, 183

SortedList collection, 193

where to declare, 140

default pages, 350

IIS order of preference, 352

Default values, 246

Delete command

chaging data in database, 303

DELETE Data Method, 323

importance of WHERE clause, 325

wizard, 305

Delete icon, Data Explorer, 236

DELETE statement

SqlDataSourceControl control, 269

DeleteCommand property, SqlDataSourceControl control, 269

deployment, 517

databases, 519

debugging, 203

limitations of Web Matrix, 508

Visual Studio .NET, 520

Design and Code Editor, main window, 26

Design view, 43

Details array of properties

ProductInfo class, 495

development environments, 507

devtag property

KeywordRequest class, 494

dialogs

see also windows.

Add New File dialog, 248

Auto Format dialog, 311

Connect to Database dialog, 229, 239

Create New Table dialog, 242

dialogs (continued)

Create Stored Procedure dialog, 256

DataGrid Properties dialog, 320

Edit DataList Templates dialog, 332

Edit Stored Procedure dialog, 231

Edit Table Design dialog, 247

Edit Table dialog, 230, 250

Label DataBindings dialog, 334

ListItem Collection Editor dialog, 74

New Item dialog, 23

Query Builder dialog, 306

Regular Expression Editor dialog, 205

Start Web Application dialog, 44

Style Sheet dialog, 378

Test Query dialog, 253

Text File dialog, (General) template, 374

View Table Design dialog, 252

WHERE Clause Builder dialog, 313

Dim keyword

declaring variables, 136

DivideByZeroException exception type, 209

division operators

\ (integer division) operator, 158

basic maths using numbers, 158

DLL (Dynamic Link Library)

guest book case study, 431

Do Loop, 115

exiting a loop early, 118

Do Loop Until loop, 115

putting test condition at the start, 118

Do Loop While loop, 117

putting test condition at the start, 118

documentation

help tracing and debugging, 221

limitations of Web Matrix, 508

Domain property, HttpCookie object, 471

downloading sample code, 5

DropDownList control, 74, 78, 327

data binding with list controls, 330

displayed in browser, 338

Items property, 74