private void frmDBConfig_Load(object sender, EventArgs e)
{
System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
// Main DB Config
txtMainHost.Text = config.AppSettings.Settings["mainhost"].Value;
txtMainUser.Text = config.AppSettings.Settings["mainuser"].Value;
txtMainPass.Text = config.AppSettings.Settings["mainpassword"].Value;
txtMainDB.Text = config.AppSettings.Settings["maindatabase"].Value;
// Config DB Config
txtConfigHost.Text = config.AppSettings.Settings["confighost"].Value;
txtConfigUser.Text = config.AppSettings.Settings["configuser"].Value;
txtConfigPass.Text = config.AppSettings.Settings["configpassword"].Value;
txtConfigDB.Text = config.AppSettings.Settings["configdatabase"].Value;
// Astro Config
txtAstroHost.Text = config.AppSettings.Settings["astromechhost"].Value;
txtAstroUser.Text = config.AppSettings.Settings["astromechuser"].Value;
txtAstroPass.Text = config.AppSettings.Settings["astromechpassword"].Value;
txtAstroDB.Text = config.AppSettings.Settings["astromechdatabase"].Value;
// Log DB Config
txtLogHost.Text = config.AppSettings.Settings["loghost"].Value;
txtLogUser.Text = config.AppSettings.Settings["loguser"].Value;
txtLogPass.Text = config.AppSettings.Settings["logpassword"].Value;
txtLogDB.Text = config.AppSettings.Settings["logdatabase"].Value;
// Tool DB Config
txtToolsHost.Text = config.AppSettings.Settings["toolshost"].Value;
txtToolsUser.Text = config.AppSettings.Settings["toolsuser"].Value;
txtToolsPass.Text = config.AppSettings.Settings["toolspassword"].Value;
txtToolsDB.Text = config.AppSettings.Settings["toolsdatabase"].Value;
// Archive DB Config
txtArchiveHost.Text = config.AppSettings.Settings["archivehost"].Value;
txtArchiveUser.Text = config.AppSettings.Settings["archiveuser"].Value;
txtArchivePass.Text = config.AppSettings.Settings["archivepassword"].Value;
txtArchiveDB.Text = config.AppSettings.Settings["archivedatabase"].Value;
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");
}