New Page

DOCUMENT:Q186287 27-AUG-1998 [vbwin] TITLE :HOWTO: Create an HTML Page Using ADO and MSFlexGrid PRODUCT :Microsoft Visual Basic for Windows PROD/VER: OPER/SYS:WINDOWS KEYWORDS: ====================================================================== --------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual Basic Enterprise Edition for Windows, version 6.0 --------------------------------------------------------------------- SUMMARY ======= This article describes how to create a Web page that combines the MSFlexGrid control with ActiveX Data Objects (ADO). MORE INFORMATION ================ Below is an HTML example that uses the MSFlexGrid control with ActiveX Data Objects (ADO) to produce a Web page from a database stored on the client machine. The project shows the use of the GetString function, which is new to Visual Basic 6.0. NOTE: This code work correctly only on machines with Visual Basic 6.0 installed; it does not work on a machine with Visual Basic 5.0 installed. Although this example uses a local reference to the database, the reference could point to a remote database's directory, and the server's name can be changed to reflect a remote machine name. Step-by-Step Procedure ---------------------- 1. Start an instance of Notepad. 2. Cut and paste the code below into the instance of Notepad 3. Edit the connection string to match your machine. 4. Save the file as MyADOpage.html. 5. Double-click the newly saved file to invoke IE and the Web page. You can also use the ActiveX control pad to add additional ActiveX controls to the project for additional functionality: New Page

REFERENCES ========== For more information about ADO, use the Visual Basic Help. Query on ADO, DHTML, and/or MSFlexGrid. (c) Microsoft Corporation 1998, All Rights Reserved. Contributions by Richard T. Edwards, Microsoft Corporation Additional query words: kbdse kbDSupport kbVBp kbADO kbActiveX kbVBp600 kbHTML ====================================================================== Platform : WINDOWS Issue type : kbhowto ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 1998.