Quote:
Originally Posted by cathalo
a) A good resource with examples so I can understand how this works
|
Not much to understand at this stage; youre opening a database conenction and reading from a database
If you want a tabular representation of your data, you'd be better using a DataAdapter and a DataTable. the adapters Fills the table
Quote:
|
b) Showi me how to display the data in a DataGrid - with/without the ability to modify.
|
Modify depends on the driver ability to write; we don't know if that exists, but get cracking on with a relevant commandbuilder (OdbcCommandBuilder) to amke the Insert/Update/Delete Queries for you, or write your own, and use the DataAdapter Update() method to save changes
Showing the data in a DataGridView (not DataGrid; old component) is a matter of setting the grid's DataSource to be the filled DataTable
Quote:
|
c) Figure out how (via programming) to copy tables from this odbc connection to a local MDB file.
|
You'd be better off reading the DW2 link in my signature, section Creating a Simple Data App, to give you a rought overwiew of datasets, datatables, etc
As for copying the tables intoa local db, you may find it better to have the jet driver do that directly
see connectionstrings.com if it has an entry for inline attachment to another database.. Jet supports some syntax something like
SELECT * INTO new_table FROM [dsn=Encore50A;uid=;pwd=;]
i.e. the jet (access) driver will connect the dsn, retrieve the data and copy it locally. Hopefully; there may be no need for your app to proxy it