problem with add,update and delete

Question

1.00/5 (2 votes)

See more:

hi all
i making program using c# and sql server database,the main process add,update and delete
all the process ok but when i make publish for project and setup in another pc then return to edit in program in c#
the function add do not add to database and the update do not update in data in database also delete and no error
i do not know what is the wronge

Posted 24-Sep-12 9:48am

shimaa010

Add a Solution

Comments

Richard C Bishop 24-Sep-12 15:49pm

You need to post the code you have, no one can read your mind or see your computer.

[no name] 24-Sep-12 15:52pm

Please try to run fresh copy of your application and then try again .

O u can Past Code here....so that i can help you better

[no name] 24-Sep-12 15:54pm

or put check point on add function

supernorb 24-Sep-12 16:41pm

It seems that you have some problem in connection string which involves the server name, the server name may also involve the computer name and that's why changing the computer can make your program not work. As others suggested, you should post some of your code in which you think the problem might be.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 24-Sep-12 23:18pm

Yes this may be the case...

Ran 2 25-Sep-12 1:11am

post your connection string to get proper support.

shimaa010 25-Sep-12 1:35am

my connection string
internal static string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\ProjectsDB.mdf;Integrated Security=True;User Instance=True;";

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)

Albarhami · Answer 1 · 2012-09-24T21:59:00

Solution 1

Check you connection string to the database and make sure that you write the correct server name i.e. your pc name will change from computer to computer and therefore you are getting the errors due to incorrect path to database.

Posted 24-Sep-12 21:59pm

Albarhami