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