private void createDBbutton_Click(object sender, EventArgs e)
{
errorLabel.Text = "";
try
{
if (currentBaseWindow != null)
{
saveButton_Click(null, null);
DialogResult result = MessageBox.Show("This action will also drop the database with the same name if exists", "Warning Message", MessageBoxButtons.OKCancel);
//Check for OK Button and if cancel dont proceed
if (result == DialogResult.OK)
{
currentDataSet = currentBaseWindow.DatabaseDataSet;
string connectionString = "server= " + serverAddress.Text + " ; user id= " + userName.Text + " ; password= "******"; pooling=false;";
if (connection == null || connection.State != ConnectionState.Open)
{
connection = new MySqlConnection(connectionString);
connection.Open();
}
if (connection.State == System.Data.ConnectionState.Open && currentDataSet != null)
{
DatabaseScriptGenerator dbScriptGenerator = new DatabaseScriptGenerator();
dbScriptGenerator.CurrentDataSet = currentDataSet;
string sqlQueries = dbScriptGenerator.GenerateDatabaseScripts(currentBaseWindow);
if (sqlQueries == "")
{
return;
}
/* Testing code For Yash
*/
TextWriter tw = new StreamWriter(EIBXMLUtilities.dataFolderName + @"\test.sql");
tw.Write(sqlQueries);
tw.Close();
//MessageBox.Show("Connection to MySQL opened through MySQL for .Net" + sqlQueries);
MySqlCommand sqlCommand = new MySqlCommand(sqlQueries, connection);
int returnQueryExecute = sqlCommand.ExecuteNonQuery();
}
}
}
}
catch (Exception ex)
{
errorLabel.Text = ex.Message;
}
finally
{
connection.Close();
}
if (errorLabel.Text.Trim().Equals(""))
{
errorLabel.ForeColor = Color.Black;
errorLabel.Text = "Data Base Created.";
//this.Close();
}
this.Show();
}
private void createDBbutton_Click(object sender, EventArgs e)
{
errorLabel.Text = "";
try
{
if (currentBaseWindow != null)
{
saveButton_Click(null, null);
DialogResult result = MessageBox.Show("This action will also drop the database with the same name if exists", "Warning Message", MessageBoxButtons.OKCancel);
//Check for OK Button and if cancel dont proceed
if (result == DialogResult.OK)
{
currentDataSet = currentBaseWindow.DatabaseDataSet;
string connectionString = "server= " + serverAddress.Text + " ; user id= " + userName.Text + " ; password= "******"; pooling=false;";
if (connection == null || connection.State != ConnectionState.Open)
{
connection = new MySqlConnection(connectionString);
connection.Open();
}
if (connection.State == System.Data.ConnectionState.Open && currentDataSet != null)
{
DatabaseScriptGenerator dbScriptGenerator = new DatabaseScriptGenerator();
dbScriptGenerator.CurrentDataSet = currentDataSet;
string sqlQueries = dbScriptGenerator.GenerateDatabaseScripts(currentBaseWindow);
if (sqlQueries == "")
{
return;
}
/* Testing code For Yash
*/
TextWriter tw = new StreamWriter(EIBXMLUtilities.dataFolderName + @"\test.sql");
tw.Write(sqlQueries);
tw.Close();
//MessageBox.Show("Connection to MySQL opened through MySQL for .Net" + sqlQueries);
MySqlCommand sqlCommand = new MySqlCommand(sqlQueries, connection);
int returnQueryExecute = sqlCommand.ExecuteNonQuery();
//string[] query1 = sqlQueries.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
//foreach (string q1 in query1)
//{
//MySqlCommand sqlCommand = new MySqlCommand(q1, connection);
//int returnQueryExecute = sqlCommand.ExecuteNonQuery();
//}
}
}
}
}
catch (Exception ex)
{
errorLabel.Text = ex.Message;
}
finally
{
connection.Close();
}
if (errorLabel.Text.Trim().Equals(""))
{
errorLabel.ForeColor = Color.Black;
errorLabel.Text = "Data Base Created.";
//this.Close();
}
this.Show();
}