public override bool Connect() { bool opened = true; if (this.Connection == null || this.Connection.State == ConnectionState.Closed) { if (this.Connection != null) { this.Connection.Close(); this.Connection = null; } MySqlConnectionStringBuilder connectionBuilder = new MySqlConnectionStringBuilder { Server = this.Settings.Hostname, Port = this.Settings.Port != null ? this.Settings.Port.Value : 0, Database = this.Settings.Database, UserID = this.Settings.Username, Password = this.Settings.Password, UseCompression = true }; try { this.Connection = new MySqlConnection(connectionBuilder.ToString()); this.Connection.Open(); if (this.Connection.State != ConnectionState.Open) { this.Connection.Close(); this.Connection = null; } } catch { opened = false; } } return opened; }
public DbConnection CreateConnection(string nameOrConnectionString) { var connectionBuilder = new MySqlConnectionStringBuilder(_baseConnectionString); connectionBuilder.Database = nameOrConnectionString; return new MySqlConnection(connectionBuilder.ToString()); }
public static void Command(string command) { try { var connstring = new MySqlConnectionStringBuilder { Server = meh.Default.MysqlHost, UserID = meh.Default.MysqlUsername, Password = meh.Default.MysqlPassword, Database = meh.Default.MysqlDatabase }; var connection = new MySqlConnection(connstring.ToString()); LogWriter.WriteLine(@"opening connection to mysql"); connection.Open(); LogWriter.WriteLine(@"connection successful!"); var sqlcommand = new MySqlCommand(command, connection); LogWriter.WriteLine(@"Running sql command"); sqlcommand.ExecuteNonQuery(); LogWriter.WriteLine(@"Sql Command finished."); } catch (Exception ex) { MessageBox.Show(@"An Error occured while importing the file!, log output should have more info."); LogWriter.WriteLine(ex.Data + ex.StackTrace + ex.Message); } }
public static Task CreateDatabaseAsync(this MySqlDatabase db) { return Task.Run(() => { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(); connStr.Server = db.Host; connStr.Port = (uint)db.Port; connStr.UserID = db.Username; connStr.Password = db.Password; string connString = connStr.ToString(); string nonQuery = String.Format("DROP DATABASE IF EXISTS {0}; CREATE DATABASE {0};", db.DatabaseName); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand(nonQuery, conn)) { cmd.ExecuteNonQuery(); } conn.Close(); } }); }
DataTable dt_dr = new DataTable(); // tek tablo #endregion Fields #region Constructors public Form3(MySqlConnectionStringBuilder _bag) { InitializeComponent(); MySqlConnection conn = new MySqlConnection(_bag.ToString()); MySqlCommand cmd_hasta_sel = new MySqlCommand("select h.tc,h.adsoyad,d.doktorad from hasta h inner join doktor d on d.iddoktor=h.iddr;", conn); da_hasta = new MySqlDataAdapter(); da_hasta.SelectCommand = cmd_hasta_sel; MySqlCommand cmd_dr_sel = new MySqlCommand("select iddoktor, doktorad from doktor;", conn); MySqlDataAdapter da_dr = new MySqlDataAdapter(); da_dr.SelectCommand = cmd_dr_sel; da_dr.Fill(dt_dr); // doktorlarin listesi da_hasta_ekle = new MySqlDataAdapter(); // hasta eklemek icin MySqlCommand cmdhasta_sel = new MySqlCommand("select tc, adsoyad, iddr from hasta;", conn); MySqlCommand cmdhasta_ins = new MySqlCommand("insert into hasta(tc, adsoyad, iddr) values(@tc, @adsoyad, @iddr);", conn); cmdhasta_ins.Parameters.Add("@tc", MySqlDbType.VarChar, 11, "tc"); cmdhasta_ins.Parameters.Add("@adsoyad", MySqlDbType.VarChar, 45, "adsoyad"); cmdhasta_ins.Parameters.Add("@iddr", MySqlDbType.Int32, 11, "iddr"); da_hasta_ekle.SelectCommand = cmdhasta_sel; da_hasta_ekle.InsertCommand = cmdhasta_ins; verigetir(); // doktorlarin listesini comboya for (int i = 0; i < dt_dr.Rows.Count; i++) cdoktor.Items.Add(dt_dr.Rows[i].ItemArray[1].ToString()); }
// Zu Quell- und Zieldatenbank verbinden private void connectFischFaunaButton_Click(object sender, EventArgs e) { DatabaseConnection sourceCon = (DatabaseConnection)sourceDatabaseConnetions.SelectedValue; DatabaseConnection targetCon = (DatabaseConnection)targetDatabaseConnetions.SelectedValue; NpgsqlConnectionStringBuilder pgConStrBuilder = new NpgsqlConnectionStringBuilder(); pgConStrBuilder.Host = sourceCon.ServerAddress; pgConStrBuilder.UserName = sourceCon.UserName; pgConStrBuilder.Password = sourceCon.Password; pgConStrBuilder.Database = sourceCon.Database; MySqlConnectionStringBuilder mySqlConStrBuilder = new MySqlConnectionStringBuilder(); mySqlConStrBuilder.Server = targetCon.ServerAddress; mySqlConStrBuilder.UserID = targetCon.UserName; mySqlConStrBuilder.Password = targetCon.Password; mySqlConStrBuilder.Database = targetCon.Database; mySqlConStrBuilder.AllowZeroDateTime = true; _sourceCon = new NpgsqlConnection(pgConStrBuilder.ToString()); _targetCon = new MySqlConnection(mySqlConStrBuilder.ToString()); _mainLogic = new MainLogic(_sourceCon, _targetCon); _mainLogic.CheckForImportedFieldInMySql(); FillImportsCombobox(); FillImportUsersCombobox(); FillRecordQualityCombobox(); FillSourceTypeCombobox(); FillCountryCombobox(); PreSelectTestData(); groupBox2.Enabled = true; }
// Передача параметров подключения фенкции, с последующим назначением свойств. /// <summary> /// Метод MySqlConnection. Устанавливает подлючение к БД. /// </summary> public static bool MySqlConnection(string user, string passwd, string host, string db, bool test) { User = user; Pass = passwd; Host = host; DB = db; MySqlConnectionStringBuilder mysqlSting = new MySqlConnectionStringBuilder(); mysqlSting.Server = Host; mysqlSting.Database = DB; mysqlSting.UserID = User; mysqlSting.Password = Pass; mysqlSting.CharacterSet = "utf8"; connection = new MySqlConnection(mysqlSting.ToString()); { try { connection.Open(); connection.Close(); return true; } catch { return false; } } }
public WizardSelectDatabaseViewModel(WizardSelectDatabaseModel model, string host, int port, string username, string password) { WizardSelectDatabase = model; OkCommand = new Command(Ok); CancelCommand = new Command(CancelCmd); var connStr = new MySqlConnectionStringBuilder(); connStr.Server = host; connStr.Port = (uint)port; connStr.UserID = username; connStr.Password = password; using (var connection = new MySqlConnection(connStr.ToString())) { connection.Open(); using (var returnVal = new MySqlDataAdapter("SHOW DATABASES", connection)) { var dataTable = new DataTable(); returnVal.Fill(dataTable); foreach (DataRow row in dataTable.Rows) for (int i = 0; i < row.ItemArray.Length; i++) Databases.Add(row.ItemArray[i].ToString()); } } }
/// <summary> /// static constructor to determine the state of the environment and set defaults /// </summary> static CurrentEnvironment() { // Not on cloud foundry filling in the blanks. if (string.IsNullOrEmpty(Environment.GetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME))) { Environment.SetEnvironmentVariable(BOUND_SERVICES_ENV_VARIABLE_NAME, "{}"); Environment.SetEnvironmentVariable(PORT_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE); Environment.SetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE); Environment.SetEnvironmentVariable(INSTANCE_INDEX_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE); } // check to see if DB is bound, if so...what type // sql server first if (BoundServices.GetValue("mssql-dev") != null) // sql server { DbEngine = DatabaseEngine.SqlServer; _connectionString = BoundServices["mssql-dev"][0]["credentials"]["connectionString"].ToString(); } else if (BoundServices.GetValue("p-mysql") != null) { DbEngine = DatabaseEngine.MySql;; MySqlConnectionStringBuilder csbuilder = new MySqlConnectionStringBuilder(); csbuilder.Add("server", BoundServices["p-mysql"][0]["credentials"]["hostname"].ToString()); csbuilder.Add("port", BoundServices["p-mysql"][0]["credentials"]["port"].ToString()); csbuilder.Add("uid", BoundServices["p-mysql"][0]["credentials"]["username"].ToString()); csbuilder.Add("pwd", BoundServices["p-mysql"][0]["credentials"]["password"].ToString()); csbuilder.Add("database", BoundServices["p-mysql"][0]["credentials"]["name"].ToString()); _connectionString = csbuilder.ToString(); } else DbEngine = DatabaseEngine.None; }
private void buttonConnect_Click(object sender, EventArgs e) { bool succesConnection = true; var builder = new MySqlConnectionStringBuilder(); builder.Server = textBoxAddress.Text.Trim(); builder.UserID = textBoxUsername.Text.Trim(); builder.Password = textBoxPassword.Text.Trim(); builder.Port = Convert.ToUInt16(textBoxPort.Text); builder.Database = textBoxAuth.Text.Trim(); if (!ConnectDB(builder.ToString())) { succesConnection = false; } builder.Database = textBoxCharacters.Text.Trim(); if (!ConnectDB(builder.ToString())) { succesConnection = false; } builder.Database = textBoxWorld.Text.Trim(); if (!ConnectDB(builder.ToString())) { succesConnection = false; } if (succesConnection) { SaveSettings(); Andress = textBoxAddress.Text; Port = Convert.ToUInt16(textBoxPort.Text); Username = textBoxUsername.Text; Password = textBoxPassword.Text; DatabaseAuth = textBoxAuth.Text; DatabaseCharacters = textBoxCharacters.Text; DatabaseWorld = textBoxWorld.Text; this.Hide(); var mf = new FormMain(); mf.FormClosed += (s, args) => this.Close(); mf.Show(); } }
/// <summary> /// Initializes a new instance of the <see cref="MySqlClassGenerator"/> class. /// </summary> /// <param name="server">The server.</param> /// <param name="userID">The user ID.</param> /// <param name="password">The password.</param> /// <param name="database">The database.</param> /// <param name="port">The port.</param> public MySqlClassGenerator(string server, string userID, string password, string database, uint port = 3306u) { var sb = new MySqlConnectionStringBuilder { Server = server, UserID = userID, Password = password, Database = database, Port = port }; _conn = new MySqlConnection(sb.ToString()); SetDbConnection(_conn); }
public static MySqlConnection GetConnection() { var connString = new MySqlConnectionStringBuilder { //Connection Settings }; return new MySqlConnection(connString.ToString()); }
public IDbConnection OpenConnection() { var mySqlConnectionStringBuilder = new MySqlConnectionStringBuilder(_connectionString) { Database = _databaseName }; var mySqlConnection = new MySqlConnection(mySqlConnectionStringBuilder.ToString()); mySqlConnection.Open(); return mySqlConnection; }
public static string ConnectionString() { var cnB = new MySqlConnectionStringBuilder(); cnB["Data Source"] = "198.71.225.52"; cnB["Initial Catalog"] = "ninjatekweb_"; cnB["UID"] = "ninjatekadmin"; cnB["Password"] = "******"; cnB["Convert Zero Datetime"] = true; return cnB.ToString(); }
static DB() { MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder(); connBuilder.Add("Database", "Project_JJK"); connBuilder.Add("Data Source", "hellojkw.com"); connBuilder.Add("User Id", "uj7380"); connBuilder.Add("Password", "uj7380"); _connectionString = connBuilder.ToString(); Conn = new MySqlConnection(_connectionString); }
public string Create(Database database) { var connectionStringBuilder = new MySqlConnectionStringBuilder { Server = database.ServerName, Database = database.DatabaseName, IntegratedSecurity = true }; return connectionStringBuilder.ToString(); }
public static string GenerateConnectionString() { MySqlConnectionStringBuilder ConnectionStringBuilder = new MySqlConnectionStringBuilder(); ConnectionStringBuilder.Server = (string)ConfigManager.GetValue("mysql.host"); ConnectionStringBuilder.Port = (uint)(int)ConfigManager.GetValue("mysql.port"); ConnectionStringBuilder.UserID = (string)ConfigManager.GetValue("mysql.user"); ConnectionStringBuilder.Password = (string)ConfigManager.GetValue("mysql.pass"); ConnectionStringBuilder.Database = (string)ConfigManager.GetValue("mysql.dbname"); ConnectionStringBuilder.MinimumPoolSize = (uint)(int)ConfigManager.GetValue("mysql.pool.min"); ConnectionStringBuilder.MaximumPoolSize = (uint)(int)ConfigManager.GetValue("mysql.pool.max"); return ConnectionStringBuilder.ToString(); }
public static string GenerateConnectionString() { MySqlConnectionStringBuilder ConnectionStringBuilder = new MySqlConnectionStringBuilder(); ConnectionStringBuilder.Server = Application.GetConverter().GetDatabaseConfig("bfly").dbHost; ConnectionStringBuilder.Port = (uint)Application.GetConverter().GetDatabaseConfig("bfly").dbPort; ConnectionStringBuilder.UserID = Application.GetConverter().GetDatabaseConfig("bfly").dbUsername; ConnectionStringBuilder.Password = Application.GetConverter().GetDatabaseConfig("bfly").dbPassword; ConnectionStringBuilder.Database = Application.GetConverter().GetDatabaseConfig("bfly").dbDatabase; ConnectionStringBuilder.MinimumPoolSize = (uint)Application.GetConverter().GetDatabaseConfig("bfly").dbMinPool; ConnectionStringBuilder.MaximumPoolSize = (uint)Application.GetConverter().GetDatabaseConfig("bfly").dbMaxPool; return ConnectionStringBuilder.ToString(); }
// Generates the string required to create a connection private static string DatabaseString(string database) { var builder = new MySqlConnectionStringBuilder(); builder.Server = FormMySQL.Address; builder.UserID = FormMySQL.Username; builder.Password = FormMySQL.Password; builder.Port = FormMySQL.Port; builder.Database = database; return builder.ToString(); }
public RepositoryFactory(DatabaseConfiguration databaseConfiguration, string dataDirectory) { var connectionStringBuilder = new MySqlConnectionStringBuilder(); connectionStringBuilder.UserID = databaseConfiguration.Username; connectionStringBuilder.Password = databaseConfiguration.Password; connectionStringBuilder.Server = databaseConfiguration.Server; connectionStringBuilder.Database = databaseConfiguration.Database; connectionStringBuilder.Port = databaseConfiguration.Port; _connectionString = connectionStringBuilder.ToString(); _dataDirectory = dataDirectory; }
private static string connectionString(string host, uint port, string username, string password) { MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder(); sb.Server = host; sb.Port = port; sb.UserID = username; sb.Password = password; sb.MaximumPoolSize = 10; sb.MinimumPoolSize = 0; return sb.ToString(); }
/// <summary> /// /// </summary> /// <param name="host"></param> /// <param name="username"></param> /// <param name="passwd"></param> /// <param name="dbname"></param> /// <param name="port"></param> /// <param name="socket"></param> public MySQLi( string host = TAKE_FROM_INI, string username = TAKE_FROM_INI, string passwd = TAKE_FROM_INI, string dbname = "", int port = default_port, string socket = TAKE_FROM_INI) { if (host == TAKE_FROM_INI) PhpIni.TryGetValue("mysqli.default_host", out host); if (username == TAKE_FROM_INI) PhpIni.TryGetValue("mysqli.default_user", out username); if (passwd == TAKE_FROM_INI) PhpIni.TryGetValue("mysqli.default_pw", out passwd); if (port == default_port) { string portStr; if (PhpIni.TryGetValue("mysqli.default_port", out portStr)) port = int.Parse(portStr); else port = PhpIni.MYSQL_DEFAULT_PORT; } if (socket == TAKE_FROM_INI) PhpIni.TryGetValue("mysqli.default_socket", out socket); // MySQL a = new MySQL(); MySqlConnectionStringBuilder b = new MySqlConnectionStringBuilder(); b.Server = host; b.UserID = username; b.Port = (uint)port; if (!string.IsNullOrEmpty(passwd)) b.Password = passwd; _connection = new MySqlConnection(b.ToString()); try { _connection.Open(); if (!string.IsNullOrEmpty(dbname)) _connection.ChangeDatabase(dbname); } catch (MySqlException e) { connectError = e.Message; connectErrno = e.Number; } catch (Exception e) { connectError = e.Message; } }
internal string GenerateConnectionString() { MySqlConnectionStringBuilder connectionStringBuilder = new MySqlConnectionStringBuilder(); connectionStringBuilder.Server = hostname; connectionStringBuilder.Port = port; connectionStringBuilder.UserID = username; connectionStringBuilder.Password = password; connectionStringBuilder.Database = databaseName; connectionStringBuilder.MinimumPoolSize = minPoolSize; connectionStringBuilder.MaximumPoolSize = maxPoolSize; return connectionStringBuilder.ToString(); }
public Database( string server, uint port, string schema, string username, string password ) { MySqlConnectionStringBuilder myCSB = new MySqlConnectionStringBuilder( ); myCSB.Database = schema; myCSB.Server = server; myCSB.Port = port; myCSB.UserID = username; myCSB.Password = password; string connStr = myCSB.ToString( ); // myCSB.ToString( ); db_connection = new MySqlConnection( connStr ); db_connection.Open( ); }
private MySqlConnection CreateConnection(ConnSet connSet) { if (string.IsNullOrEmpty(ConnectionString)) { MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder { Server = connSet.txtDbIP.Text, UserID = connSet.txtUserName.Text, Password = connSet.txtPassword.Text, Database = connSet.txtDbName.Text }; ConnectionString = builder.ToString(); } return new MySqlConnection(ConnectionString); }
public Connection() { try { MySqlConnectionStringBuilder b = new MySqlConnectionStringBuilder(); b.Server = "localhost"; b.UserID = "root"; b.Password = ""; b.Database = "inventiolite"; con = new MySqlConnection(b.ToString()); } catch (MySqlException me) { MessageBox.Show(me.Message); } }
public MySqlCup(string user, string pass, string host, string db) { DbUser = user; DbPass = pass; DbHost = host; DbName = db; MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder { Database = DbName, UserID = DbUser, Password = DbPass, Server = DbHost }; ConnectionString = sb.ToString(); }
/// <summary> /// Creates the connection string for this database proxy. /// </summary> public string CreateConnectionString() { MySqlConnectionStringBuilder pCSB = new MySqlConnectionStringBuilder(); // Server pCSB.Server = mServer.Host; pCSB.Port = mServer.Port; pCSB.UserID = mServer.User; pCSB.Password = mServer.Password; // Database pCSB.Database = mDatabase.Name; pCSB.MinimumPoolSize = mDatabase.minPoolSize; pCSB.MaximumPoolSize = mDatabase.maxPoolSize; return pCSB.ToString(); }
public static string CreateConnectionString(String Host, UInt32 Port, string User, string Password, string Database) { MySqlConnectionStringBuilder MySqlConnect = new MySqlConnectionStringBuilder(); // Server MySqlConnect.Server = Host; MySqlConnect.Port = Port; MySqlConnect.UserID = User; MySqlConnect.Password = Password; // Database MySqlConnect.Database = Database; MySqlConnect.MinimumPoolSize = 0; MySqlConnect.MaximumPoolSize = 30; return MySqlConnect.ToString(); }
public BicycleDAL() { //s = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; //con = new SqlConnection(s); sb = new MySqlConnectionStringBuilder(); sb.Server = "cea766ee-d14f-4cde-9659-a53500832f5d.mysql.sequelizer.com"; sb.UserID = "qgdrzcnrgssnqeml"; sb.Password = "******"; sb.Database = "dbcea766eed14f4cde9659a53500832f5d"; try { con = new MySqlConnection(sb.ToString()); } catch (MySqlException e) { Console.WriteLine("Error: {0}", e.ToString()); } }