-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by rockythree
-
-
hi all,I'm a student and my major is Information TechnologyI'm cool and want to learn more in IT thanks
hi all,I'm a student and my major is Information TechnologyI'm cool and want to learn more in IT thanks
Update String sql server
in SQL
Posted
Hi there, How are you? I hope you are well. I am developing a program in C# and it's about Business card so whenever I receive a business card I can save it through this application. So I have an issue with the update string it gives me this error:- Invalid column name 'PlaceOfWork' Invalid coulumn name 'POBox'.And here is the String String sql = "update BusinessCard set EmployeeName = '" + txt_Name.Text + "', Rank= '" + txt_Rank.Text + "',mobilePhone= '" + txt_mobilePhone.Text + "',MobilePhone='" + txt_phone.Text + "',Fax ='" + txt_Fax.Text + "',Email='" + txt_email.Text + "',PlaceOfWork='" + txt_plcOfWrk.Text + "',POBox='" + txt_POBox.Text + "',Address='" + txt_address.Text + "'where ID = " + txt_ID.Text; any Help you could Provide in this matter would be greatly appreciate it. best regards