468,740 Members | 1,947 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,740 developers. It's quick & easy.

Strategy / direction?

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
0 844

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Robert Oschler | last post: by
5 posts views Thread by Graham Blandford | last post: by
3 posts views Thread by syncman | last post: by
4 posts views Thread by Claudio Jolowicz | last post: by
6 posts views Thread by Daniel Santa Cruz | last post: by
5 posts views Thread by pythoncurious | last post: by
7 posts views Thread by Ryan | last post: by
reply views Thread by ltruett | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.