cannot update database primary key column

Question

0.00/5 (No votes)

See more:

I have a textbox that returns a value from a database this value is also my primary key column so i get the value from company which is my primary key i then update the value in the textbox when i press enter i run

C#

("UPDATE t_company SET Company_Name=@Company_Name where Company_Name=@Company_Name",mycon1)

the problem is it doesnt give me any errors but it does not update it in the database but if i change the value of @company to a fixed value

C#

("UPDATE t_company SET Company_Name=@Company_Name where Company_Name='abc'",mycon1)

it then works
any help would be appreciated.

Posted 9-Oct-12 22:05pm

mrDivan

Updated 9-Oct-12 22:08pm

VIPR@T

v2

Add a Solution

2 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)

vasim sajad · Answer 1 · 2012-10-09T22:50:00

Solution 2

u should set company primary key too
update query will update which column u specified only
u didn't mentioned the primary key column name to update

("UPDATE t_company SET Company_Id=@Company_Id,Company_Name=@Company_Name where Company_Name=@Company_Name",mycon1)

Posted 9-Oct-12 22:50pm

vasim sajad

Comments

mrDivan 11-Oct-12 4:19am

Im sorry I dont understand could you give me an example

vasim sajad 11-Oct-12 5:54am

tell me ur table structure of t_company and which column is primary key ?

mrDivan 11-Oct-12 7:54am

i have 11 columns and company_name is my primary key

Mohd. Mukhtar · Answer 2 · 2012-10-09T22:11:00

Solution 1

In your previous query you are not updating anything.

See your query

SQL

UPDATE t_company SET Company_Name=@Company_Name where Company_Name=@Company_Name

It means you are updating Company name with the same value. Hence you are not observing change.

Posted 9-Oct-12 22:11pm

Mohd. Mukhtar

Updated 9-Oct-12 22:26pm

v2

Comments

ridoy 10-Oct-12 4:26am

right..+5