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

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

Mohd. Mukhtar · Answer 1 · 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

vasim sajad · Answer 2 · 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

cannot update database primary key column

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

cannot update database primary key column

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us