private void ShowContents(Stmt_Select statement, DBRunner runner, ISQLExecuter executer, DBConnection conn) { DBRowCollection coll = runner.Select(executer, conn, statement); String line = ""; foreach (DBMetaColumn meta in coll.Meta) { line += meta.ColumnName + ", "; } Output(line.Substring(0, line.Length - 2)); foreach (DBRow r in coll) { line = ""; int count = r.Count; for (int i = 0; i < count; i++) { line += r[i] == null ? "null, " : (r[i] + ", "); } Output(line.Substring(0, line.Length - 2)); } }
public DBRowCollection GetData(string selectStatement, string keyColumn) { var dataOut = new DBRowCollection(); var dataTable = GetDataTable(selectStatement); foreach (DataRow row in dataTable.Rows) { try { var newDataRow = new DBFieldCollection(); foreach (DataColumn column in dataTable.Columns) { if (!column.ColumnName.Equals(keyColumn, StringComparison.InvariantCultureIgnoreCase)) { newDataRow.Add(column.ColumnName, row[column.ColumnName].ToString()); } } dataOut.Add(row[keyColumn].ToString(), newDataRow); } catch (Exception ex) { throw new ApplicationException(string.Format("The file {0} was already found in the dataset. Please ensure the database is returning distinct filenames.", row[keyColumn].ToString())); } } return(dataOut); }
public static IEnumerable <SPDataRecord> ToSPDataRecords(this DBRowCollection inboundDBData, SPColumnMappings mappings) { var listOut = new List <SPDataRecord>(); foreach (string key in inboundDBData.Keys) { var fieldCollection = (DBFieldCollection)inboundDBData[key]; var dataRecord = fieldCollection.ToSPDataRecord(mappings, key); listOut.Add(dataRecord); } return(listOut); }
public DBRowCollection GetData(string selectStatement, string keyColumn) { var dataOut = new DBRowCollection(); var dataTable = GetDataTable(selectStatement); foreach (DataRow row in dataTable.Rows) { try { var newDataRow = new DBFieldCollection(); foreach (DataColumn column in dataTable.Columns) { if (!column.ColumnName.Equals(keyColumn, StringComparison.InvariantCultureIgnoreCase)) newDataRow.Add(column.ColumnName, row[column.ColumnName].ToString()); } dataOut.Add(row[keyColumn].ToString(), newDataRow); } catch (Exception ex) { throw new ApplicationException(string.Format("The file {0} was already found in the dataset. Please ensure the database is returning distinct filenames.", row[keyColumn].ToString())); } } return dataOut; }