/// <summary>
/// 从设置文件中加载数据库连接
/// </summary>
private void LoadConnectionFromFile()
{
try
{
Properties.Settings settings = new SocanCode.Properties.Settings();
if (!string.IsNullOrEmpty(settings.AccessConn))
{
accessConn1.ConnectionString = settings.AccessConn;
}
if (!string.IsNullOrEmpty(settings.SqlServerConn))
{
sqlConn1.ConnectionString = settings.SqlServerConn;
sqlConn1.IsSql2005 = settings.SqlServerType;
}
if (!string.IsNullOrEmpty(settings.MySqlConn))
{
mySqlConn1.ConnectionString = settings.MySqlConn;
}
tcDatabase.SelectedIndex = settings.DbType;
}
catch
{
// 加载失败无需操作
}
}
/// <summary>
/// 保存数据库连接到用户设置
/// </summary>
private void SaveConnectionToFile()
{
Properties.Settings setting = new SocanCode.Properties.Settings();
setting.DbType = tcDatabase.SelectedIndex;
setting.AccessConn = accessConn1.ConnectionString;
setting.SqlServerType = sqlConn1.IsSql2005;
setting.SqlServerConn = sqlConn1.ConnectionString;
setting.MySqlConn = mySqlConn1.ConnectionString;
setting.Save();
}
