private void btnTestConnection_Click(object sender, EventArgs e) { try { if (checkData()) { ThreadPool.QueueUserWorkItem(o => { DbConfigInfo dbConfigInfo = getDbConfigInfo(); string conString = dbConfigInfo.ConnectionString.Trim(new char[] { '"' }); string dbProvider = DBType.GetDbProviderString(dbConfigInfo.DbType); DNCCFrameWork.DataAccess.IDbHelper db = new DNCCFrameWork.DataAccess.DbFactory(conString, dbProvider). IDbHelper; bool success = db.TestConnection(); string tip = "数据库连接失败"; if (success) { tip = "数据库连接成功"; } MessageBox.Show(this, tip, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); }); } } catch (System.Data.Common.DbException ex) { MessageBox.Show(this, ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
private void execute() { try { DNCCFrameWork.DataAccess.IDbHelper db = new DNCCFrameWork.DataAccess.DbFactory( gt.dbConnectionString.Trim(new[] { '"' }), DBType.GetDbProviderString(gt.dbType)).IDbHelper; string[] sql = tbScript.Text.Split(new[] { "--MQ TG" }, StringSplitOptions.RemoveEmptyEntries); if (gt.OriginalEncoding != null && gt.TargetEncoding != null) { foreach (string str in sql) { if (!string.IsNullOrEmpty(str)) { db.ExecuteNonQuery(str); } } } MessageBox.Show(this, "执行成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(this, "执行失败[" + ex.Message + "]", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void execute() { try { bool flag = false; string temp = tbComment.Text.Trim(); if (!string.IsNullOrEmpty(temp)) { DataRow[] drs = sc.dsTable.Tables[sc.dbName + sc.DBtable].Select("name = '" + tableInfo.TableName + "'"); if (drs != null && drs.Length > 0) { drs[0]["comments"] = temp; flag = true; DBFileHelper.WriteXml(sc.dsTable); } } foreach (ColumnInfo column in tableInfo.Columns) { if (column.IsChanged) { temp = column.Comments; DataRow[] drs = sc.dsTableColumn.Tables[sc.dbName + sc.DBtablesColumns].Select("TABLE_NAME = '" + tableInfo.TableName + "' and COLUMN_NAME = '" + column.Name + "'"); drs[0]["COMMENTS"] = temp; flag = true; DBFileHelper.WriteXml(sc.dsTableColumn); } } if (flag && cbExecuteDB.Checked) { DNCCFrameWork.DataAccess.IDbHelper db = new DNCCFrameWork.DataAccess.DbFactory( sc.dbConnectionString.Trim(new[] { '"' }), DBType.GetDbProviderString(sc.dbType)) .IDbHelper; string[] sql = createCommentSql().Split(new[] { ";" }, StringSplitOptions.RemoveEmptyEntries); foreach (var s in sql) { if (!string.IsNullOrEmpty(s)) { string t = s.Trim(new[] { '\t', '\r', '\n', ' ', ';' }); if (sc.OriginalEncoding != null && sc.TargetEncoding != null) { t = EncodingHelper. ConvertEncoder(sc.TargetEncoding, sc.OriginalEncoding, t); } if (!string.IsNullOrEmpty(t)) { db.ExecuteNonQuery(t); } } } } MessageBox.Show(this, "执行成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(this, "执行失败[" + ex.Message + "]", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }