Click here to Skip to main content
12,450,981 members (54,243 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# Access
Hi...
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:
-----
kirk
mohsen
john

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

help me!

thanks...
Posted 18-Sep-12 4:21am
Updated 18-Sep-12 5:17am
v3
Comments
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"!
Regards,
KZ
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!
KZ
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:

Name:
-----
kirk
mohsen
john

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!
Regards,
KZ
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?

1 solution

Rate this: bad
 
good
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:
http://support.microsoft.com/kb/286335[^]
http://office.microsoft.com/en-us/access-help/access-2007-reserved-words-and-symbols-HA010030643.aspx[^]
  Permalink  
Comments
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!
thanks.

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.160826.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2016
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