/// <summary> /// 创建SQL连接对象 /// </summary> /// <returns></returns> public OracleConnection CreateConnection() { if (_sqlConfig == null) { _sqlConfig = new IniFileWriter(Application.StartupPath + DbConfiguration_Factory.INI_CFG_PATH); } return(CreateConnection(_sqlConfig)); }
/// <summary> /// 设置连接 /// </summary> /// <param name="config"></param> public static void SetSQLConfig(IWriteSQLConfigValue config) { if (DbType == DbAcessTyp.SQLServer) //SQL { new SqlConfiguration().SetSQLConfig(config); } else if (DbType == DbAcessTyp.Oracle) { new OraConfiguration().SetSQLConfig(config); } }
/// <summary> /// 获取连接 /// </summary> /// <param name="config"></param> /// <returns></returns> public static IDbConnection CreateConnection(IWriteSQLConfigValue config) { if (DbType == DbAcessTyp.SQLServer) //SQL { return new SqlConfiguration().CreateConnection(config); } else if (DbType == DbAcessTyp.Oracle) { return new OraConfiguration().CreateConnection(config); } return null; }
/// <summary> /// 获取连接 /// </summary> /// <param name="config"></param> /// <returns></returns> public static IDbConnection CreateConnection(IWriteSQLConfigValue config) { if (DbType == DbAcessTyp.SQLServer) //SQL { return(new SqlConfiguration().CreateConnection(config)); } else if (DbType == DbAcessTyp.Oracle) { return(new OraConfiguration().CreateConnection(config)); } return(null); }
/// <summary> /// 建立连接 /// </summary> public SqlConnection CreateConnection(IWriteSQLConfigValue config) { if (config == null) { throw new Exception("Program cann't run without a SQL configuration.You should config the SQL connection by running LZHBaseFrame.Tools.SqlConnector.exe!"); } string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password); SqlConnection conn = new SqlConnection(connstr); conn.Open(); return(conn); }
public static string GetConnString(IWriteSQLConfigValue cfg) { string sConn = ""; if (cfg.DbType == DbAcessTyp.SQLServer) { sConn = new SqlConfiguration().GetConnectionString(cfg); } else if (cfg.DbType == DbAcessTyp.Oracle) { sConn = new OraConfiguration().GetConnectionString(cfg); } return(sConn); }
private void btnConnect_Click(object sender, EventArgs e) { btnConnect.Enabled = false; try { string errMsg = string.Empty; label5.Visible = true; timer1.Start(); if (rbINI.Checked)//连接配置保存在INI文件 { _writer = new IniFileWriter(Application.StartupPath + SqlConfiguration.INI_CFG_PATH); } else//连接配置保存在注册表. Registry.LocalMachine根目录下 { _writer = new RegisterWriter(SqlConfiguration.REG_SQL_CFG); } SqlConnection conn = this.TestConnection(txtServerName.Text, txtDatabase.Text, txtUserName.Text, txtPwd.Text, ref errMsg); if (conn == null) { timer1.Stop(); label5.Visible = false; MessageBox.Show("Connecting to SQL Server failed.\n" + errMsg, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); } else //连接成功,保存连接参数 { _writer.ServerName = txtServerName.Text; _writer.UserName = txtUserName.Text; _writer.Password = txtPwd.Text; _writer.InitialCatalog = txtDatabase.Text; _writer.Write(); Successed = true; MessageBox.Show("Connect SQL Server successfully!", "Connect to Server", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); this.Close(); } } finally { timer1.Stop(); label5.Visible = false; btnConnect.Enabled = true; } }
/// <summary> /// 生成连接字符串 /// </summary> /// <param name="config">SQL配置策略</param> /// <returns></returns> public string GetConnectionString(IWriteSQLConfigValue config) { string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password); return(connstr); }
/// <summary> /// 设置SQL配置策略 /// </summary> /// <param name="config"></param> public static void SetSQLConfig(IWriteSQLConfigValue config) { _sqlConfig = config; }
/// <summary> /// 设置连接 /// </summary> /// <param name="config"></param> public static void SetSQLConfig(IWriteSQLConfigValue config) { if (DbType == DbAcessTyp.SQLServer) //SQL { new SqlConfiguration().SetSQLConfig(config); } else if (DbType == DbAcessTyp.Oracle) { new OraConfiguration().SetSQLConfig(config); } }
public static string GetConnString(IWriteSQLConfigValue cfg) { string sConn = ""; if (cfg.DbType == DbAcessTyp.SQLServer) { sConn = new SqlConfiguration().GetConnectionString(cfg); } else if (cfg.DbType == DbAcessTyp.Oracle) { sConn = new OraConfiguration().GetConnectionString(cfg); } return sConn; }
/// <summary> /// 设置SQL配置策略 /// </summary> /// <param name="config"></param> public void SetSQLConfig(IWriteSQLConfigValue config) { _sqlConfig = config; }
/// <summary> /// 生成连接字符串 /// </summary> /// <param name="config">SQL配置策略</param> /// <returns></returns> public string GetConnectionString(IWriteSQLConfigValue config) { string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password); return connstr; }
/// <summary> /// 建立连接 /// </summary> public SqlConnection CreateConnection(IWriteSQLConfigValue config) { if (config == null) throw new Exception("Program cann't run without a SQL configuration.You should config the SQL connection by running CSFramework.Tools.SqlConnector.exe!"); string connstr = string.Format(DEF_SQL_CONNECTION, config.ServerName, config.InitialCatalog, config.UserName, config.Password); SqlConnection conn = new SqlConnection(connstr); conn.Open(); return conn; }
/// <summary> /// 创建SQL连接对象 /// </summary> /// <returns></returns> public SqlConnection CreateConnection() { if (_sqlConfig == null) _sqlConfig = new IniFileWriter(Application.StartupPath + DbConfiguration_Factory.INI_CFG_PATH); return CreateConnection(_sqlConfig); }