Variable Used In DataSource C#

I have the following code but it seems to not connect, just wondering whether i'm referring to the variable wrong?

sqlConnectionNW.ConnectionString = "Data Source=@server;Initial Catalog=Northwind;Integrated Security=True";

When I change it to:

sqlConnectionNW.ConnectionString = "Data Source=ISSP\SQLEXPRESS;Initial Catalog=Northwind;Integ开发者_如何学JAVArated Security=True";

It works fine. It's just when I change it to the variable 'server'.

---

It would be more like this:

string mySQLServer = "ISSP\SQLEXPRESS";

sqlConnectionNW.ConnectionSTring = "Data Source=" + mySQLServer + ";Initial Catalog=Northwind;Integrated Security=True";

---

when you write something between "" it's recognized as a string, to use a variable you have to write it outside of the ""'s and with a + before it.if some more variable or string is coming behind you must use another + after your variable.

"Data Source=" +variblename+ ";Initial Catalog=Northwind;Integrated Security=True"

---

You can't have a variable like that in the connection string. You need to do any replacements before using the connection string.

---

you could use string.format(), this will allow you to use the variable

sqlConnectionNW.ConnectionString = string.format("Data Source={0};Initial Catalog=Northwind;Integrated Security=True",server)

---

You maybe better off using the SqlConnectionStringBuilder class Sql Connection String Builder

This may allow you to generate the connection string in way more meaningful to you