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