private void EhViewResults()
{
// make sure we have a select statement
var sql = _selectionStatement;
if (string.IsNullOrEmpty(sql))
{
return;
}
// create table to load with data and display
var dt = new System.Data.DataTable("Query");
// get table/view name
var selNode = _treeRootNode.AnyBetweenHereAndLeaves(x => x.IsSelected);
var table = selNode == null ? null : selNode.Tag as System.Data.DataTable;
dt.TableName = table.TableName;
// get view parameters if necessary
var parms = OleDbSchema.GetTableParameters(table);
if (parms != null && parms.Count > 0)
{
var ctrl = new ParametersController(parms);
if (!Current.Gui.ShowDialog(ctrl, "Parameter", false))
{
return;
}
}
// get data
try
{
using (var da = new System.Data.OleDb.OleDbDataAdapter(_selectionStatement, ConnectionString.ConnectionStringWithTemporaryCredentials))
{
// get data
da.Fill(0, MAX_PREVIEW_RECORDS, dt);
// show the data
var ctrl = new DataPreviewController(dt);
string title = string.Format("{0} ({1:n0} records)", dt.TableName, dt.Rows.Count);
Current.Gui.ShowDialog(ctrl, title, false);
}
}
catch (Exception x)
{
Current.Gui.ErrorMessageBox(string.Format("Failed to retrieve data:\r\n{0}", x.Message));
}
}
private void EhViewResults()
{
// make sure we have a select statement
var sql = _selectionStatement;
if (string.IsNullOrEmpty(sql))
{
return;
}
// create table to load with data and display
var dt = new System.Data.DataTable("Query");
// get table/view name
var selNode = _treeRootNode.AnyBetweenHereAndLeaves(x => x.IsSelected);
var table = selNode == null ? null : selNode.Tag as System.Data.DataTable;
dt.TableName = table.TableName;
// get view parameters if necessary
var parms = OleDbSchema.GetTableParameters(table);
if (parms != null && parms.Count > 0)
{
var ctrl = new ParametersController(parms);
if (!Current.Gui.ShowDialog(ctrl, "Parameter", false))
{
return;
}
}
// get data
try
{
using (var da = new System.Data.OleDb.OleDbDataAdapter(_selectionStatement, ConnectionString.ConnectionStringWithTemporaryCredentials))
{
// get data
da.Fill(0, MAX_PREVIEW_RECORDS, dt);
// show the data
var ctrl = new DataPreviewController(dt);
string title = string.Format("{0} ({1:n0} records)", dt.TableName, dt.Rows.Count);
Current.Gui.ShowDialog(ctrl, title, false);
}
}
catch (Exception x)
{
Current.Gui.ErrorMessageBox(string.Format("Failed to retrieve data:\r\n{0}", x.Message));
}
}
