internal void CreateDAQDB() { var s = new DBConnectionString(); s.Database = "mysql"; var connectionString = s.ToString(); using (var connToMySql = new MySqlConnection(connectionString)) { connToMySql.Open(); MySqlCommand cmd = connToMySql.CreateCommand(); cmd.CommandText = "CREATE DATABASE if NOT EXISTS scada"; cmd.ExecuteNonQuery(); cmd.Dispose(); } }
public MySqlConnection GetMySqlConnection() { string installPath = Assembly.GetExecutingAssembly().Location; string fileName = string.Format("{0}\\..\\local.ip", installPath); var s = new DBConnectionString(); s.Address = "127.0.0.1"; if (File.Exists(fileName)) { using (StreamReader sr = new StreamReader(fileName)) { string ip = sr.ReadLine(); if (ip != null && ip.Length > 0) { s.Address = ip; } } } this.ConnectionString = s.ToString(); var conn = new MySqlConnection(this.ConnectionString); if (conn != null) { try { conn.Open(); return(conn); } catch (Exception e) { string msg = e.Message; } } return(null); }