C# Class TrakHound.Tools.DataTable_Functions

Exibir arquivo Open project: TrakHound/TrakHound-Community Class Usage Examples

Public Methods

Method Description
GetBooleanFromRow ( string key, DataRow row ) : bool
GetBooleanTableValue ( object table, string keyColumn, string key, string returnColumn ) : bool
GetDateTimeFromRow ( string key, DataRow row ) : System.DateTime
GetDateTimeTableValue ( object table, string keyColumn, string key, string returnColumn ) : System.DateTime
GetDistinctValues ( DataTable table, string columnName ) : string[]
GetDoubleFromRow ( string key, DataRow row ) : double
GetDoubleTableValue ( object table, string keyColumn, string key, string returnColumn ) : double
GetIntegerFromRow ( string key, DataRow row ) : int
GetRowValue ( string column, DataRow row ) : string
GetRows ( DataTable table, string filter ) : System.Data.DataRow[]
GetTableRows ( object table, string keyColumn, string key ) : List
GetTableValue ( object table, string filter, string returnColumn ) : string
GetTableValue ( object table, string keyColumn, string key, string returnColumn ) : string
RowExists ( DataTable dt, string keyColumn, string key ) : bool
UpdateTableValue ( object table, string keyColumn, string key, string valueColumn, string value ) : void
WriteRowValuesToConsole ( object ItemArray ) : void
WriteRowstoConsole ( string Title, DataTable DT ) : void

Method Details

GetBooleanFromRow() public static method

public static GetBooleanFromRow ( string key, DataRow row ) : bool
key string
row System.Data.DataRow
return bool

GetBooleanTableValue() public static method

public static GetBooleanTableValue ( object table, string keyColumn, string key, string returnColumn ) : bool
table object
keyColumn string
key string
returnColumn string
return bool

GetDateTimeFromRow() public static method

public static GetDateTimeFromRow ( string key, DataRow row ) : System.DateTime
key string
row System.Data.DataRow
return System.DateTime

GetDateTimeTableValue() public static method

public static GetDateTimeTableValue ( object table, string keyColumn, string key, string returnColumn ) : System.DateTime
table object
keyColumn string
key string
returnColumn string
return System.DateTime

GetDistinctValues() public static method

public static GetDistinctValues ( DataTable table, string columnName ) : string[]
table System.Data.DataTable
columnName string
return string[]

GetDoubleFromRow() public static method

public static GetDoubleFromRow ( string key, DataRow row ) : double
key string
row System.Data.DataRow
return double

GetDoubleTableValue() public static method

public static GetDoubleTableValue ( object table, string keyColumn, string key, string returnColumn ) : double
table object
keyColumn string
key string
returnColumn string
return double

GetIntegerFromRow() public static method

public static GetIntegerFromRow ( string key, DataRow row ) : int
key string
row System.Data.DataRow
return int

GetRowValue() public static method

public static GetRowValue ( string column, DataRow row ) : string
column string
row System.Data.DataRow
return string

GetRows() public static method

public static GetRows ( DataTable table, string filter ) : System.Data.DataRow[]
table System.Data.DataTable
filter string
return System.Data.DataRow[]

GetTableRows() public static method

public static GetTableRows ( object table, string keyColumn, string key ) : List
table object
keyColumn string
key string
return List

GetTableValue() public static method

public static GetTableValue ( object table, string filter, string returnColumn ) : string
table object
filter string
returnColumn string
return string

GetTableValue() public static method

public static GetTableValue ( object table, string keyColumn, string key, string returnColumn ) : string
table object
keyColumn string
key string
returnColumn string
return string

RowExists() public static method

public static RowExists ( DataTable dt, string keyColumn, string key ) : bool
dt System.Data.DataTable
keyColumn string
key string
return bool

UpdateTableValue() public static method

public static UpdateTableValue ( object table, string keyColumn, string key, string valueColumn, string value ) : void
table object
keyColumn string
key string
valueColumn string
value string
return void

WriteRowValuesToConsole() public static method

public static WriteRowValuesToConsole ( object ItemArray ) : void
ItemArray object
return void

WriteRowstoConsole() public static method

public static WriteRowstoConsole ( string Title, DataTable DT ) : void
Title string
DT System.Data.DataTable
return void