Results 1 to 2 of 2

Thread: Save dataset

  1. #1

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    Unhappy Save dataset

    I have a dataset which is not tied to a database in any way.

    It is created and populated in code.

    What i need to know is,

    How do I save the contents of this dataset into a table in Access?

    I have tried merge but I cant seem to get it to work "i'm an idiot".

    Are there any other approaches??

    Parksie

  2. #2
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    518
    Have you invoked .AcceptChanges at any point along the way in creating your dataset? If not then OleDbDataAdapter.Update should push your new records into the Access database, once you have the OleDbDataAdapter correctly associated with the database file.

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