private void BuildConnectionString()
{
//MySql Connection String - Database=[DBNAME];Data Source=[HOSTNAME]:[PORT];User Id=[USERNAME];Password=[PASSWORD]
//SqlServer Connection String - Initial Catalog=[DBNAME];Data Source=[HOSTNAME]:[PORT];User Id=[USERNAME];Password=[PASSWORD]
//SqlServer Windows Auth - Initial Catalog=[DBNAME];data source=[HOSTNAME]:[PORT];Integrated Security=SSPI;
//Check the type of Database and use proper syntax
if (oDatabaseType == DatabaseTypes.SqlServer)
sConnectionString = "Initial Catalog=";
else if (oDatabaseType == DatabaseTypes.MySql)
sConnectionString = "Database=";
sConnectionString += sDatabase + ";";
sConnectionString += "Data Source=" + sHostname;
if (sPort != "")
sConnectionString += /*":" + sPort +*/ ";";
else
sConnectionString += ";";
//Check if Windows Authentication is selected
if (oDatabaseType == DatabaseTypes.SqlServer && sUsername == "" && sPassword == "")
{
sConnectionString += "Integrated Security=SSPI";
}
else
{
sConnectionString += "User Id=" + sUsername + ";";
sConnectionString += "Password=" + sPassword + ";";
}
}