Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with Example
Message
 
To
All
General information
Forum:
ASP.NET
Category:
Visual FoxPro Toolkit for .NET
Title:
Help with Example
Miscellaneous
Thread ID:
00650925
Message ID:
00650925
Views:
52
I'm trying the VFP toolkit and I brand new to the whole VB and .NET thing. I created a windows form and put a button on it. In the button click code I have pasted the following from the ToolKit CHM file:
        'Establish a connection and a command 
        Dim lcConnectionString As String
        Dim lcSQL As String
        Dim oConn As OleDbConnection

        'Get the connection string and sql statement
        lcConnectionString = "Provider=vfpoledb.1;Data Source='C:\Program Files\Microsoft Visual FoxPro 7\Samples\Data\testdata.dbc';password='';user id=''"
        lcSQL = "Select * from customer"

        'Connect to the Database, execute the query and disconnect
        'SqlConnect(), SqlExecute(), SqlDisconnect()
        oConn = SqlConnect(lcConnectionString)
        goView = SqlExecute(oConn, lcSQL, "CustomerList")
        SqlDisConnect(oConn)

        'Select the default cursor
        VFPToolkit.vfpData.Select(goView)
        Browse()
In the IDE the OleDbConnection is underlined and says Type OleDbConnection is not defined. It also shows the goView as not declared. I don't know how to fix these. Any help for the VB challanged greatly appreciated.

Kirk
Next
Reply
Map
View

Click here to load this message in the networking platform