public void Dispose()
{
try
{
_database.Dispose();
}
catch { }
try
{
_server = null;
}
catch { }
try
{
_mySqlScript = null;
}
catch { }
}
void Start()
{
sb = new StringBuilder();
sb.AppendLine("<html><head><style>h1 { line-height:160%; font-size: 20pt; } h2 { line-height:160%; font-size: 14pt; } body { font-family: \"Segoe UI\", Arial; line-height: 150%; } table { border: 1px solid #5C5C5C; border-collapse: collapse; } td { font-size: 10pt; padding: 4px; border: 1px solid #5C5C5C; } .code { font-family: \"Courier New\"; font-size: 10pt; line-height:110%; } </style></head>");
sb.AppendLine("<body>");
using (MySqlConnection conn = new MySqlConnection(Program.ConnectionString))
{
try
{
conn.Open();
cmd = new MySqlCommand();
cmd.Connection = conn;
myDatabase = new MySqlDatabase();
myDatabase.GetDatabaseInfo(cmd, true);
myServer = new MySqlServer();
myServer.GetServerInfo(cmd);
int stage = 1;
while (stage < 13)
{
try
{
switch (stage)
{
case 1: LoadDatabase(); break;
case 2: LoadUser(); break;
case 3: LoadGlobalPrivilege(); break;
case 4: LoadViewPrivilege(); break;
case 5: LoadFunctionPrivilege(); break;
case 6: LoadVariables(); break;
case 7: LoadTables(); break;
case 8: LoadFunctions(); break;
case 9: LoadProcedures(); break;
case 10: LoadTriggers(); break;
case 11: LoadViews(); break;
case 12: LoadEvents(); break;
default: break;
}
}
catch (Exception ex)
{
WriteError(ex.Message);
}
stage += 1;
}
conn.Close();
}
catch (Exception exCon)
{
WriteError(exCon.Message);
}
}
sb.Append("</body>");
sb.Append("</html>");
}
public void Dispose()
{
try
{
_database.Dispose();
}
catch { }
try
{
_server = null;
}
catch { }
try
{
_mySqlScript = null;
}
catch { }
}
