Click here to Skip to main content
13,044,584 members (62,615 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I created an access database and now I want to add some data into it using C# but when I close my app,my data gone!

Now How can I stanch my data into database using C#!!!

for example I have some name like: Name:

now I want add the name "Amir" into name in database and I want to look it into my field...

help me!

Posted 18-Sep-12 4:21am
Updated 18-Sep-12 5:17am
Kschuler 18-Sep-12 10:33am
Post the code you are using to add the data and we can help you find any problems in the code. Also, what kind of project is this for? Website, Windows Forms, etc? How do you connect to the database?
amir.nazarizadeh 18-Sep-12 10:55am
excuse me!
it's windows form and I want code for add my new data into database!
Killzone DeathMan 18-Sep-12 10:35am
One day I have the same problem...
Right click on the database -> Properties and there is about three options like:
"Copy Always"
"Copy if newer"
"Not Copy"
Something like that, and you put: "Copy if newer"!
Kschuler 18-Sep-12 10:52am
You should post this as a possible solution, instead of just a comment.
Killzone DeathMan 18-Sep-12 16:56pm
I dont care about the reputation points in this site, I only care about programming experience...
Have a nice day!
Kschuler 18-Sep-12 17:02pm
I was more concerned about others who may search through these question/answers with similar problems. But whatever. Looks like the OP found something that worked. :)
amir.nazarizadeh 19-Sep-12 0:06am
your answer is the best Killzone!
thanks and thanks.
have a nice day.
amir.nazarizadeh 18-Sep-12 10:58am
thanks a lot Killzone.
that was nice but I want to copy my new data into database's field...
for example I have some name like:


now I want add the name "Amir" into name in database and I want to look it into my field...
Killzone DeathMan 18-Sep-12 16:57pm
You are welcome! :)
I you want something, let me know!
sjelen 18-Sep-12 10:49am
Make sure the database isn't open in Access when your application is running.
It will lock the file and prevent writing data from your app.
Wes Aday 18-Sep-12 11:23am
If your data is coming up missing then either you are not writing it to begin with or you are copying over your database. And I do not see what the problem is with writing a name to your database. What exactly is the issue?
amir.nazarizadeh 18-Sep-12 11:29am
think you have some name default
now you want to add a new name into the field,
it creates but it doesn't show into the database
Wes Aday 18-Sep-12 11:38am
"it creates but it doesn't show into the database" and that means what exactly? Is it writing to the database or not?
Meysam Tolouee 18-Sep-12 11:54am
Your sentence doesn't make sense at all.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Where do you have your database: in the project folder?
If yes, move your database in to another folder.

BTW: Name is a reserved word in MS Access. Never use it as the name of column.

More about reserved words at:[^][^]
Sandeep Mewara 18-Sep-12 12:09pm
Yep. My 5!
losmac 18-Sep-12 12:12pm
Thank you, Sandeep ;)
amir.nazarizadeh 18-Sep-12 13:41pm
no no,,,"name" is an example,I didn't use it!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100