Visual Fox Pro to Visual Basic.NET

Cover......Page 1
Table of Contents......Page 5
Introduction......Page 18
 A Whole New World......Page 22
  Typing Commands in the Command Window......Page 25
  The Toolbox......Page 26
  Projects and Solutions......Page 28
  Compiler Output Formats......Page 30
  The Document View Window......Page 31
  The Server Explorer......Page 32
  What Can You DO in the IDE?......Page 33
  The Properties Window......Page 34
  Getters and Setters Versus ASSIGN and ACCESS Methods......Page 35
  Shortcut Keys......Page 36
  The Tools, Options Dialog......Page 37
  The Output Window and Your Application Menu......Page 38
 The Visual Basic .NET Solution Explorer......Page 39
  Intermediate Language......Page 41
  Other Characteristics of a Visual FoxPro Project......Page 42
  Using Tables to Store FoxPro Project Components......Page 43
  File Types Used in Visual Basic Projects......Page 44
 Command Syntax......Page 45
  Calling a Function, Procedure, or Method......Page 47
  Do...ENDDO and Other Loops in Visual FoxPro......Page 48
  Loops in Visual Basic .NET......Page 49
  Conditional Execution in Visual FoxPro......Page 50
  Conditional Execution in Visual Basic .NET......Page 51
  Data Types......Page 52
  Variable Scope Declaration in Visual FoxPro......Page 53
  Variable Declarations in Visual Basic .NET......Page 55
  Enumerations, Arrays, and Collections......Page 57
 Functions and Subroutines (Procedures)......Page 61
  Function Declarations......Page 62
  Summary of Visual Basic Declarations......Page 67
 Classes, Namespaces, Properties, and Forms......Page 68
  Property Procedures in Visual Basic .NET......Page 73
 Events......Page 75
  Events in Visual FoxPro......Page 76
  Events in Visual Basic .NET......Page 77
  How to Declare an Event in a Class......Page 79
  The Form......Page 83
 Compiler Directives......Page 87
 Data......Page 88
 Data Binding......Page 91
  TRY...CATCH......Page 92
  FoxPro Debugging Aids......Page 93
 Summary......Page 94
 Building a Simple Application in Visual FoxPro......Page 96
  Field Mapping......Page 98
  Form Methods......Page 99
  Adding the Command Buttons......Page 100
  Creating a Form Template......Page 104
  Creating a Customers Table......Page 106
  Creating a Dataset......Page 109
  Form Methods......Page 110
  Adding the Command Buttons......Page 111
 Summary......Page 114
 Why Three-Tier?......Page 116
  Getting Our Test Data Ready......Page 119
 Creating the SQL Database and Loading Your Tables......Page 120
 Writing the Sample Application......Page 124
 The Form Template......Page 129
  How to Use the FlatFileForm Template......Page 133
 A Search Form Template......Page 134
 The Data Tier......Page 139
  Running the Application......Page 150
 What’s Next?......Page 151
 Starting the New Windows Application Project......Page 152
 Adding a Windows Controls Library......Page 154
 Building Your First Inheritable Form......Page 158
  Coding the Form Class......Page 161
 Programming with Class......Page 163
  Automating Data Access......Page 164
  Loading the List Box and Displaying a Record When Clicked......Page 167
  Utility Routines......Page 170
 Click Event Code for the Form’s Buttons......Page 171
  How the Button Code Works......Page 172
  How to Use This Template......Page 175
 Summary......Page 176
 ASP and Database Development......Page 178
  Installing Web Connection......Page 181
  Building Your Application......Page 182
  The Main Program......Page 183
 The StandardForm Class Template......Page 186
  The Internet Server......Page 187
  How Web Connection works......Page 188
  Passing Parameters......Page 190
  An XML Primer......Page 194
  The Customer Form......Page 195
 Introducing the Server......Page 197
  The SEND2DBF and SEND2SQL Functions......Page 209
 Modifying the Data Tier to Add Internet Data Access......Page 211
 Building XML Web Services with Visual FoxPro 8......Page 225
  A Main Form for the Sample Application......Page 230
  Building a Web Service for the Sample Application......Page 231
  Web Service Functions......Page 232
  How It Works......Page 233
 Adding References to the Web Service to Your Client......Page 234
  Code for the Windows Application to Use the Web Service......Page 236
  How It Works......Page 237
  The EditCustomer Form......Page 238
  How It Works......Page 240
 Summary......Page 241
6 Data Access......Page 244
  The DBF Format......Page 245
  Using Local Tables (DBFs)......Page 246
  Aliases......Page 247
  Supporting Cast......Page 248
  Buffering......Page 249
 Database Containers......Page 250
  SQL Pass-Through......Page 252
  Connections and Connection Strings......Page 253
  Other SQL Commands......Page 254
  The Cursor Adapter Class......Page 256
  The XML Adapter Class......Page 264
  Disconnected Data Access......Page 271
  Connections......Page 272
  Data Adapters......Page 273
  Datasets......Page 278
  Typed Datasets......Page 279
  The Data Form Wizard......Page 280
  The Generated Code......Page 285
  Data Binding......Page 288
  XML Web Services......Page 291
  How to Use the Web Service......Page 294
 Summary......Page 296
