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]]

Re: vb.net default data access

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.]

Re: vb.net default data access

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,f irst and last. You could also investigate the
BindingManagerB ase 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

"John" <John@nospam.in fovis.co.uk> wrote in message
news:enN$cfdpFH A.3036@TK2MSFTN GP14.phx.gbl...[color=blue]
> 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
>
>[/color]