General information
Category:
Visual FoxPro Toolkit for .NET
Kirk-
I posted the corrected code, but neglected to explain what you were seeing.
>In the IDE the OleDbConnection is underlined and says Type OleDbConnection is not defined.
OleDbConnection belongs to the OleDb namespace. Actually, to be precise, it belongs to the System.Data.OleDb Namespace ("Namespace" just being a way of organizing classes.) When you created a VB.NET winform application, .NET created some default references for you. You can see what they are under the Solution Explorer tab under the Project name. In mine it's "WindowsApplication1" by default.
You'll probably see a reference to the System.Data DLL, which is the library that has the OLEDB related classes.
Does that help?
>It also shows the goView as not declared.
Good catches on both. goView isn't defined (in .NET you have to declare every variable). The way you can tell what type it should be is to put the mouse over the "SqlExecute" command, and you should see a big ol' ugly tooltip that includes the info that SqlExecute returns a variable that is of type DataView.
So, I just typed in
DIM goView AS
And then Intellisense kicked in and helped me find what it needed.
HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only