7 XML......Page 298
 The Structure of XML......Page 299
  Namespaces......Page 301
  Examples of XML......Page 302
 Representation of Complex Structures......Page 304
 Hierarchical XML......Page 307
 The Document Object Model......Page 310
  CursorToXML( )......Page 312
  XMLToCursor( )......Page 316
  Using XML to Read Other Types of Data......Page 319
  Receiving XML Files Directly......Page 320
  Direct Access to SQL Server with XML......Page 321
  Using the XML DOM to Call a Web Service......Page 323
  Using the XML DOM to Validate Documents......Page 325
  XMLUpdateGrams......Page 326
  DiffGrams in Visual FoxPro 8......Page 329
  The Visual FoxPro CursorAdapter......Page 331
  Creating a CursorAdapter to Read XML......Page 333
  The Visual FoxPro XMLAdapter......Page 337
  Data Islands......Page 338
 Related Technologies: XPATH and XSLT......Page 340
 Summary......Page 341
 The Base Control Classes......Page 342
 Creating the Startup Screen for Your Application......Page 344
  The Startup Screen for Your Visual Basic .NET Application......Page 345
  The FoxPro Menu......Page 347
  The Visual Basic .NET MainMenu Control......Page 348
  Subclassing the FoxPro Screen Controls......Page 349
  Using Your Subclassed FoxPro Controls......Page 350
  Subclassing the Screen Controls in Visual Basic .NET......Page 352
  Data Binding in Visual Basic .NET......Page 356
  A Simple FoxPro Screen to Demonstrate Binding and Navigation......Page 359
  The Equivalent Form in Visual Basic .NET......Page 362
  Updating the Data Source Tables......Page 366
  Formatting Input in Visual Basic .NET......Page 368
  Extending Screen Design in Visual FoxPro......Page 369
  The Quicken Interface in Visual Basic .NET......Page 372
  Buttons That Load a Different Form......Page 375
  SDI Forms......Page 376
  Colors in Form Controls......Page 377
  Colors on Graphical Style Controls......Page 378
  User-Settable Form Size and Location......Page 379
  Grids Redux......Page 383
  Tree Views and Lists in FoxPro......Page 388
  Build Your Own Menu......Page 389
  ActiveX Controls......Page 395
  Build Your Own Controls......Page 397
 Summary......Page 400
 Record Filtering in FoxPro......Page 402
 Record Filtering in Visual Basic .NET......Page 404
 A Generic Record Lookup Grid with Column Sorting in Visual FoxPro......Page 405
 Using the DefaultDataView for Filtering and Sorting......Page 411
 A Generic Record Lookup Form in Visual Basic .NET......Page 413
 Minimalist Filtering in Visual FoxPro and Visual Basic .NET......Page 416
  A Generic Search Form in Visual FoxPro......Page 418
  Building the EasySearch Form Class in Visual Basic .NET......Page 424
 Building Self-Populating Controls......Page 429
 Cleaning Up Mistakes in Legacy Data to Improve Searching......Page 431
  Migrating Legacy FoxPro Data to SQL Server......Page 432
  Building a Parameterized Web Service in Visual FoxPro......Page 445
  Using the DLL......Page 446
  Using the Web Service in a Smart Client Application......Page 447
  Building a Parameterized Web Service in Visual Basic .NET......Page 449
 Summary......Page 451
 Reporting in Visual FoxPro......Page 452
  Internal Details......Page 453
  Page Setup......Page 454
  Report Controls......Page 455
  Title and Summary Bands......Page 456
  Data Grouping......Page 457
  A Simple Example......Page 458
  Adding Groupings......Page 459
  Calculated Expressions......Page 460
  Grouping Using a Report Variable......Page 461
  Report Filtering......Page 463
  Build and Execute a SELECT Statement in the Init Event of the Report’s Data Environment......Page 465
  Using a Report Filter with SQL Server......Page 466
  Reporting on the Internet......Page 468
 Crystal Reports in Visual FoxPro......Page 471
  Building Your First Report with Visual Studio .NET......Page 472
  Putting the User in Control......Page 476
  Report Management and Use with the Server Explorer......Page 477
  Using a Dataset as a Data Source......Page 478
  How It Works......Page 480
  Creating a Parameterized Report......Page 481
  Using the Parameter......Page 485
  XML Report Web Services......Page 486
  Exporting to a PDF......Page 488
  Other Report Experts......Page 489
  The Drill Down Expert......Page 495
 Summary......Page 499
 A......Page 500
 B......Page 502
 C......Page 503
 D......Page 506
 E......Page 508
 F......Page 509
 I......Page 511
 N-O......Page 513
 P......Page 514
 Q-R......Page 515
 S......Page 517
 T......Page 520
 V......Page 521
 W......Page 527
 X -Y-Z......Page 528