¡¼SqlConnection (.NET)

------------------------------------------------------------
standard security:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

------------------------------------------------------------
Standard Security alternative syntax

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

------------------------------------------------------------
Trusted Connection
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

------------------------------------------------------------
Trusted Connection alternative syntax
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;


------------------------------------------------------------
Connect via an IP address 
  
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; 

DBMSSOCN=TCP/IP. 
This is how to use TCP/IP instead of Named Pipes. 
At the end of the Data Source is the port to use. 
1433 is the default port for SQL Server. 
 

------------------------------------------------------------
Attach a database file on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;

------------------------------------------------------------
Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;


¡¼¡³¡µ¡º¡·¡ó¤jºõ²Å¸¹