private void executeQueryFromSimpleButton_Click(object sender, EventArgs e)
{
try
{
OpenLoading();
ClearGridView(fromGridView, fromGridControl);
ConnectionType?type = (ConnectionType?)typeFromImageComboBoxEdit.EditValue;
string scriptOrPath = ObterScriptOuPathPorTipo(type);
if (!AllowsToConsult(type, scriptOrPath))
{
return;
}
DataTable table = appService.GetByType(type.Value, scriptOrPath);
fromGridControl.DataSource = table;
CreateSummaryGridView(fromGridView, fromGridControl);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
CloseLoadind();
}
}
private void LoadTableByType(ConnectionType type)
{
if (appService == null)
{
ConfigureServices();
}
switch (type)
{
case ConnectionType.SqlServer:
tablesGridControl.DataSource = appService.GetByType(ConnectionType.SqlServer, "SELECT name AS TABELA FROM SYS.tables ORDER BY name ASC");
tablesGridControl.RefreshDataSource();
break;
case ConnectionType.Odbc:
tablesGridControl.DataSource = appService.GetByType(ConnectionType.Odbc, "SELECT CONVERT(VARCHAR(500),O.NAME) AS TABELA FROM SYSOBJECTS O WHERE TYPE = 'U' ORDER BY O.NAME");
tablesGridControl.RefreshDataSource();
break;
case ConnectionType.Firebird:
tablesGridControl.DataSource = appService.GetByType(ConnectionType.Firebird, "SELECT a.RDB$RELATION_NAME TABELA FROM RDB$RELATIONS a");
tablesGridControl.RefreshDataSource();
break;
default:
tablesGridControl.DataSource = null;
tablesGridControl.RefreshDataSource();
break;
}
}