Hi All, wonder if anyone can help me with some direction...
I'm a VB6er who has been plunged into the VB.NET arena with a requirement to
complete a reasonably small project within a month..
The basics are.. I have two databases, from 3rd-party suppliers for which
there is somewhat common data that I have to 'unite' using a simple
interface, enabling the end-user to report on the combined information from
both.
Both databases are Access; the data is 'open' in one, and the data in the
other is accesible via a dll/reference supplied by the vendor of the
software/database.
My plan is to create a 3rd database - a transaction-store, which essentially
keeps a cross-reference of records in comparable tables in the two 3rd-party
databases. A user-driven function will scan one database, and check for any
new records that don't have a matching record in the transaction-store,
these records are then presented to the user who will go then match them
with records in the other 3rd-party database. These new matches are then
added to the transaction-store database.
Now, in VB6, I could have written some quite offensive code, that would
essentially read the first table, then read the transaction-store for
existence, and added records as necessary....
Looking at VB.NET, I see that we have some wonderful ways to set
relationships in the data programmatically. Could I use this to my
advantage? If so, any code examples handy? - nothing too indepth, but any
pointers in the right direction would be greatly appreciated....
Basically, any ideas you guys have, I'd be interested in hearing... as I
say, I'm new to .NET have a number of books to read, but need to start
producing on this pretty quickly and could do with a jump-start..
Thanks,
Graham