Add data into a access database!

Question

2.33/5 (3 votes)

See more:

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

amir.nazarizadeh

Updated 18-Sep-12 5:17am

v3

Add a Solution

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.

[no name] 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

[no name] 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?

[no name] 18-Sep-12 11:54am

Your sentence doesn't make sense at all.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Accepted Answer · 2012-09-18T05:54:00

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[^]

Posted 18-Sep-12 5:54am

Maciej Los

Comments

Sandeep Mewara 18-Sep-12 12:09pm

Yep. My 5!

Maciej Los 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.