By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,693 Members | 1,650 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,693 IT Pros & Developers. It's quick & easy.

Strategy / direction?

P: n/a
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
Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.