Thanks, Thearon for the reply.
Let me try to do a litle better job expaining my problem.
I am working on a personal home entertainment collections program. The program allows the user to collect and save Book, DVD and CD information.
The user sees a DataGridView of one of the collections and can select a specific item t review, change or delete by clicking the line on the grid
All of the database activities,including filling the details, saving the record, deleting a record an adding a new recordare programed using the WDABase class that you decribe and they work fine.
Since I haven't been able to get the DataGridView to work using the WDABase classs I programmed it using the Imprts OLEDB and that works fine, but the incocistany of method bothers me. I have tried (unsuccessfully) to program the DataGridView usingthe WDABas class..
Here's what I tried to do:
I set up a new very simple project with one form and a DataGrid view. I added the WDABase class with the following changes:
In the form Load event of my little test I added the following:
'Class level variables that are available to classes that instantiate me
Public SQL AsString
Public cn As OleDbConnection
Public cmd As OleDbCommand
Public da As OleDbDataAdapter
Public dr As OleDbDataReader
Public ds As DataSet
Public cm As CurrencyManager
Private disposed AsBoolean = False
PrivateSub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load
Using oData AsNew wdaBase
oData.SQL = "qryBooksGridSelect"
The reference to "GetAppPath" is a module where I build the connection string. It works fine elsewhere and the reference is removed from the WDABase class.
The line "
oData.da("qryBooksGridSelect", oData.cn)" produces an error "Expression is not a method"
I just don't know where to go from here. Can you help?