MySQL Update Query not working and not updating records

Question

I have a tablestuidstunamestuage the first stuid is auto increment column 1 nnnnnn 252 sssssss 233 vail       22  CodeOleDbCommand cmd  new OleDbCommand34update bannerdetails set bannername3934  textslidenameText  3439bannerimage3934  uploadPostedFileFileName  3439bannerlink3934  textslideurlText  3439 where id34  userid  3434 connnow i want to update the ssssss for 4 if u anty idea pls give me

Azim · Accepted Answer

You need to use Parameterized queries so that SQL Queries work properlyprotected void Saveobject sender EventArgs e     i have passed hard coded value here    int id  2    if thisFileUpload1HasFile            string constr  ConfigurationManagerConnectionStrings34ConString234ConnectionString        string sqlStatment  34update bannerdetails set bannername  BannerName bannerimage  Image bannerlink  BannerLink where id  Id34        using OleDbConnection con  new OleDbConnectionconstr                    using OleDbCommand cmd  new OleDbCommandsqlStatment con                            conOpen                cmdParametersAddWithValue34BannerName34 thistxtBannerNameTextTrim                cmdParametersAddWithValue34Image34 thisFileUpload1PostedFileFileName                cmdParametersAddWithValue34BannerLink34 txtBannerLinkText                cmdParametersAddWithValue34Id34

MySQL Update Query not working and not updating records

Company

Explore

Follow us

Contact Us