How can I get through the "'"

[Ivan V via DotNetMonster.com]

Dear All:

I got a problem a savinf problem about my data into sql server. If the
remarks filed include the "'" such as Chan's, Int'L, an error message will
pop up whixh is caused by the "'", anyone knows I can get this through???
Thanks!

 

[Cor Ligthert [MVP]]

Ivan,

I assume that you are not typing it directly into the SQL server, therefore
how do you do it.

In other words, what classes are you using, how does your insertstring look
like.

Cor

 

[Ivan V via DotNetMonster.com]

Hi Cor, thanks for that reply, in my case, for instance, in a taxt box, there
is a name "INT'L" in it and i am using sql command "insert into" and that's
where my problem appeared!

Ivan

 

[Cor Ligthert [MVP]]

Ivan,

Therefore are the parameters.
See this sample on our website.
http://www.windowsformsdatagridhelp.com/default.aspx?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

It is with the Fill however I assume that you can translate it to an update.
An even simpler sample is on the site with SQL.

(The datetime is used because that is mostly the most awfull one if you are
not living in the USA)

I hope this helps,

Cor

 

[Ivan V via DotNetMonster.com]

Hi Cor, seems that's the not sample that I am looking for. By the way, thanks
a lot!

 

[Oenone]

I got a problem a savinf problem about my data into sql server.
If the remarks filed include the "'" such as Chan's, Int'L, an error
message will pop up whixh is caused by the "'", anyone knows I can
get this through???

Replace each single-quote character with two single-quote characters in your
string, e.g.:

\\\
sql = "INSERT INTO YourTable "
sql &= "VALUES ('" & Replace(YourValue, "'", "''") & "')"
///

When SQL Server sees two single-quotes within a quoted string, it will
interpret them as a single single-quote within the value.

Hope that makes sense.

 

[Ivan V via DotNetMonster.com]

Thanks Oenone, it works well for me now.