Index A

A

AcceptChanges( ) (DataTable class), 411

Access databases

browsing and manipulating data with forms, 443-458

browsing through rows, 452-453

deleting selected rows, 457

design and operational views (example), 444-445

form load event procedure, 447-452

inserting new rows, 454-456

updating rows, 458

comparing data types with .NET, 63-65

database connections, 356-365

altering where to find database file, 363-365

connecting to SQL server databases, 360-363

reporting Connection properties, 357-359

dynamic data access, 366-377

with Access query and parameters, 375-377

with SQL string and parameter, 372-375

with SQL string and variable, 367-368

validating string variables , 368-371, 492-493

dynamic data manipulation, 378-388

adding database tables, 381-383

creating databases, 379-380

DataAdapter and DataSet programming, 388-411

within transactions, 383-388

form controls, programming, 224-249

browsing data records, 227-231

DataGrid properties, managing, 296-312

navigating records and showing pictures, 232-237

switchboard forms, Data Form Wizard, 280

switchboard forms with LinkLabel controls, 244-249, 252-256

validating passwords, 224-227

form navigation, programming

ComboBox controls, 266-269

DataGrid properties for, 301-312

TextBox controls, 256-262

TextBox controls, formatting with, 262-266

iterating through database tables, 82-84

iterating through table columns , 85-86

main/sub forms, 290-296

relations between tables, XML schemas for, 617-622

securing applications. See security

tables. See tables in databases

TextBox controls for data manipulation, 281-286

translating data types to .NET, 86-91

updatable data sources for DataGrid controls, 286- 290

Web service for, 555-567

building client application, 563-567

testing and demonstrating, 559-562

writing contents to files, 142-145

access modifiers, 73-74

access to class entities, 39

Add( ) (ControlBindingsCollection class), 259

Add( ) (OleDBCommand class), 372

AddHandler statement, 148, 153

AddressOf keyword, 148

Admin account, 577

administration of security policy, 572

Admins group account, 577

ADODBNorthwind project, 167-172

ADODBNorthwindLibUser project, 173-179

ADODBOrderDetailAnalyzer project, 165-167

ADO.NET, 313-353

Access user -level security, 575-594

creating accounts and permissions, 577-581

design issues, 576-577

selecting from secure databases, 582-588

updating secure databases, 588-594

ADO vs., 319-321

class architecture, 321-343

OleDbCommand class, 327-332

OleDbConnection class, 321-327

OleDbDataAdapter class, 337-343

OleDbDataReader class, 332-337

data access, vs. ADO, 319-321

DataAdapter and DataSet objects, 388-411

concurrency violations, 409-411

displaying dataset metadata and data, 394-398

graphically based datasets, 404-409

manipulating rows, 399-404

setting up OleDbDataAdapter, 390-394

database connections, programming, 356-365

altering where to find database file, 363-365

connecting to SQL server databases, 360-363

reporting Connection properties, 357-359

datasets, creating and using, 414-428. See also DataSet class

custom initialization code, 420-421

DataSet object model, 344-353

Forms Designer code, understanding, 418-419

from two DataTable objects, 427-428, 438-441

typed and untyped, schemas for, 421-425

typed schemas, IntelliSense for, 426-427

design elements, 316-319

dynamic data access, programming, 366-377

with Access query and parameters, 375-377

with SQL string and parameter, 372-375

with SQL string and variable, 367-368

validating string variables, 368-371, 492-493

dynamic data manipulation, programming, 378-388

adding database tables, 381-383

creating Access databases, 379-380

within transactions, 383-388

forms, browsing and manipulating data with, 443-458

browsing through rows, 452-453

deleting selected rows, 457

design and operational views (example), 444-445

form load event procedure, 447-452

inserting new rows, 454-456

updating rows, 458

implementing on ASP.NET pages, 490-493

built-in data validation, 492-493

Data Form Wizard, 493-499

data manipulation from Web pages, 512-523

graphically created ADO.NET objects, 499-506

programmatically created ADO.NET objects, 506-512

parent-child relationships between datasets, 429-443

adding relations between DataTables, 434

computing child values, typed dataset, 438-443

computing child values, untyped dataset, 429-438

XML schemas for, 617-622

platform requirements, 314-316

ADO.NET component, 3, 18-22

advantages of, 18-19

architecture of, 20-22

data providers, 19-20

data source binding, 256

disconnected datasets, 259

ADONETSamples project (example), 356-411

AllowSorting property (DataGrid control), 296-300

AlternatingBackColor property (DataGrid control), 271

anonymous login, denying , 596

AppendText( ) (File class), 131

ApplyStyle( ) (Style class), 505

arrays, 45, 92-102

consolidating metadata with, 99-102

one-dimensional, processing, 95-96

two-dimensional, processing, 96-99

As keyword, 71

.asmx files, 540

ASP.NET, 3, 6, 462-466

ASP vs., 465-466

controls on Web forms, 470-471

Data Form Wizard for ADO.NET solutions, 493-499

editing the HTML code, 497-498

editing the Visual Basic code, 498-499

data manipulation from Web pages, 512-523

design and operational views, 512-516

page code, 516-523

data processing overview, 490-493

forms authentication, 594-602

login page, creating, 596-599

secure Web pages, creating, 599-601

Web.config file, editing, 595-596

graphically created ADO.NET objects, 499-506

design and operation views, 499-502

Web page code, 502-506

Page class, 469-470

platform and browser considerations, 462-463

programmatically created ADO.NET objects, 506-512

design and operational views, 507-508

Web page code, 508-512

Web Application template, 33

Web forms and views, 466-469

Web forms programming, 471-486

HelloGoodbye.aspx (example), 471-476

HelloRefresh.aspx (example), 476-481

logging in to protected pages, 481-486

Web Service template, 34

Windows vs. Web applications, 463-465

assemblies, 13-15. See also code access security

assigning data sources to forms, 269-280

dynamically formatting DataGrid controls, 269-274

loading sources into DataGrid controls, 275-280

asymmetric encryption, 575

attributes, XML, 604, 606

authentication. See also security

ASP.NET application forms, 594-602

login page, creating, 596-599

secure Web pages, creating, 599-601

Web.config file, editing, 595-596

and role-based security, 573

Authentication section, Web.config file, 595-596

Authorization section, Web.config file, 595-596

Autonumber data type (Access), 64