DataAdapter question

[Eric A. Johnson]

I'm using ADO style. I have an Access database with four tables that I will
want to do queries on. I will want to do queries on all four tables, at
least individually, and possibly at the same time (using "INNER JOIN"). My
question: Is it better to have four individual DataAdapters, one for each
table, with the DataSet linking to a different one for each query; one
single DataAdapter, that would connect to all four tables at once; or some
kind of combination of the two? Any tips? As you can tell, I'm rather a
newbie at databases.

Thanks,
Eric

 

[Cor Ligthert [MVP]]

Eric,

A join creates as rowset one datatable. If you need that, than go for that,
do you need four tables, than you need four SQL string. If you use for that
4 dataadapters or just one, depends only four what you prefer.

There is for both methods not to find a reason why you would take the one or
the other. In fact are four dataadapters much easier to create than one,
however as soon as you start to create your own databaselayer, than you will
see that one is much easier for that.


I hope this helps so far.

Cor