error caused by text containing hyphen

Accepted 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 + "%'");

Vulpes13y ago

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 kakuru13y ago

Thanks alot Vulpes it has worked perfectly.

Marvin kakuru13y ago

your right vulpes it is an apostrophe, i am still getting the error.
below is my sting b4 i add the double apostrophes.

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 kakuru13y ago

right

Vulpes13y ago

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.