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