public static TableResults SelectList(string source, string tableName, string columnName)
{
string sql = String.Format("SELECT {1} FROM {0}", CheckTableName(tableName), CheckColumnName(columnName));
var result = new TableResults();
Execute(source, sql,
(cmd) =>
{
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataColumn c in dt.Columns)
{
result.Columns.Add(c.ColumnName);
}
foreach (DataRow row in dt.Rows)
{
var t = row;
result.Rows.Add(row.ItemArray);
}
},
(error) =>
{
}
);
return(result);
}
public SearchResultViewModel Merge(SearchResultViewModel other)
{
var result = new SearchResultViewModel();
var tableResults = new List <TableSearchResult>(TableResults.Count() + other.TableResults.Count());
tableResults.AddRange(TableResults);
tableResults.AddRange(other.TableResults);
result.TableResults = tableResults;
var columnResults = new List <ColumnSearchResult>();
columnResults.AddRange(ColumnResults);
columnResults.AddRange(other.ColumnResults);
result.ColumnResults = columnResults;
var procedureResults = new List <StoredProcedureResult>();
procedureResults.AddRange(procedureResults);
procedureResults.AddRange(other.ProcedureResults);
result.ProcedureResults = procedureResults;
return(result);
}
/// <summary>
/// Constructs a proxy row.
/// </summary>
/// <param name="results"> A result table. </param>
/// <param name="index"> An index of a row in the given result table.</param>
public RowProxy(TableResults results, int index)
{
this.index = index;
this.resTable = results;
}
public void resultados()
{
TableResults.mostrarResultados(Teams);
}
