Solved

Updating Access database with dataset

Posted on 2014-11-11
2
129 Views
Last Modified: 2014-11-11
Experts, I have a database that I pull some records from when my application begins into a Dataset. Throughout the use of the application the data is used by the user. When the application closes I would like to update the database with the data in the dataset. I have looked at the update method but it seems I need for the Dataadapter to be hanging around to do this. I dispose of the Dataadapter after I retrieve the records I need when the application starts. How can I do this?
0
Comment
Question by:Basicfarmer
2 Comments
 
LVL 62

Accepted Solution

by:
Fernando Soto earned 500 total points
ID: 40436601
Do not dispose of the DataAdapter which is needed later for updating.
0
 

Author Closing Comment

by:Basicfarmer
ID: 40436604
That's what I thought you were going to say. Thanks as always...
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now