Sql parameter with a character single quote

put 2 : O''Neil

Thanks .Even combobox is having same problem

 CmbClinic.Text = StrClinic
strclinic =o'chp
is giving error

Context please? Where is this code?

A string has to be placed between delimiters (and those delimiters varies according to the language or tool. With some tools it would be:

strclinic ="o'chp"

Select allOpen in new window

I am loding combo boxes with the values from database.
The values are o'Abc ,h'uim when I try to set text property I get an error .

in vb.net? Which error? can you show more code because if your value containing a ' is in a variable, it should work.

CmbClinic.Text = StrClinic.ToString
            CmbClinicId.Text = StrClinicIdClinic.ToString
            CmbCurrClinic.Text = StrClinicCurr.ToString

 StrClinic.ToString =o'abc

Error :incorrect syntax in the string

1- can you confirm it is vb.net?

2- You cannot assign a value to .ToString as Tostring is a method and cannot receive a value

3- as already said, a string value needs to be enclosed between delimiters:

 StrClinic = "o'abc"

Select allOpen in new window

Yes, it is vb.net

what about the remaining of my comment?

Error is unclosed quotation mark after  'O'

how o assign it to delimiter

This worked but CmbClinic.Text = StrClinic.Replace("'", "''")
but displaying O''Abc as combobox text rather than O'Abc

you are not showing complete code! How am I supposed to guess what you are doing and what is your code? I have provided code that I know is working (StrClinic = "o'abc") and I don't event if you are using it and where you are using it.

I am more than please to help you but you really need to help me back!

And BTW, a delimiter is a character used to surround a string value which in this case is the "

>>This worked but CmbClinic.Text = StrClinic.Replace("'", "''")
>>but displaying O''Abc as combobox text rather than O'Abc

In this specific scenario, you don't need to double the quote. it should only be:

CmbClinic.Text = StrClinic

Select allOpen in new window

Eric,

CmbClinic.Text = StrClinic this gives the above error .

Eric,
Apologies for the above comment.It did work .Thanks a ton.
Don't what happened but rebuid solved it .

You are Genius.Yes,Figured it out it had a seelcted index chaged event which was firing a query to the database.
Fixed it .