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());
}
