Database Confusion

Question

I connected to an Access Database for my C# application which went well and the database was automatically copied to my Root colder which is in Documents/VisualStudio2010/Projects. When I created a Dataset it was automatically copied to Documents/VisualStudio2010/Projects/Name of My Project/Name of My Project/bin/Debug.
Now I have two different database files in my project, the 1st which is in the project is where i can make changes and it will reflect in Visual Studio, the 2nd is where changes made in the Visual Studio reflect even though it doesnt in the dataset. Please I need help with understanding this weird situation.

Accepted Answer

Whenever you build the application, the database file will be replaced from your project directory to the bin directory.
If there is no changes in the database design, then no need to use  Copy Always  option, use Copy if newer  option in the copy to output directory.

Christian Nwamba · Answer

It appears in the database in the bin directory but after sometimes i wont be able to see the data again. Both in the database, the datasource and the data-form.
Which code do you need exactly, Sir....... Is the code behind the form that gets the data from the database.
This situation occurs not only with access database, i tried sql server using linq to sql and it still persisted.

Answer

What do you mean by disappears? The data are not getting saved in the database? Is it possible for you to upload your source code?

Christian Nwamba · Answer

YES SIR, PLEASE I NEED MORE INFO. After setting this the data viewers like data grid view and text boxes on my forms cannot hold data for a long time. it goes into the bin database and after a few moment maybe i re-design the form, the data disapears both from the database and the forms.
Thanks for your help, Sir.

Answer

Kindly refer the image. In visual studio, select your MS access file and right click -->properties.
Visual studio opens a window very similar the below one.
Select build action to None and Copy to output directory to Always.
Whenever your're compiling the application, the latest MS access file will be copied into your bin/debug directory.
During development, do not edit the ms access file which exists in bin\debug directory.
Please let me know, if you need further information.

Christian Nwamba · Answer

Sir/Ma... Am very grateful for your answer. Please if you can break it down better because i didn't really get what your answers mean. Thanks

Answer

For your development, always you have use  Documents/VisualStudio2010/Projects access file and don't use which is exists in bin/debug directory.
Right click on the access file in visual studio and click properties.
To copy content files to an output folder, you should verify Copy to output directory property of your ms access file to "Copy always"
It will copy the ms access file into the bin/debug directory.
Change this option according to your wish.