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());
}
}
