Re: Requery DataAdapter

The only way the DataAdapter can "see" database changes is to re-execute the
Fill method which executes the SelectCommand. Since a DataSet is a
"disconnected" in-memory structure, it has no "connection" to the underlying
data. Now if this was a server-side cursor, the situation might be somewhat
different, but you would still have to requery the cursor to get the data...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"premium001" <premium001@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FAC8DC8D-26C5-49A4-AEBE-CF4D95E776D5@xxxxxxxxxxxxxxxx
>I have .net 2003. I have a form with dataadapter and connection and
>dataset
> objects on it. I display some info in labels on the form from the dataset.
> I
> have a new form come up to make cahnges to the originating database. I
> write
> these changes back to the database using code instead of throught the
> existing objects I mentioned above. After I write the changes back I can
> look
> at the table and the changes are there. I want to have the form update the
> label displays immediately. I can't seem to get the DataAdapter or the
> Dataset to requery or update themselves with the new info for me to
> redisplay
> it in the labels without having to close the app and then restart it. Any
> help would be very much appreciated.
> --
> Thank you for your help...premium001


.

Relevant Pages

  • Requery DataAdapter
    ... I have a form with dataadapter and connection and dataset ... I display some info in labels on the form from the dataset. ... have a new form come up to make cahnges to the originating database. ... I want to have the form update the ...
    (microsoft.public.data.ado)
  • Re: Datasets - what is the best approach?
    ... I seem to still be struggling with the best place to declare the DataAdapter ... > I try to retrieve only the data that is currently relevant to the task at hand. ... Crystal report projects with master/detail type ... It accesses data in an SQL Server database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: orchid database?
    ... applicable information is databased for each accession, ... The mother flasks have a barcode with the M-number, the accession number, ... on special labels using thermal transfer ribbon. ... information in the database, ...
    (rec.gardens.orchids)
  • Re: Help getting database into Word label template
    ... field/column, the Tab key still needs to be pressed ... I have a Word database that has 1500 mailing addresses. ... trying to create mailing labels ... when I choose Project Gallery: Labels: Mailing Label Wizard: ...
    (microsoft.public.mac.office.word)
  • Re: Macro for Error Message
    ... from jrisk at hsc dot wvu dot edu. Please let me know if you do not receive ... On the form, the textboxes are unbound. ... The database itself is really nothing more than an address book. ... are required to print mailing labels from this database. ...
    (microsoft.public.access.macros)