I can't figure out how to get my C1 FlexGrid (2.6) to update table data in the underlying database connected via an ODBC DSN.
The grid displays the data as expected and allows me to change it but when I reopen the program, the changes are gone. I use the same ODBC DSN in other apps (VB6 with a good old vsFlexGrid) and can update the data there.
I'm using version 5.1 of the MySQL ODBC driver on a Win 7 x64 machine and VS 2010 / Visual Basic
I can't get this simple windows form application with a C1FlexGrid bound to a DataTable to update the database.
Any tips as to what I am doing wrong would be appreciated.
Here's the relevant code:
'Grid is a control on the form of type C1.Win.C1FlexGrid
Private oConnOdbc As OdbcConnection = New OdbcConnection("Provider=MSDASQL;DSN=IA CRM")
Private Sub Form1_Load...
Dim oAdapter As New OdbcDataAdapter()
oAdapter.SelectCommand = New OdbcCommand("Select * From Testing", oConnOdbc)
Dim oDataTable As New DataTable
Grid.DataSource = oDataTable
Private Sub Form1_FormClosing...
' from what I have read, this shouldn't be necessary
Dim oDataTable As DataTable = CType(Grid.DataSource, DataTable)