private void ConDbForm_FormClosed(object sender, FormClosedEventArgs e) { if (Conn != null) { //测试连接 SqlHelper sqlHelper = new SqlServerHelper(connectionString); var flag = sqlHelper.ConnectionTest(connectionString); if (flag) { //保存配置 saveConfig(); parent.CurConn = Conn; parent.BindTreeView(); } else { MessageBox.Show("连接失败"); } } }
private void btnTest_Click(object sender, EventArgs e) { if (String.IsNullOrWhiteSpace(txtDataSource.Text.Trim())) { MessageBox.Show("服务器名称不能为空"); return; } if (String.IsNullOrWhiteSpace(txtDbName.Text.Trim())) { MessageBox.Show("数据库名称不能为空"); return; } if (String.IsNullOrWhiteSpace(txtUserId.Text.Trim())) { MessageBox.Show("用户名不能为空"); return; } if (String.IsNullOrWhiteSpace(txtPassword.Text.Trim())) { MessageBox.Show("密码不能为空"); return; } //测试连接 connectionString = String.Format("data source={0};initial catalog={1};user id={2};password={3};", txtDataSource.Text.Trim(), txtDbName.Text.Trim(), txtUserId.Text.Trim(), txtPassword.Text.Trim()); SqlHelper sqlHelper = new SqlServerHelper(connectionString); var flag = sqlHelper.ConnectionTest(connectionString); btnTest.Text = flag ? "连接成功" : "连接失败"; if (flag) { //保存配置 saveConfig(); } btnTest.Enabled = false; txtFlowCode.Focus(); }