Programming Microsoft Visual Basic .NET for Microsoft Access Databases (Pro Developer)

F

fad technologies, 4

FieldCount property (OleDbDataReader class), 332

File class, 131

file processing, 130-146

listing files in folders, 132-137

enumerating with Directory class, 135-137

enumerating with DirectoryInfo class, 132-135

reading text files, 145-146

selecting and showing binary files, 137-141

System.IO classes, 130-132

writing Access database contents to files, 142-145

file types for Web pages, 466

FileInfo class, 131, 133, 146

FileIOPermission class, 571

FileProcessingSample project, 132-146

FileStream class, 131

Fill( ) (OleDbDataAdapter class), 337, 338

Finalize method (Object class), 47

Finally clauses (Try statements), 17, 180-181, 187-190

Find( ) (DataView class), 457

Find( ) (OleDbDataAdapter class), 401

FlowLayout setting (Web forms), 464, 467, 470

folders, listing files in, 132-137

Font property (Style class), 505

FontInfo class, 505

For... Next statements, 79

For Each... Next statements, 80

forcing project compilation in IDE, 36

ForeColor property (Style class), 505

foreign key constraints, 440-443

ForeignKeyConstraint class, 345

form Load events, 149-150

formatting forms

dynamically formatting DataGrid controls, 269-274

TextBox form navigation, 262-266

FormControlSamples project (example), 228-249

Forms Designer. See Windows Forms Designer

forms programming, 194-209

authentication, 594-602

login page, creating, 596-599

secure Web pages, creating, 599-601

Web.config file, editing, 595-596

browsing and manipulating data, 443-458

browsing through rows, 452-453

deleting selected rows, 457-457

design and operational views (example), 444-445

form load event procedure, 447-452

inserting new rows, 454-456

updating rows, 458

Close control, disabling, 204-209

data source assignment, 269-280

dynamically formatting DataGrid controls, 269-274

loading into DataGrid controls, 275-280

main/sub forms, creating, 290-296

manipulating forms with event procedures, 199-204

modal vs. modeless forms, 210-213

programming controls for Access databases, 224-249

binding with Data Form Wizard, 251, 280-286

browsing data records, 227-231

DataGrid properties, managing, 296-312

navigating records and showing pictures, 232-237

validating passwords, 224-227

programming form navigation, 256-269

ComboBox controls, 266-269

DataGrid properties for, 300-312

TextBox controls, 256-262

TextBox controls, formatting with, 262-266

switchboard forms

Data Form Wizard (example), 280

LinkLabel controls for, 252-256

switchboard forms with LinkLabel controls, 244-249

Windows Forms Designer, 194-199, 420-421

working with multiple forms, 209-223

child forms, results from, 214-219

passing values between, 220-223

using form data for other forms, 238-243

Friend access modifier, 73

Function procedures, 69-77

access modifiers, 73-74

methods , creating, 116-127

Option Strict statement with, 72

optional parameters, 74-76

overloading, 165

parameter arrays, 76-77

passing values, 71-72