public static void Print(this DataTable dataTable, int top, ValueToStringHandler toString, params string[] columnNames) { Print(dataTable, false, top, toString, columnNames); }
private static void PrintListRow(IEnumerable <DataRow> rows, DataColumn[] columns, object[] objects, string format, bool rowOrdinals, ValueToStringHandler toString, string ordinalColumnName) { if (rowOrdinals) { IEnumerable <int> ordinals = null; if (string.IsNullOrEmpty(ordinalColumnName)) { ordinals = rows.Select(row => row.Table.Rows.IndexOf(row)); } else { ordinals = rows.Select(row => (int)row[ordinalColumnName]); } objects[0] = "Ordinal"; int k = 1; foreach (int ordinal in ordinals) { objects[k++] = (ordinal > -1 ? ordinal : (int?)null); } WriteLine(format, objects); } for (int i = 0; i < columns.Length; i++) { objects[0] = columns[i].ColumnName; int k = 1; foreach (DataRow row in rows) { object obj = row[columns[i]]; string str = null; if (toString != null) { str = toString(obj, row, columns[i]); if (str == null) { str = "null"; } } else { str = string.Format("{0}", (obj == DBNull.Value || obj == null ? "null" : obj)); } objects[k++] = str; } WriteLine(format, objects); } }
public static void Print(this DataTable dataTable, bool rowOrdinals, ValueToStringHandler toString, params string[] columnNames) { Print(dataTable, rowOrdinals, 0, toString, columnNames); }
private static void PrintListRows(DataTable dataTable, IEnumerable <DataRow> dataRows, bool rowOrdinals, int top, ValueToStringHandler toString, int repeatColumns, RepeatDirection repeatDirection, string delimiter, string[] columnNames, string ordinalColumnName = null) { if (dataTable != null && string.IsNullOrEmpty(dataTable.TableName) == false) { WriteLine("{0}:", dataTable.TableName); } if (dataRows.Count() == 0) { WriteLine("No rows were selected"); WriteLine(); return; } DataColumn[] columns = GetColumns(dataTable, columnNames, ordinalColumnName); if (columns.Length == 0) { WriteLine("No columns were selected"); WriteLine(); return; } if (top > 0) { dataRows = dataRows.Take(top); } int columnsLength = columns.Select(c => c.ColumnName.Length).Max(); int[] lengths = new int[columns.Length]; foreach (DataRow row in dataRows) { CalculateLengths(row, columns, lengths, toString); } int rowsLength = lengths.Max(); if (rowOrdinals) { if (dataRows.Count() > 0) { if (columnsLength < 7) // "Ordinal".Length { columnsLength = 7; } int maxRowOrdinal = 0; if (string.IsNullOrEmpty(ordinalColumnName)) { maxRowOrdinal = dataRows.Select(row => row.Table.Rows.IndexOf(row)).Max(); } else { maxRowOrdinal = dataRows.Select(row => (int)row[ordinalColumnName]).Max(); } if (maxRowOrdinal > -1) { int rowOrdinalsLength = maxRowOrdinal.ToString().Length; if (rowsLength < rowOrdinalsLength) { rowsLength = rowOrdinalsLength; } } } } if (repeatColumns < 1) { repeatColumns = 1; } if (repeatColumns > dataRows.Count()) { repeatColumns = dataRows.Count(); } int lastRowFilledCellsCount = dataRows.Count() % repeatColumns; if (lastRowFilledCellsCount == 0) { lastRowFilledCellsCount = repeatColumns; } int lastRowEmptyCellsCount = repeatColumns - lastRowFilledCellsCount; int rowsCount = (dataRows.Count() / repeatColumns) + (dataRows.Count() % repeatColumns > 0 ? 1 : 0); if (delimiter == null) { delimiter = string.Empty; } string cellFormat = string.Format(" {{{{0,-{0}}}}}{1}{{{{{{0}},-{2}}}}} {3}", columnsLength, delimiter, rowsLength, Verticl_Bar); string horizontal = new String(Horizontal_Bar, columnsLength + delimiter.Length + rowsLength + 2); string header = Top_Left.ToString(); string separator = Middle_Left.ToString(); string footer = Bottom_Left.ToString(); string format = Verticl_Bar.ToString(); int k = 0; for (; k < repeatColumns - 1; k++) { header += horizontal + Top_Center; separator += horizontal + Middle_Center; footer += horizontal + Bottom_Center; format += string.Format(cellFormat, k + 1); } k = repeatColumns - 1; if (k >= 0) { header += horizontal + Top_Right; separator += horizontal + Middle_Right; footer += horizontal + Bottom_Right; format += string.Format(cellFormat, k + 1); } string formatPartial = format; if (lastRowEmptyCellsCount > 0) { formatPartial = Verticl_Bar.ToString(); for (int i = 0; i < lastRowFilledCellsCount; i++) { formatPartial += string.Format(cellFormat, i + 1); } for (int i = 0; i < lastRowEmptyCellsCount; i++) { formatPartial += new String(' ', columnsLength + delimiter.Length + rowsLength + 2) + Verticl_Bar; } } object[] objects = new object[repeatColumns + 1]; if (repeatDirection == RepeatDirection.Horizontal) { for (int i = 0; i < rowsCount; i++) { WriteLine(i == 0 ? header : separator); var rows = dataRows.Skip(i * repeatColumns).Take(repeatColumns); PrintListRow(rows, columns, objects, (i < rowsCount - 1 ? format : formatPartial), rowOrdinals, toString, ordinalColumnName); } } else if (repeatDirection == RepeatDirection.Vertical && lastRowEmptyCellsCount == 0) { for (int i = 0; i < rowsCount; i++) { WriteLine(i == 0 ? header : separator); var rows = dataRows.Where((r, n) => n % rowsCount == i); PrintListRow(rows, columns, objects, (i < rowsCount - 1 ? format : formatPartial), rowOrdinals, toString, ordinalColumnName); } } else if (repeatDirection == RepeatDirection.Vertical && lastRowEmptyCellsCount > 0) { for (int i = 0; i < rowsCount; i++) { WriteLine(i == 0 ? header : separator); var rows = dataRows.Where((r, n) => (n < lastRowFilledCellsCount * rowsCount && n % rowsCount == i) || (n >= lastRowFilledCellsCount * rowsCount && (n - (lastRowFilledCellsCount * rowsCount)) % (rowsCount - 1) == i) ); PrintListRow(rows, columns, objects, (i < rowsCount - 1 ? format : formatPartial), rowOrdinals, toString, ordinalColumnName); } } WriteLine(footer); WriteLine(); }
private static void PrintListRows(DataView dataView, bool rowOrdinals, int top, ValueToStringHandler toString, int repeatColumns, RepeatDirection repeatDirection, string delimiter, string[] columnNames) { string ordinalColumnName = null; DataTable dataTable = GetTableFromView(dataView, rowOrdinals, top, ref ordinalColumnName); PrintListRows(dataTable, dataTable.AsEnumerable(), rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames, ordinalColumnName); }
public static void Print(this DataSet dataSet, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames) { foreach (DataTable dataTable in dataSet.Tables) { Print(dataTable, rowOrdinals, top, toString, columnNames); } }
public static void PrintList(this DataRow[] dataRows, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, int repeatColumns = 2, RepeatDirection repeatDirection = RepeatDirection.Vertical, string delimiter = ": ", params string[] columnNames) { PrintListRows((dataRows.Length != 0 ? dataRows[0].Table : null), dataRows, rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames); }
public static void PrintList(this DataSet dataSet, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, int repeatColumns = 2, RepeatDirection repeatDirection = RepeatDirection.Vertical, string delimiter = ": ", params string[] columnNames) { foreach (DataTable dataTable in dataSet.Tables) { PrintList(dataTable, rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames); } }
public static void PrintList(this DataRow[] dataRows, bool rowOrdinals, ValueToStringHandler toString, params string[] columnNames) { PrintList(dataRows, rowOrdinals, 0, toString, columnNames: columnNames); }
public static void PrintList(this DataView dataView, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, int repeatColumns = 2, RepeatDirection repeatDirection = RepeatDirection.Vertical, string delimiter = ": ", params string[] columnNames) { PrintListRows(dataView, rowOrdinals, top, toString, repeatColumns, repeatDirection, delimiter, columnNames); }
public static void PrintList(this DataSet dataSet, ValueToStringHandler toString, params string[] columnNames) { PrintList(dataSet, false, 0, toString, columnNames: columnNames); }
private static void CalculateLengths(DataRow row, DataColumn[] columns, int[] lengths, ValueToStringHandler toString) { for (int i = 0; i < columns.Length; i++) { object obj = row[columns[i]]; string str = null; if (toString != null) { str = toString(obj, row, columns[i]); if (str == null) { str = "null"; } } else { str = string.Format("{0}", (obj == DBNull.Value || obj == null ? "null" : obj)); } if (lengths[i] < str.Length) { lengths[i] = str.Length; } } }
private static void PrintRows(DataTable dataTable, IEnumerable <DataRow> dataRows, bool rowOrdinals, int top, ValueToStringHandler toString, string[] columnNames, string ordinalColumnName = null) { if (dataTable == null && dataRows.Count() == 0) { WriteLine("No rows were selected"); WriteLine(); return; } if (dataTable != null && string.IsNullOrEmpty(dataTable.TableName) == false) { WriteLine("{0}:", dataTable.TableName); } DataColumn[] columns = GetColumns(dataTable, columnNames, ordinalColumnName); if (columns.Length == 0) { WriteLine("No columns were selected"); WriteLine(); return; } if (top > 0) { dataRows = dataRows.Take(top); } int[] lengths = columns.Select(c => c.ColumnName.Length).ToArray(); foreach (DataRow row in dataRows) { CalculateLengths(row, columns, lengths, toString); } int rowOrdinalsLength = 0; if (rowOrdinals) { if (dataRows.Count() > 0) { int maxRowOrdinal = 0; if (string.IsNullOrEmpty(ordinalColumnName)) { maxRowOrdinal = dataRows.Select(row => row.Table.Rows.IndexOf(row)).Max(); } else { maxRowOrdinal = dataRows.Select(row => (int)row[ordinalColumnName]).Max(); } if (maxRowOrdinal > -1) { rowOrdinalsLength = maxRowOrdinal.ToString().Length; } } } string header = Top_Left.ToString(); string separator = Middle_Left.ToString(); string footer = Bottom_Left.ToString(); string formatHeaders = Verticl_Bar.ToString(); string format = Verticl_Bar.ToString(); if (rowOrdinals) { string horizontal = new String(Horizontal_Bar, rowOrdinalsLength + 2); header += horizontal + Top_Center; separator += horizontal + Middle_Center; footer += horizontal + Bottom_Center; formatHeaders += string.Format(" {{0,-{0}}} {1}", rowOrdinalsLength, Verticl_Bar); format += string.Format(" {{0,{0}}} {1}", rowOrdinalsLength, Verticl_Bar); } int k = 0; for (; k < columns.Length - 1; k++) { string horizontal = new String(Horizontal_Bar, lengths[k] + 2); header += horizontal + Top_Center; separator += horizontal + Middle_Center; footer += horizontal + Bottom_Center; string cellFormat = string.Format(" {{{0},-{1}}} {2}", k + 1, lengths[k], Verticl_Bar); formatHeaders += cellFormat; format += cellFormat; } k = columns.Length - 1; if (k >= 0) { string horizontal = new String(Horizontal_Bar, lengths[k] + 2); header += horizontal + Top_Right; separator += horizontal + Middle_Right; footer += horizontal + Bottom_Right; string cellFormat = string.Format(" {{{0},-{1}}} {2}", k + 1, lengths[k], Verticl_Bar); formatHeaders += cellFormat; format += cellFormat; } object[] objects = new object[columns.Length + 1]; WriteLine(header); objects[0] = string.Empty; for (int i = 0; i < columns.Length; i++) { objects[i + 1] = columns[i]; } WriteLine(formatHeaders, objects); WriteLine(separator); foreach (DataRow row in dataRows) { if (rowOrdinals) { int ordinal = 0; if (string.IsNullOrEmpty(ordinalColumnName)) { ordinal = row.Table.Rows.IndexOf(row); } else { ordinal = (int)row[ordinalColumnName]; } objects[0] = (ordinal > -1 ? ordinal : (int?)null); } for (int i = 0; i < columns.Length; i++) { object obj = row[columns[i]]; string str = null; if (toString != null) { str = toString(obj, row, columns[i]); if (str == null) { str = "null"; } } else { str = string.Format("{0}", (obj == DBNull.Value || obj == null ? "null" : obj)); } objects[i + 1] = str; } WriteLine(format, objects); } WriteLine(footer); WriteLine(); }
public static void Print(this DataRow[] dataRows, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames) { PrintRows((dataRows.Length != 0 ? dataRows[0].Table : null), dataRows, rowOrdinals, top, toString, columnNames); }
public static void Print(this DataTable dataTable, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames) { PrintRows(dataTable, dataTable.AsEnumerable(), rowOrdinals, top, toString, columnNames); }
public static void PrintList(this DataRow[] dataRows, int top, ValueToStringHandler toString, params string[] columnNames) { PrintList(dataRows, false, top, toString, columnNames: columnNames); }
public static void Print(this DataView dataView, ValueToStringHandler toString, params string[] columnNames) { Print(dataView, false, 0, toString, columnNames); }
public static void Print(this DataView dataView, bool rowOrdinals = false, int top = 0, ValueToStringHandler toString = null, params string[] columnNames) { PrintRows(dataView, rowOrdinals, top, toString, columnNames); }