private void btnConnect_Click(object sender, EventArgs e) { if (CheckInput()) { try { var conBuilder = BuildConnection(); var sqlComment = "select 1 as value from sys.databases"; var sqlHelper = new Common.SqlHelper(); var result = sqlHelper.ExecuteScalar <int>(conBuilder.ToString(), sqlComment); if (result > 0) { WirteFle(); int dbId = 0; try { Common.DataService.SaveDataBase(conBuilder.DataSource, conBuilder.InitialCatalog); dbId = Common.DataService.GetDataBaseID(conBuilder.DataSource, conBuilder.InitialCatalog); } catch (Exception ex) { Logger.Error("保存登录的数据库信息失败", ex); } var mainFrom = new Main(conBuilder); mainFrom.LoginForm = this; mainFrom.StartPosition = FormStartPosition.CenterScreen; mainFrom.DataBaseID = dbId; mainFrom.Show(); this.Hide(); } else { MessageHelper.ShowMessage("连接数据库失败", "Waring"); } } catch (Exception ex) { Logger.Error("读取数据库信息失败", ex); MessageHelper.ShowMessage(ex.Message, "Error"); } } }
private void btnTest_Click(object sender, EventArgs e) { if (CheckInput()) { try { var conBuilder = BuildConnection(); var sqlComment = "select name as txt,name as value from sys.databases"; var sqlHelper = new Common.SqlHelper(); var dtDbs = sqlHelper.ExecuteQuery(conBuilder.ToString(), sqlComment); this.cboDataBases.DataSource = dtDbs; this.cboDataBases.DisplayMember = "text"; this.cboDataBases.ValueMember = "value"; MessageHelper.ShowMessage("连接成功"); } catch (Exception ex) { Logger.Error("读取数据库信息失败", ex); MessageHelper.ShowMessage(ex.Message, "Error"); } } }