Not saving to database

Question

1.00/5 (1 vote)

See more:

I am working on a project for the company where I should be able to save a customers information to the database and load it with the rest. What happens is that I put in the information, saves in the datatable, but doesn't save to the database. Now one would say there's something wrong with the code, but here's the pain: I'm using VS2008 and SQL2005 and facing this issue. However, my coworker is using SQL2008 and yet the code is working perfectly on his machine. What is the problem and how can I solve it? Thank you

Posted 4-Sep-11 19:34pm

ExoticmE

Add a Solution

3 solutions

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)

Wendelius · Answer 1 · 2011-09-04T20:31:00

Without any more information, it's merely guessing, but few things you should try:
- using debugger go through the code and check that the insert is actually executed and no error is generated
- check that you're using the correct database
- if the database is attached when the application runs, check that compiling doesn't overwrite the database files
- check that transactions are committed before closing the connection
- and if you have standard or enterprise edition of Sql Server, use Profiler to see what's happening on the Sql Server side.

Tejas Vaishnav · Answer 2 · 2011-09-04T19:54:00

Solution 1

Hello friend....!!!

If your code is work perfectly on your coworkers system then something wrong on your system...

Posted 4-Sep-11 19:54pm

Tejas Vaishnav

ExoticmE · Answer 3 · 2011-09-04T19:56:00

Solution 2

Like what exactly could it be? I have VS2008 and SQL2005 SP4 installed.

Posted 4-Sep-11 19:56pm

ExoticmE