Is there a book or reference manual one can purchase that explains how to better utilize the
VB.Net 2003 environment to fully utilize Access tables programmatically?
I am working on an application that requires the user to select a task and then the program performs it ---- without the user having the opportunity to screw things up.
So far, I am using Wrox's Beginning
VB.Net 2nd Edition and Wrox's Beginning
VB.Net Databases. They've whetted my appetite, but fail to satisfy the programmable functionality I enjoyed in
VB 5.0.
The specifics I need include how to design and utilize complex SQL functions strictly within the code, NOT through datagrids, etc. For example, a table load that is beyond the basic table load in that I want to be able to check the table for existing values before attempting to insert the row. Basically, if the row is there, it's an update, not an insert. And this all has to be done programmatically as the technical ability of my end users peaks at playing Solitaire.