Starting with simple examples, you¿ll see how the multi-user, local area network applications that Visual FoxPro developers are used to building are constructed in Visual Basic .NET. You¿ll learn how to use Crystal Reports to build reports like the ones you build in FoxPro. You¿ll discover how to use DataAdapters and datasets instead of DBFs. You¿ll see examples of the paradigm shift that client-server programming imposes, and why .NET solves that problem (even when you wouldn¿t need to solve it in FoxPro.) And you¿ll learn how to give your FoxPro and Visual Basic applications smart client remote data access.
You¿ll understand how to begin the construction of a database project in Visual Basic with a container form and a MainMenu instead of using _Screen and MSYSMENU. You¿ll learn how variables are declared and used; how menus are controlled; how to use events, and why you have to use events in VB when they¿re unnecessary in FoxPro. You¿ll learn how to build inheritable forms, Visual Basic¿s answer to FoxPro¿s form class templates, to reduce programming to a minimum. You¿ll learn why properties are like variables in FoxPro, but more like functions in VB. And you¿ll learn where Visual Basic adds features that you didn¿t have in FoxPro and didn¿t know that you needed. You¿ll learn where to look for all of those FoxPro commands and functions that you need. And in case you haven¿t yet used SQL Server with FoxPro, the examples will demonstrate how it¿s done first in FoxPro, then in VB .NET.
1. Differences Between Visual FoxPro and Visual Basic .NET.
A Whole New World. The Integrated Development Environment (IDE). The Visual Basic .NET Solution Explorer. Command Syntax. Flow of Control. Variables, Enums, Arrays, Collections, and Fields. Functions and Subroutines (Procedures). Classes, Namespaces, Properties, and Forms. Events. Compiler Directives. Data. Data Binding. Error Handling and Debugging. Summary.
2. Building Simple Applications in Visual FoxPro.
Building a Simple Application in Visual FoxPro Building a Simple Application in Visual Basic .NET. Summary.
3. Building a Visual FoxPro Application for SQL Server.
Why Three-Tier? Creating the SQL Database and Loading Your Tables. Writing the Sample Application. The Form Template. A Search Form Template. The Data Tier. Whats Next?
4. A Visual Basic .NET Framework.
Starting the New Windows Application Project. Adding a Windows Controls Library. Building Your First Inheritable Form. Programming with Class. Click Event Code for the Forms Buttons. Summary.
5. Adding Internet Access.
ASP and Database Development. Internet Access in Visual FoxPro 7. The StandardForm Class Template. Writing Web Connection Functions. Introducing the Server. Modifying the Data Tier to Add Internet Data Access. Building XML Web Services with Visual FoxPro 8. XML Web Services in Visual Basic .NET. Adding References to the Web Service to Your Client. Summary.
6. Data Access.
Data Access in Visual FoxPro Before Visual FoxPro 8. Database Containers. New Features in Visual FoxPro 8. Data Access in Visual Basic .NET. Summary.
The Structure of XML. Representation of Complex Structures. Hierarchical XML. The Document Object Model. Commands to Move Data Between a Table and XML. How FoxPro Implements XML. Importing XML into Visual Basic .NET. Reading XML into a Visual Basic .NET Dataset. Using XML and Data Islands to Reduce Server Load. Related Technologies: XPATH and XSLT. Extensible Style Sheet Transformations (XSLT). Summary.
8. Screen Design.
The Base Control Classes. Creating the Startup Screen for Your Application. Creating Menus. Subclassing Controls. Data Binding. Innovative Screen Design. Tools. Summary.
9. Searching and Filtering in Visual FoxPro and Visual Basic .NET.
Record Filtering in FoxPro. Record Filtering in Visual Basic .NET. A Generic Record Lookup Grid with Column Sorting in Visual FoxPro. Returning a Value from a Visual Basic .NET Form. Using the DefaultDataView for Filtering and Sorting. A Generic Record Lookup Form in Visual Basic .NET. Minimalist Filtering in Visual FoxPro and Visual Basic .NET. Search Forms with Additional Fields. Building Self-Populating Controls. Cleaning Up Mistakes in Legacy Data to Improve Searching. Getting Filtered Data Across the Web. Summary.
Reporting in Visual FoxPro. Crystal Reports in Visual FoxPro. Reporting in Visual Studio .NET.