vb.net default data access

[John]

Hi

The data access setup that vb.net creates when fields are dropped on a form,
does it bring all records from server? If so, is that not a bad way to do
things? Additionally, is there a way to use multiple selects with a data
adapter i.e. one each for next record, previos record, first record and last
record?

Thanks

Regards

 

[Cor Ligthert [MVP]]

John,

I think that you have to explain this more to get an answer. Are you maybe
using the special data wizard form. In my opinion not the nicest thing to
use because it is hard to change something as soon as you are ready.

I hope this helps,

Cor

 

[Phil G.]

John,

There are numerous possibilities for both retrieving data from data sources,
whether db's, files of various flavours such as .xls .xml delimited text
etc, and also displaying and/or editing those 'records'. It really depends
on your application and your knowledge Again, the VS IDE provides for
easy viewing/editing of data by providing databound controls and methods to
do the job.

I guess one problem (perhaps) with using these bound controls is that they
have a permanent connection to your datasource. In some apps., especially
those whereby the db is not on the local machine, this will have negative
consequences.

All that said, your questions

Yes, you will likely retrieve all data unless you code behind the event to
SELECT only certain records.

There are methods within some controls to specifically manipulate data to
return Next,Previous,first and last. You could also investigate the
BindingManagerBase class within the Forms class. With this you track the
position and can add or subtract 1 to move, as well as use the count
property to get the 1st and last records.

HTH,

Phil