//***************************************************************************
// Private Methods
//
private void PopulateTableList()
{
this.lstSrcTables.BeginUpdate();
this.lstSrcTables.Items.Clear();
try
{
if (this._db.GetType().Name != "rsDbSql")
{
throw new Exception("Export wizrd currently only support SQL database sources.");
}
rsDbSql db = (rsDbSql)this._db;
string[] tbls = db.GetTableList(this._dbNm);
for (int i = 0; i < tbls.Length; i++)
{
this.lstSrcTables.Items.Add("T: " + tbls[i]);
}
string[] vws = db.GetViewList(this._dbNm);
for (int i = 0; i < vws.Length; i++)
{
this.lstSrcTables.Items.Add("V: " + vws[i]);
}
}
catch (Exception ex)
{
CrossThreadUI.ShowMessageBox(this, "Unable to retrieve table names: " + ex.Message, "Unexpected Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
this.Dispose();
}
finally
{
this.lstSrcTables.EndUpdate();
}
}
private void dataQuery_onExecuteStopped(object sender, EventArgs e)
{
this._execTimer.Stop();
this._execTimer.Dispose();
CrossThreadUI.SetEnabled(this.txtQuery, true);
CrossThreadUI.SetEnabled(this.panConn, true);
this.UpdateQueryTime(this.TimeTaken);
this._dataQry.Dispose();
}
private void dataQuery_onResultComplete(object sender, EventArgs e)
{
SplitContainer splData = new SplitContainer();
splData.Orientation = Orientation.Horizontal;
splData.Dock = DockStyle.Fill;
splData.SplitterDistance = this.splQuery.Panel2.ClientRectangle.Height / 3;
splData.Panel1.Controls.Add(this._lastCreated);
CrossThreadUI.InvokePropertyMethod(this._createParent, "Controls", "Add", splData);
this._createParent = splData;
}
//***************************************************************************
// Event Handlers
//
private void dataQuery_onExecuteStart(object sender, EventArgs e)
{
CrossThreadUI.SetEnabled(this.txtQuery, false);
CrossThreadUI.SetEnabled(this.panConn, false);
CrossThreadUI.SetPropertyValue(this.splQuery, "Panel2Collapsed", false);
this._createParent = this.splQuery.Panel2;
this.InvokeCollapsedPanelChanged();
this.DestroyDatasource();
this._execTimer = new Timer();
this._execTimer.Interval = 500;
this._execTimer.Tick += new EventHandler(execTimer_onTick);
this._execTimer.Start();
this.InvokeQueryStart();
}
private void UpdateQueryTime(TimeSpan time)
{
CrossThreadUI.SetPropertyValue(this.statusLabelTime, "Text", string.Format("{0}:{1}:{2}", time.Hours.ToString().PadLeft(2, '0'), time.Minutes.ToString().PadLeft(2, '0'), time.Seconds.ToString().PadLeft(2, '0')));
}
