- Nov 2, 2004
- 1,460
- 2
- 81
I have my program connected to Microsoft access in VB.net 2003
Dim conn As Odbc.OdbcConnection
Dim sConnString As String = _
"Driver={Microsoft Access Driver (*.mdb)};Dbq=devices.mdb;Uid=Admin;Pwd=;"
conn = New Odbc.OdbcConnection(sConnString)
conn.Open()
Now how do I go about declaring a variable to write an sql statement and executing the statement?
thanks
Dim conn As Odbc.OdbcConnection
Dim sConnString As String = _
"Driver={Microsoft Access Driver (*.mdb)};Dbq=devices.mdb;Uid=Admin;Pwd=;"
conn = New Odbc.OdbcConnection(sConnString)
conn.Open()
Now how do I go about declaring a variable to write an sql statement and executing the statement?
thanks