Class DataTableTools

Inheritance
Object
DataTableTools
Inherited Members
Namespace: TowseyLibrary
Assembly: TowseyLibrary.dll
Syntax
public static class DataTableTools

Methods

| Improve this Doc View Source

AddColumnOfDoubles2Table(DataTable, String, Double[])

Declaration
public static void AddColumnOfDoubles2Table(DataTable dt, string columnName, double[] array)
Parameters
Type Name Description
DataTable dt
String columnName
Double[] array
| Improve this Doc View Source

ChangeColumnName(DataTable, String, String)

Declaration
public static void ChangeColumnName(DataTable dt, string oldName, string newName)
Parameters
Type Name Description
DataTable dt
String oldName
String newName
| Improve this Doc View Source

ChangeColumnType(DataTable, String, Type)

Declaration
public static void ChangeColumnType(DataTable dt, string colName, Type newType)
Parameters
Type Name Description
DataTable dt
String colName
Type newType
| Improve this Doc View Source

Column2ArrayOfDouble(DataTable, String)

Declaration
public static double[] Column2ArrayOfDouble(DataTable dt, string colName)
Parameters
Type Name Description
DataTable dt
String colName
Returns
Type Description
Double[]
| Improve this Doc View Source

Column2ListOfInt(DataTable, String)

Declaration
public static List<int> Column2ListOfInt(DataTable dt, string colName)
Parameters
Type Name Description
DataTable dt
String colName
Returns
Type Description
List<Int32>
| Improve this Doc View Source

CreateTable(DataTable)

setup skeleton of new table with same headers and column types as passed table.

Declaration
public static DataTable CreateTable(DataTable dt)
Parameters
Type Name Description
DataTable dt
Returns
Type Description
DataTable
| Improve this Doc View Source

CreateTable(String[], String[])

Declaration
public static DataTable CreateTable(string[] headers, string[] types)
Parameters
Type Name Description
String[] headers
String[] types
Returns
Type Description
DataTable
| Improve this Doc View Source

CreateTable(String[], Type[])

Declaration
public static DataTable CreateTable(string[] headers, Type[] types)
Parameters
Type Name Description
String[] headers
Type[] types
Returns
Type Description
DataTable
| Improve this Doc View Source

CreateTable(String[], Type[], List<Double[]>)

Declaration
public static DataTable CreateTable(string[] headers, Type[] types, List<double[]> data)
Parameters
Type Name Description
String[] headers
Type[] types
List<Double[]> data
Returns
Type Description
DataTable
| Improve this Doc View Source

DeleteRows(DataTable, String, String)

NOT DEBUGGED!!!!!.

Declaration
public static void DeleteRows(DataTable dt, string colName, string value)
Parameters
Type Name Description
DataTable dt
String colName
String value
| Improve this Doc View Source

GetColumnNames(DataTable)

Declaration
public static string[] GetColumnNames(DataTable dt)
Parameters
Type Name Description
DataTable dt
Returns
Type Description
String[]
| Improve this Doc View Source

GetColumnType(DataTable, String)

Declaration
public static Type GetColumnType(DataTable dt, string columnName)
Parameters
Type Name Description
DataTable dt
String columnName
Returns
Type Description
Type
| Improve this Doc View Source

GetColumnTypes(DataTable)

Declaration
public static Type[] GetColumnTypes(DataTable dt)
Parameters
Type Name Description
DataTable dt
Returns
Type Description
Type[]
| Improve this Doc View Source

GetDoubleFromDataRow(DataRow, Int32)

Declaration
public static double GetDoubleFromDataRow(DataRow row, int location)
Parameters
Type Name Description
DataRow row
Int32 location
Returns
Type Description
Double
| Improve this Doc View Source

ListOfColumnValues(DataTable)

Declaration
public static List<double[]> ListOfColumnValues(DataTable dt)
Parameters
Type Name Description
DataTable dt
Returns
Type Description
List<Double[]>
| Improve this Doc View Source

NormaliseColumnValues(List<Double[]>, Double[], Double[])

normalises the column values in a data table to values in [0,1].

Declaration
public static List<double[]> NormaliseColumnValues(List<double[]> columns, double[] minValue, double[] maxValue)
Parameters
Type Name Description
List<Double[]> columns
Double[] minValue
Double[] maxValue
Returns
Type Description
List<Double[]>
| Improve this Doc View Source

NormaliseColumnValues(DataTable)

normalises the column values in a data table to values in [0,1].

Declaration
public static DataTable NormaliseColumnValues(DataTable dt)
Parameters
Type Name Description
DataTable dt
Returns
Type Description
DataTable
| Improve this Doc View Source

NormaliseColumnValues(DataTable, Double[], Double[])

normalises the column values in a data table to values in [0,1].

Declaration
public static DataTable NormaliseColumnValues(DataTable dt, double[] minValue, double[] maxValue)
Parameters
Type Name Description
DataTable dt
Double[] minValue
Double[] maxValue
Returns
Type Description
DataTable
| Improve this Doc View Source

RemoveTableColumns(DataTable, Boolean[])

Declaration
public static void RemoveTableColumns(DataTable dt, bool[] retainColumn)
Parameters
Type Name Description
DataTable dt
Boolean[] retainColumn
| Improve this Doc View Source

SortRows(DataTable, String)

sorts all the rows in a table without filtering The empty string is the filtering term.

Declaration
public static DataRow[] SortRows(DataTable dt, string sortString)
Parameters
Type Name Description
DataTable dt
String sortString
Returns
Type Description
DataRow[]
| Improve this Doc View Source

SortTable(DataTable, String)

sorts all the rows in a table without filtering The empty string is the filtering term.

Declaration
public static DataTable SortTable(DataTable dt, string sortString)
Parameters
Type Name Description
DataTable dt
String sortString
Returns
Type Description
DataTable
| Improve this Doc View Source

WriteTable2Console(DataTable)

Declaration
public static void WriteTable2Console(DataTable dt)
Parameters
Type Name Description
DataTable dt
| Improve this Doc View Source

WriteTable2ConsoleInLongLayout(DataTable)

Declaration
public static void WriteTable2ConsoleInLongLayout(DataTable dt)
Parameters
Type Name Description
DataTable dt