Results 1 to 6 of 6

Thread: Dataset not reflecting Database field changes

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2002
    Posts
    15

    Dataset not reflecting Database field changes

    Hi.

    I am using a datset on a form that is bound to lots of controls. The dataset was added at design time.

    I have updated the definition of my Access database (new and changed fields) and now my Dataset does not reflect those changes.

    How do I refresh the dataset bits? I cannot find a way in the IDE of doing this.

    Many thanks

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    Rebuild the dataadapter and dataset.

  3. #3

    Thread Starter
    New Member
    Join Date
    Sep 2002
    Posts
    15
    Does that not mean that I need to reattach all the design time databindings?

  4. #4
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    I don't believe so. You don't have to delete the items just reconfigure the dataadapter. Then right click on it and generate the dataset, if you choose the same name as the existing one then it will ask if you want to overwrite it, choose yes.

  5. #5
    Frenzied Member DevGrp's Avatar
    Join Date
    Nov 2001
    Location
    Charlotte, NC
    Posts
    1,256
    There should be a way to just rebuild the DataSet to to get the new values from the DB.

  6. #6

    Thread Starter
    New Member
    Join Date
    Sep 2002
    Posts
    15
    Edneeis, thanks, I will try what you sugested.

    DevGrp, I agree but I am unable to find that option.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width