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

You put them in twice. So something like:

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

"Ufit" <(E-Mail Removed)> wrote in message
news:e8gvt4$3nu$(E-Mail Removed)...
> 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

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

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

"Ufit" <(E-Mail Removed)> schrieb:
> 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!"""
///

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>