private void saveQueryConfigurationToolStripMenuItem_Click(object sender, EventArgs e) { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { MultiDbQueryConfig cfg = new MultiDbQueryConfig(this.connData.SQLServerName, this.ddDatabase.SelectedItem.ToString(), this.rtbSqlScript.Text); MultiDbHelper.SaveMultiDbQueryConfiguration(saveFileDialog1.FileName, cfg); this.mruManager.Add(saveFileDialog1.FileName); this.savedMultiDbQFile = saveFileDialog1.FileName; this.isDirty = false; } }
private void LoadQueryConfig(string fileName) { MultiDbQueryConfig cfg = MultiDbHelper.LoadMultiDbQueryConfiguration(fileName); if (cfg != null) { lblServer.Text = cfg.SourceServer; this.SetDatabaseList(cfg.SourceServer, cfg.Database); this.mruManager.Add(fileName); rtbSqlScript.Text = cfg.Query; } this.isDirty = false; }
public static MultiDbData CreateMultiDbConfigFromQueryFile(string fileName, out string message) { try { MultiDbQueryConfig cfg = MultiDbHelper.LoadMultiDbQueryConfiguration(fileName); ConnectionData connData = new ConnectionData(cfg.SourceServer, cfg.Database); return(CreateMultiDbConfigFromQuery(connData, cfg.Query, out message)); } catch (Exception exe) { message = exe.Message; return(null); } }
public static bool SaveMultiDbQueryConfiguration(string fileName, MultiDbQueryConfig cfg) { try { using (XmlTextWriter tw = new XmlTextWriter(fileName, Encoding.UTF8)) { tw.Formatting = Formatting.Indented; XmlSerializer xmlS = new XmlSerializer(typeof(MultiDb.MultiDbQueryConfig)); xmlS.Serialize(tw, cfg); } return(true); } catch { return(false); } }
public static MultiDbQueryConfig LoadMultiDbQueryConfiguration(string fileName) { MultiDbQueryConfig data = null; try { using (TextReader reader = new StreamReader(fileName)) { XmlSerializer xmlS = new XmlSerializer(typeof(MultiDbQueryConfig)); object tmp = xmlS.Deserialize(reader); if (tmp != null) { data = (MultiDbQueryConfig)tmp; } } } catch { } return(data); }