private void Connect_Btn_Click(object sender, EventArgs e) { string connectionString = string.Format("Data Source={0};Initial Catalog={1};User ID={2};Password={3};", Server_cmbBox.Text, Database_TxtBox.Text, Username_TxtBox.Text, Password_TxtBox.Text); try { SqlHelper helper = new SqlHelper(connectionString); if (helper.IsConnection) { StartForm.showBalloon("Sql Connection", "connection succeeded..."); StartForm.ConnectionString_main = connectionString; connectionString = string.Format("metadata=res://*/myModel.csdl|res://*/myModel.ssdl|res://*/myModel.msl;provider=System.Data.SqlClient;provider connection string="data source={0};initial catalog={1};persist security info=True;user id={2};password={3};MultipleActiveResultSets=True;App=EntityFramework"", Server_cmbBox.Text, Database_TxtBox.Text, Username_TxtBox.Text, Password_TxtBox.Text); AppSetting setting = new AppSetting(); string apps = setting.GetConnectionString("EmployeeCardentities"); setting.SaveConnectionString("EmployeeCardentities", connectionString); StartForm.showBalloon("App Config", "Your connection string has been successfully saved."); apps = setting.GetConnectionString("EmployeeCardentities"); this.Hide(); pass form = new pass(); form.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
static void Main(string[] args) { AppSetting appconfig = new AppSetting("appsettings.json"); AbsMqttBase.SetDefaultLoggerName("nlog.config", true); string mysql_connectionString = appconfig.GetConnectionString("peiudb"); ISessionFactory sessionFactory = CreateSessionFactory(mysql_connectionString, appconfig.GetAssembly()); var redisConfiguration = appconfig.GetSection <RedisConfiguration>("redis"); ConnectionMultiplexer conn = ConnectionMultiplexer.Connect(redisConfiguration.ConfigurationOptions); // NLog: setup the logger first to catch all errors NLog.LogManager.Configuration = new NLog.Config.XmlLoggingConfiguration("nlog.config"); Console.CancelKeyPress += Console_CancelKeyPress; EventSubscribeWorker worker = new EventSubscribeWorker(sessionFactory, conn); CancellationToken token = cancellationTokenSource.Token; worker.Initialize(); while (true) { try { token.ThrowIfCancellationRequested(); Task workTask = worker.MqttSubscribeAsync(token); workTask.Wait(); Task.Delay(100); } catch (Exception ex) { } } }
public LayoutDetails() { int _conTimeOut = 300; DataExecutor.ConnectionString = AppSetting.GetConnectionString(string.Empty, ref _conTimeOut); DataExecutor.ConnectionTimeout = _conTimeOut; }
private void FormAturan_Load(object sender, EventArgs e) { this.url = setting.GetConnectionString("api"); var parser = new FileIniDataParser(); IniData data = parser.ReadFile("app.ini"); this.id = data["Sekolah"]["IDSekolah"]; this.nama = data["Sekolah"]["NamaSekolah"]; this.lokasi = data["Sekolah"]["LokasiSekolah"]; this.mesin = data["Sekolah"]["SupportMesin"]; _ = GetKantorAsync(); }
/// <summary> /// 获取数据库连接 /// </summary> /// <returns></returns> public static IDbConnection CreateConnection() { IDbConnection connection = null; //获取配置进行转换 var type = AppSetting.GetConfig("ComponentDbType"); var dbType = GetDataBaseType(type); //DefaultDatabase 根据这个配置项获取对应连接字符串 var database = AppSetting.GetConfig("DefaultDatabase"); if (string.IsNullOrEmpty(database)) { database = "sqlserver";//默认配置 } // var strConn = AppConfig.Configuration.GetConnectionString(database); var strConn = AppSetting.GetConnectionString(database); switch (dbType) { case DatabaseType.SqlServer: connection = new System.Data.SqlClient.SqlConnection(strConn); break; case DatabaseType.MySql: // connection = new MySql.Data.MySqlClient.MySqlConnection(strConn); break; case DatabaseType.Npgsql: // connection = new Npgsql.NpgsqlConnection(strConn); break; case DatabaseType.Sqlite: // connection = new SQLiteConnection(strConn); break; case DatabaseType.Oracle: // connection = new Oracle.ManagedDataAccess.Client.OracleConnection(strConn); //connection = new System.Data.OracleClient.OracleConnection(strConn); break; case DatabaseType.DB2: //connection = new System.Data.OleDb.OleDbConnection(strConn); break; } return(connection); }
public FormProsesUploadPegawaiKeWeb() { InitializeComponent(); this.url = setting.GetConnectionString("api"); try { var parser = new FileIniDataParser(); IniData data = parser.ReadFile("app.ini"); this.kantor = data["Sekolah"]["IDSekolah"]; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public CommonDetails() { DataExecutor.ConnectionString = AppSetting.GetConnectionString(string.Empty); }
public ZodiacWebDetails() { DataExecutor.ConnectionString = AppSetting.GetConnectionString(string.Empty); }