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