Brian Damage
Tank
- Joined
- Sep 27, 2003
- Messages
- 8,310
- Reaction score
- 3
Okay, here's the deal:
I'm trying to create a three-tiered program here, one tier being a VB GUI, one being a logic layer, and the last being the layer that accesses data from the database.
The whole thing is supposed to take percentage-based modifiers from the database in question, and use them together with details entered by a user at the GUI to give a mock-up insurance quote.
Basically, I need to take the numbers from the database, and pass them to the logic layer so that it can pass the completed quote (a monetary value) back to the GUI to be viewed by the user.
However, I just don't seem to be able to wrap my head around the SQL functionality (DataSets, DataTables, querystrings and all that) present in VB. And so far my only living source of info on it has been a lady who, not to put too fine a point on it, doesn't really communicate very well in English.
Add to that the fact that I have possibly one of the worst VB reference books out, and most of the sites online seem oriented towards professionals, and I'm totally at sea.
So, can anyone here give me a few pointers, or maybe even a concise explanation of the implementation of SQL in VB? Or point me towards a website with great big diagrams and clear terminology?
Anyone?
I'm trying to create a three-tiered program here, one tier being a VB GUI, one being a logic layer, and the last being the layer that accesses data from the database.
The whole thing is supposed to take percentage-based modifiers from the database in question, and use them together with details entered by a user at the GUI to give a mock-up insurance quote.
Basically, I need to take the numbers from the database, and pass them to the logic layer so that it can pass the completed quote (a monetary value) back to the GUI to be viewed by the user.
Code:
GUI => Logic => DataAccess
Factors-> |
| Query->
| <-Percentage modifiers
<-QuoteHowever, I just don't seem to be able to wrap my head around the SQL functionality (DataSets, DataTables, querystrings and all that) present in VB. And so far my only living source of info on it has been a lady who, not to put too fine a point on it, doesn't really communicate very well in English.
Add to that the fact that I have possibly one of the worst VB reference books out, and most of the sites online seem oriented towards professionals, and I'm totally at sea.
So, can anyone here give me a few pointers, or maybe even a concise explanation of the implementation of SQL in VB? Or point me towards a website with great big diagrams and clear terminology?
Anyone?
