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); }