public void createLogFile(DBinfo dbconnstring) { string connString = @"server=" + dbconnstring.ServerName + ";userid=root" + ";password=metalic"; MessageBox.Show(connString); cnnLog = new MySqlConnection(connString); try { cnnLog.Open(); // MessageBox.Show("Connection Open ! "); MessageBox.Show("Connection Open!\n", "Connection", MessageBoxButtons.OK, MessageBoxIcon.None); } catch (MySqlException ex) { MessageBox.Show("Can not open connection ! \n" + ex.ToString()); //MessageBox.Show(ex.ToString()); } cmd.Connection = cnnLog; cmd.CommandText = "CREATE DATABASE " + dbconnstring.DBName + "_log"; cmd.ExecuteNonQuery(); }
public string getConnectionString(DBinfo dbconnstring) { //string a = "Data Source=" + dbconnstring.ServerName + ";Initial Catalog=" + dbconnstring.DBName + ";User ID=root" + ";Password=metalic"; return("Data Source=" + dbconnstring.ServerName + ";Initial Catalog=" + dbconnstring.DBName + ";User ID=root" + ";Password=metalic"); }