private void btnSave_Click(object sender, EventArgs e) { try { var db = new FormDbService.DbInfo(); db.Id = Convert.ToInt32(txtId.Text); db.Server = TxtSqlServer.Text; db.UserName = TxtSqlUserName.Text; db.Password = TxtSqlPwd.Text; db.Database = TxtSqlDataBase.Text; if (db.Server.Length == 0 || db.UserName.Length == 0 || db.Password.Length == 0 || db.Database.Length == 0) { MessageBox.Show("抱歉,以上所有项均不能为空!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } btnSave.Enabled = false; string connection = GetConnectionString(); var thread = new Thread(() => { UpdateUI(() => { lblStatus.Text = "测试连接中,请稍后..."; }); if (CheckConnection(connection)) { FormDbService.EditDb(db); UpdateUI(() => { lblStatus.Text = ""; btnSave.Enabled = true; MessageBox.Show("操作成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); }); } else { UpdateUI(() => { lblStatus.Text = ""; btnSave.Enabled = true; MessageBox.Show("抱歉,数据库连接失败,数据未保存\n请检查配置参数准确性后再试!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); }); return; } UpdateUI(() => { btnSave.Enabled = true; Bind(); }); }); thread.IsBackground = true; thread.Start(); } catch (Exception ex) { MessageBox.Show("操作异常:" + ex, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void InitAdd() { var db = new FormDbService.DbInfo(); txtId.Text = db.Id.ToString(); TxtSqlServer.Text = db.Server; TxtSqlDataBase.Text = db.Database; TxtSqlUserName.Text = db.UserName; TxtSqlPwd.Text = db.Password; btnDel.Enabled = false; }