Visual FoxPro to Visual Basic .NET

Les Pinter  
Sams Publishing
Total pages
May 2004
Related Titles

Product detail

Product Price CHF Available  
Visual FoxPro to Visual Basic .NET
61.30 approx. 7-9 days


A career-enhancing guide to the future for FoxPro developers.

Table of Contents


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.

7. XML.

    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.

10. Reporting.

    Reporting in Visual FoxPro. Crystal Reports in Visual FoxPro. Reporting in Visual Studio .NET.

Back Cover

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.

  • Shows how to build a typical application in Visual FoxPro, including DBF, SQL Server and Internet access; then demonstrates how to build the same type of application in VB .NET
  • Highlights the main differences in specific issues, including printing, events, data access, creation and use of properties
  • Contains an appendix listing the principal FoxPro commands and functions and their Visual Basic equivalents
  • Includes a table showing where to find the settings in the FoxPro¿s Tools, Options menu pages in VB .NET
  • Shows how to access data remotely from your FoxPro and VB .NET applications
  • Explains how project DLLs are created and used in other projects within a solution
  • Shows how to use middle tier business objects to simplify ongoing development
  • Source code downloadable from


Les Pinter is Contributing Editor of Universal Thread magazine in Montréal, and a monthly contributor to the Virtual FoxPro User Group (VFUG) user group newsletter. He is also a member of the INETA (International .NET User Group Association) Speakers¿ Bureau for Latin America. Les publishes numerous articles on FoxPro, SQL, VB .NET and ASP.NET on his website and in Les Pinter's Database Journal, a bimonthly newsletter. Les has been a speaker at conferences in the US, Mexico, Argentina, Colombia, Venezuela, Brazil, France, Spain, Russia and Canada. He gives seminars on Visual FoxPro and Visual Basic database development in English, French, Spanish, Portuguese and Russian. Although the Pinter Consulting corporate office is located in Mexico City, Les lives in San Mateo, California with his wife Ying-Ying Chang.