private void fromDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
{
// Check whether ODBConnection._Connection is open and usable
if (ODBConnection.valid)
{
try
{
new IEDatabase(ODBConnection.GetTableNames()).ShowDialog();
}
catch (SqlException)
{
MessageBox.Show(Resources.IEDatabase_connectionFail_msg, Resources.XMLGUI__fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
var result = new DatabaseConnection().ShowDialog();
if (result == DialogResult.OK && ODBConnection.valid)
{
fromDatabaseToolStripMenuItem_Click(sender, e);
}
else if (result == DialogResult.Cancel)
{
return;
}
}
}
private void toDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGrid.ColumnCount > 0) // Fixes #56
{
// Check whether ODBConnection._Connection is open and usable
if (ODBConnection.valid)
{
try
{
var dbTables = ODBConnection.GetTableNames();
var exportTable = dataGrid.DataSource as DataTable;
new IEDatabase(dbTables, exportTable).ShowDialog();
}
catch (SqlException)
{
MessageBox.Show(Resources.IEDatabase_connectionFail_msg, Resources.XMLGUI__fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
var result = new DatabaseConnection().ShowDialog();
if (result == DialogResult.OK && ODBConnection.valid)
{
toDatabaseToolStripMenuItem_Click(sender, e);
}
else if (result == DialogResult.Cancel)
{
return;
}
}
}
else
{
MessageBox.Show(Resources.XMLGUI_saveEmptyTable_fail_msg, Resources.XMLGUI__fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}