Click here to Skip to main content
15,353,970 members
Please Sign up or sign in to vote.
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
Updated 9-Oct-12 22:08pm
v2

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.
   
v2
Comments
ridoy 10-Oct-12 4:26am
   
right..+5
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)
   
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

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900