void LoadSavedQuerys()
{
System.Text.StringBuilder sqlCommand = new StringBuilder();
System.Reflection.Assembly appDll = System.Reflection.Assembly.GetExecutingAssembly();
using (System.IO.Stream stream = appDll.GetManifestResourceStream(COMMAND_TXT_NAME))
{
bool findCommand = false;
ToolStripMenuItem item = null;
using (System.IO.StreamReader reader = new StreamReader(stream))
{
string line = reader.ReadLine();
while (line != null)
{
// command file end
if (line.Equals(END_ALL))
break;
if (!findCommand && line.StartsWith(COMMAND_BEGIN))
{
findCommand = true;
item = new ToolStripMenuItem();
item.Text = line.Substring(COMMAND_START_INDEX);
line = reader.ReadLine();
continue;
}
line = line.Trim();
// find empty line
if (line.Length == 0)
{
line = reader.ReadLine();
continue;
}
// find command end
if (findCommand && line.Equals(COMMAND_END))
{
findCommand = false;
item.Tag = sqlCommand.ToString();
sqlCommand.Remove(0, sqlCommand.Length);
item.Click += delegate(object sender, EventArgs ea)
{
ToolStripMenuItem i = (ToolStripMenuItem)sender;
//string sql = (string)i.Tag;
FrmDataGridView gv = new FrmDataGridView();
gv.LoadData((string)i.Tag);
gv.ShowDialog(this);
GC.Collect();
};
//this.mnQueue.MenuItems.Add(item);
//item
btnQuerys.DropDownItems.Add(item);
line = reader.ReadLine();
continue;
}
// find comments line
if (line.StartsWith("--"))
{
line = reader.ReadLine();
continue;
}
sqlCommand.Append(line);
// add return character
sqlCommand.Append("\r\n");
// move to next command
line = reader.ReadLine();
}
}
stream.Close();
}
GC.Collect();
}
void LoadSavedQuerys()
{
System.Text.StringBuilder sqlCommand = new StringBuilder();
System.Reflection.Assembly appDll = System.Reflection.Assembly.GetExecutingAssembly();
using (System.IO.Stream stream = appDll.GetManifestResourceStream(COMMAND_TXT_NAME))
{
bool findCommand = false;
ToolStripMenuItem item = null;
using (System.IO.StreamReader reader = new StreamReader(stream))
{
string line = reader.ReadLine();
while (line != null)
{
// command file end
if (line.Equals(END_ALL))
{
break;
}
if (!findCommand && line.StartsWith(COMMAND_BEGIN))
{
findCommand = true;
item = new ToolStripMenuItem();
item.Text = line.Substring(COMMAND_START_INDEX);
line = reader.ReadLine();
continue;
}
line = line.Trim();
// find empty line
if (line.Length == 0)
{
line = reader.ReadLine();
continue;
}
// find command end
if (findCommand && line.Equals(COMMAND_END))
{
findCommand = false;
item.Tag = sqlCommand.ToString();
sqlCommand.Remove(0, sqlCommand.Length);
item.Click += delegate(object sender, EventArgs ea)
{
ToolStripMenuItem i = (ToolStripMenuItem)sender;
//string sql = (string)i.Tag;
FrmDataGridView gv = new FrmDataGridView();
gv.LoadData((string)i.Tag);
gv.ShowDialog(this);
GC.Collect();
};
//this.mnQueue.MenuItems.Add(item);
//item
btnQuerys.DropDownItems.Add(item);
line = reader.ReadLine();
continue;
}
// find comments line
if (line.StartsWith("--"))
{
line = reader.ReadLine();
continue;
}
sqlCommand.Append(line);
// add return character
sqlCommand.Append("\r\n");
// move to next command
line = reader.ReadLine();
}
}
stream.Close();
}
GC.Collect();
}