conn.ConnectionString = @"Data Source=.\servername;database = DBNAME;Integrated security = true";你只要把servername 和 dbname換成自己的就行了如果這個你覺得不容易記憶，並且你使用的是C# 你可以用SqlConnectionStringBuilder 來構造連線串，肯定不會錯。 SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "servername"; builder.InitialCatalog = "DB name"; builder.IntegratedSecurity = true; //sql 認證 //builder.UserID = "username"; //builder.Password = "passward"; conn.ConnectionString = builder.ConnectionString;
conn.ConnectionString = @"Data Source=.\servername;database = DBNAME;Integrated security = true";你只要把servername 和 dbname換成自己的就行了如果這個你覺得不容易記憶，並且你使用的是C# 你可以用SqlConnectionStringBuilder 來構造連線串，肯定不會錯。 SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "servername"; builder.InitialCatalog = "DB name"; builder.IntegratedSecurity = true; //sql 認證 //builder.UserID = "username"; //builder.Password = "passward"; conn.ConnectionString = builder.ConnectionString;