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