Multiple Table - Update, Modify, Delete

[scorpion53061]

Up till now I have used the VS Wizard to generate my update statments for my
vb.net windows apps. I had only updated one table at a time so everything
was fine.

Now I am in a situation where i need to do a multiple table(2) query and be
able to add, remove , update. Either that or repeat all the columns of the
one in the other table and update both all the time. I just think that is
probably not the way to go. The two tables share a "job number" and a
"jobshipto" in common. The big difference is one has the items for the job
the other has the addresses and vital statistics and such.

To be honest I am not sure where to begin.

If there is a online tutorial about this I would be greatful.

I am deaing with an access database.

 

[Greg]

I recommend you pick up a copy of MS Press ADO.NET by Sceppa. Plenty of
example there on how to do tasks like this. We do this all over the place
and have all of the code in a Data Access Layer that accepts a DataSet and a
connection for updates.

 

[Rajesh Patel]

use stored procedures instead of sqlcommands automatically generated from
vs.net.

SPs will make your life easier. Your problem can be easily solved by stored
procedures.

Rajesh Patel