private void LoadSQLLog()
{
txtLog.ResetText();
var data = new QueryLog.Data();
data.ConnectionId = ConnectionId;
data.FromDate = DateTime.Today;
var logList = QueryLog.Search(data);
if (logList != null && logList.Rows.Count > 0)
{
foreach (DataRow dr in logList.Rows)
{
var dt = Convert.ToDateTime(dr["CreatedDate"]);
txtLog.AppendText("--------Executed on: " + dt.ToString("MM-dd-yyyy") + " " + dt.Hour + ":" + dt.Minute + ":" + dt.Second + "-------\n");
txtLog.AppendText(Convert.ToString(dr["QueryText"]) + "\n");
txtLog.AppendText("\n");
}
}
}
public override void InitLog()
{
base.InitLog();
_box.ResetText();
}
