quotation marks in string - how to add

[Ufit]

Simple,dumm question - how to include quotation marks in the string?
F.ex. "Data Source=.\SQLEXPRESS;AttachDbFilename="C:\client data.mdf";Integrated Security=True;User Instance=True"
I get syntax error.
Thanks for help

Ufi

 

[Marina Levit [MVP]]

You put them in twice. So something like:

Dim s as String = "Double quotes around test: ""test"""

 

[Jim Wooley]

Another option:
String.Format("Data Source=.\SQLEXPRESS;AttachDbFilename={0}C:\client
data.mdf{0};Integrated Security=True;User Instance=True", ControlChars.Quote)
Jim Wooley
http://devauthority.com/blogs/jwooley/default.aspx

 

[Herfried K. Wagner [MVP]]

Simple,dumm question - how to include quotation marks in the string?
F.ex. "Data Source=.\SQLEXPRESS;AttachDbFilename="C:\client
data.mdf";Integrated Security=True;User Instance=True"
I get syntax error.

Encode each quotation mark that should appear in the string as two
consecutive quotation marks:

\\\
s = "He said ""Hello World!"""
///