/// <summary>
/// 保存数据库连接到用户设置
/// </summary>
private void SaveConnectionToFile()
{
Config.History history = Config.History.Load();
switch (tcDatabase.SelectedIndex)
{
case 0:
history.DatabaseType = Model.DatabaseTypes.Access;
history.AccessConn = accessConn1.ConnectionString;
break;
case 2:
history.DatabaseType = Model.DatabaseTypes.MySql;
history.MySqlConn = mySqlConn1.ConnectionString;
break;
case 3:
history.DatabaseType = Model.DatabaseTypes.Oracle;
history.OracleConn = oracleConn1.ConnectionString;
break;
case 4:
history.DatabaseType = Model.DatabaseTypes.SQLite;
history.SQLiteConn = sqLiteConn1.ConnectionString;
break;
case 1:
default:
history.DatabaseType = sqlConn1.IsSql2005 ? Model.DatabaseTypes.Sql2005 : Model.DatabaseTypes.Sql2000;
history.SqlServerConn = sqlConn1.ConnectionString;
break;
}
Config.History.Save(history);
}
/// <summary>
/// 从设置文件中加载数据库连接
/// </summary>
private void LoadConnectionFromFile()
{
try
{
Config.History history = Config.History.Load();
if (!string.IsNullOrEmpty(history.AccessConn))
{
accessConn1.ConnectionString = history.AccessConn;
}
if (!string.IsNullOrEmpty(history.SqlServerConn))
{
sqlConn1.ConnectionString = history.SqlServerConn;
sqlConn1.IsSql2005 = history.DatabaseType == Model.DatabaseTypes.Sql2005;
}
if (!string.IsNullOrEmpty(history.MySqlConn))
{
mySqlConn1.ConnectionString = history.MySqlConn;
}
if (!string.IsNullOrEmpty(history.OracleConn))
{
oracleConn1.ConnectionString = history.OracleConn;
}
if (!string.IsNullOrEmpty(history.SQLiteConn))
{
sqLiteConn1.ConnectionString = history.SQLiteConn;
}
switch (history.DatabaseType)
{
case Model.DatabaseTypes.Access:
tcDatabase.SelectedIndex = 0;
break;
case Model.DatabaseTypes.MySql:
tcDatabase.SelectedIndex = 2;
break;
case Model.DatabaseTypes.Oracle:
tcDatabase.SelectedIndex = 3;
break;
case Model.DatabaseTypes.SQLite:
tcDatabase.SelectedIndex = 4;
break;
case Model.DatabaseTypes.Sql2000:
case Model.DatabaseTypes.Sql2005:
default:
tcDatabase.SelectedIndex = 1;
break;
}
}
catch
{
// 加载失败无需操作
}
}