// SQL server Authentication connection string
Private string ConnstrSqlServer = "server = server name; uid = login name; pwd = login password; database = database name ";
// Windows Authentication connection string
Private string ConnstrWindows = "server = server name; database = database name; Trusted_Connection = SSPI ";
// Access the SQL Server 2008 database using SqlClient in C # code
//. NET Framework Data Provider for SQL Server standard syntax
Data Source = myServerAddress; Initial Catalog = myDataBase; User Id = myUsername; Password = myPassword;
// Another standard method for. NET Framework Data Provider for SQL Server
Server = myServerAddress; Database = myDataBase; User ID = myUsername; Password = myPassword; Trusted_Connection = False;
//. NET Framework Data Provider for SQL Server Trust connection statement
Data Source = myServerAddress; Initial Catalog = myDataBase; Integrated Security = SSPI;
//. NET Framework Data Provider for SQL Server
Server = myServerAddress; Database = myDataBase; Trusted_Connection = True;