error caused by text containing hyphen

Question

hi there, i am trying to search my database, but when i search a customer name for example ' Hellen's ' which contains a hyphen, i get a syntax error. can anyone me help out?

Vulpes · Answer

OK, Marvin, try this: string temp = textBox1.Text.Replace("'", "''"); string sqll = ("select uic,namehu,phyaddress,contactinfor,emaila,joinedon,expireson from clientinfor where namehu LIKE '%" + temp + "%' or phyaddress LIKE '%" + temp + "%' or uic LIKE '%" + temp + "%'");

Vulpes · Answer

Incidentally, you can always use the same code whether the string in the textbox contains apostrophes or not. If it doesn't, then Replace will have no effect.

Marvin kakuru · Answer

Thanks alot Vulpes it has worked perfectly.

Marvin kakuru · Answer

your right vulpes it is an apostrophe, i am still getting the error. below is my sting b4 i add the double apostrophes. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;} string sqll = ("select uic,namehu,phyaddress,contactinfor,emaila,joinedon,expireson from clientinfor where namehu LIKE '%" + textBox1.Text + "%' or phyaddress LIKE '%" + textBox1.Text + "%' or uic LIKE '%" + textBox1.Text + "%'"); thanks again man. marvin

Marvin kakuru · Answer

right

Vulpes · Answer

I take it you mean apostrophe rather than hyphen. When you search for a string s, say, try searching instead for: s.Replace("'", "''") In other words double the apostrophes.

error caused by text containing hyphen

Answers (6)