public static string GetConstring(DBConfig db) { if (db.ProviderName == "SQL") { StringBuilder sb = new StringBuilder(); sb.Append("Data Source=" + db.ServerName); sb.Append(";Initial Catalog=" + db.DataBase + " ; "); if (db.ValidataType == "Windows身份认证") { //sb.Append("Integrated Security=SSPI;"); sb.Append("Integrated Security=SSPI;Connect Timeout=10000"); } else { sb.Append("User ID=" + db.UserName + ";Password="******";"); } return(sb.ToString()); } else { StringBuilder sb = new StringBuilder(); sb.Append("Provider=Microsoft.Ace.OleDb.12.0"); sb.Append(";Data Source= " + db.DataBase); sb.Append(";Persist Security Info=False;"); return(sb.ToString()); } }
public static string GetSQLmasterConstring(DBConfig db) { StringBuilder sb = new StringBuilder(); sb.Append("Data Source=" + db.ServerName); sb.Append(";Initial Catalog=master ;"); if (db.ValidataType == "Windows身份认证") { sb.Append(" Integrated Security=SSPI;"); } else { sb.Append("User ID=" + db.UserName + ";Password="******";"); } return(sb.ToString()); }