Hey Community,
I have done some
vb.net courses in school, however none with database or getting into inheritance etc. I specialized in System Admin.
I now have the need to create an application that extracts data from our ERP software. The software uses CISAM files and we have Transoft ODBC connections available to the data.
I'm lost on how to access this data. I'm using MS
VB 2008 Express edition. I recently downloaded and installed the references found here (
How to use the ODBC .NET Managed Provider in Visual Basic .NET and connection strings) on how to make an ODBC connection.
I have created a button that does the following successfully, which displays the first record in a row - I terminate the app to stop it.
Code:
Dim conn As OdbcConnection
Dim connectionString As String
Dim comm As OdbcCommand
Dim dr As OdbcDataReader
Dim sqlStr As String
connectionString = "dsn=Encore50A;uid=;pwd=;"
conn = New OdbcConnection(connectionString)
sqlStr = "Select * from INVPRICE"
conn.Open()
comm = New OdbcCommand(sqlStr, conn)
dr = comm.ExecuteReader()
While (dr.Read())
MsgBox(dr.GetValue(0).ToString())
End While
conn.Close()
dr.Close()
comm.Dispose()
conn.Dispose()
End Sub
There are few things I guess I need:
a) A good resource with examples so I can understand how this works
b) Showi me how to display the data in a DataGrid - with/without the ability to modify.
c) Figure out how (via programming) to copy tables from this odbc connection to a local MDB file.
Feel free to lead me to water, I can attempt to drink and come back with more questions
