The DataHelper type exposes the following members.
Back to Top
Back to Top
Back to Top
Back to Top
Constructors
| Name | Description | |
|---|---|---|
 | DataHelper |
Methods
| Name | Description | |
|---|---|---|
 | CompareByteArrays |
Compares two byte arrays.
|
| ConvertColumnToDateTime |
Converts the specified column to Date time type.
|
| ConvertToDataTable T |
Method to convert LINQ result to DataTable
|
| ConvertValue(Object, Type) |
Converts the value to a specific type.
|
| ConvertValue(Object, Type, Object ) |
Converts the value to a specific type. Returns true if conversion was possible, otherwise false.
|
| ConvertValueToDefaultCulture |
Converts value to culture specific value.
|
| CopyColumnValues |
Copies column values from source column to target column.
|
| CreateUniqueTableColumn |
Creates column with unique name int he given table.
|
| DataSetPivot |
Converts data set to it's pilot.
|
| DataSourceIsEmpty(DataSet) |
Returns true if the given data source is empty.
|
| DataSourceIsEmpty(Object) |
Returns true if the given data source is empty.
|
| DeleteRows(DataSet, String) |
Deletes the table rows matching the given where condition.
|
| DeleteRows(DataTable, String) |
Deletes the table rows matching the given where condition.
|
| EnsureCodenames |
Ensures Codename values in specified column.
|
| EnsureColumn |
Ensures specified column.
|
| EnsureGUIDs |
Ensures GUID values in specified column.
|
| EnsureIdentifiers |
Ensures identifier values in specified column.
|
| EnsureRandomValues |
Ensures random values in specified int column.
|
| EnsureStringValues |
Ensures Codename values in specified column.
|
|  Equals | (Inherited from Object.) |
| ExtendParameters |
Extends the parameters array for new items.
|
| FileSizeFormat |
Formats file size in human readable format.
|
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| ForEachRow |
Executes the given action for each row in the given DataSet
|
| FromBase64String |
Converts the string from Base64 string to the byte array.
|
| GetBoolValue(ISimpleDataContainer, String) |
Gets the bool variable from given data container.
|
| GetBoolValue(DataRow, String, Boolean) |
Gets the bool variable from given DataRow.
|
| GetBoolValue(ISimpleDataContainer, String, Boolean) |
Gets the bool variable from given data container.
|
| GetColumns |
Gets the columns of the given table as the string array.
|
| GetDataContainer |
Gets the data container able to read the given data object
|
| GetDataContainerItem |
Returns data from datarow, datarowview or ISimpleDataContainer objects for specified column.
|
| GetDataRowValue |
Returns the value from the DataRow field, or DBNull.Value if the field does not exist in the datarow.
|
| GetDataRowViewValue |
Returns the value from the DataRowView field, or null if the field does not exist in the datarow.
|
| GetDataSetFromXml |
Gets DataSet from the given XML string.
|
| GetDataTable |
Returns the DataTable from the given data source.
|
| GetDataView |
Returns the DataView from the given data source.
|
| GetDateTimeValue(ISimpleDataContainer, String) |
Gets the DateTime variable from given data container.
|
| GetDateTimeValue(DataRow, String, DateTime) |
Gets the DateTime variable from given DataRow.
|
| GetDBNull |
Converts the standard null value to DBNull.value, keeps the object value if not null.
|
| GetGuidValue(ISimpleDataContainer, String) |
Gets the guid variable from given data container.
|
| GetGuidValue(DataRow, String, Guid) |
Gets the guid variable from given DataRow.
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetIntegerValues(DataTable, String) |
Gets the array of integer values from the given data table.
|
| GetIntegerValues(DataView, String) |
Gets the array of integer values from the given data table.
|
| GetIntValue(ISimpleDataContainer, String) |
Gets the integer variable from given Data container.
|
| GetIntValue(DataRow, String, Int32) |
Gets the integer variable from given DataRow.
|
| GetItemsCount |
Gets the items count in the specified data source.
|
| GetMaximumValue T (DataTable, String) |
Gets the maximum value from the given column.
|
| GetMaximumValue T (DataView, String) |
Gets the maximum value from the given column.
|
| GetMinimumValue T |
Gets the minimum value from the given column.
|
| GetNewItemsInList(String, String) |
Gets the list of new items in the given list as list separated by semicolon.
|
| GetNewItemsInList(String, String, Char) |
Gets the list of new items in the given list as list separated by separator.
|
| GetNotEmpty |
Returns 2nd parametr if first is null or "".
|
| GetNotZero(Object, Int32) |
Returns the object converted to integer or default value when the result of conversion equals zero.
|
| GetNotZero(Object, Object) |
Returns the object converted to integer or default value when the result of conversion equals zero.
|
| GetNull |
Converts the DBNull.value to standard null, keeps the object value if not null.
|
| GetObjectSize |
Gets the size of the given object.
|
| GetObjectString(Object, Int32) |
Gets the object as a string (for structured objects the object type and its size).
|
| GetObjectString(Object, Int32, Int32 ) |
Gets the object as a string (for structured objects the object type and its size).
|
| GetParentPath |
Returns the parent path for the specified path (any kind of path with "/" as a separator)
|
| GetPartialValue |
Gets value from string that has values separated by separator.
|
| GetRowSize |
Returns the row data size (size of the contained data).
|
| GetScalarValue |
Gets the first value from the given DataSet.
|
| GetSingleColumnDataSet |
Returns a DataSet containing single table with single column.
|
| GetSizeString(Int64) |
Returns the string for the specified file size.
|
| GetSizeString(Int64, FileSizeUnitsEnum) |
Returns the string for the specified file size.
|
| GetStringValue(ISimpleDataContainer, String) |
Gets the string variable from given data container.
|
| GetStringValue(DataRow, String, String) |
Gets the string variable from given DataRow.
|
| GetStringValues |
Gets the array of string values from the given data table.
|
| GetTableSize |
Returns the table data size (size of the contained data).
|
| GetTopNForPage |
Gets the TOPN value to be able to get the specific page out of the paged results with old paging (through TOPN only).
|
| GetType | Gets the (Inherited from Type of the current instance.Object.) |
| GetUniqueRows |
Gets the list of unique rows based on given column value.
|
| GetUniqueValues |
Gets the list of unique values based on given column value.
|
| GetValues ReturnType |
Gets the array of the values from the given data table.
|
| GetViewSize |
Returns the view data size (size of the contained data).
|
| ChangeBooleanValues(DataTable, String, Boolean, String) |
Changes the boolean value in the given table.
|
| ChangeBooleanValues(DataTable, String, Boolean, Boolean, String) |
Changes the boolean value in the given table.
|
| ChangeStringValues(DataTable, String, String, String) |
Changes the string value in the given table.
|
| ChangeStringValues(DataTable, String, String, String, String) |
Changes the string value in the given table.
|
| ChangeValuesToNull |
Changes the value in the given table to NULL.
|
| IsEmpty |
Returns true, if the given value is empty (null, DBNull, or "").
|
| IsValid |
Tests if value is valid to given data type
|
| IsValidID |
Returns true if the given value is a valid ID
|
| IsZero |
Returns true, if the given value is zero (null, DBNull, or 0).
|
| LockDataSet |
Makes the given DataSet read-only
|
| LowerCaseTableNames |
Converts the table names of given DataSet to lowercase representation.
|
| MarkDuplicitRows |
Marks the duplicit rows in the data table.
|
| MemberwiseClone | Creates a shallow copy of the current (Inherited from Object.Object.) |
| Merge T, K, V |
Merges two objects implementing the IDictionary interface of type T with key of type K and value of type V.
|
| MergeHashtables |
Merges two hashtables.
|
| ReadDataSetFromXml(DataSet, XmlReader, DataHelper ActionCallback, Object ) |
Reads the DataSet from given XML reader (expects "NewDataSet" as a root node).
|
| ReadDataSetFromXml(DataSet, XmlReader, DataHelper ActionCallback, Object , String, List String ) |
Reads the DataSet from given XML reader.
|
| ReadDataSetFromXml(DataSet, XmlReader, DataHelper ActionCallback, Object , String, List String , String) |
Reads the DataSet from given XML reader.
|
| ReduceDataSetData |
Reduces the data set data.
Works in two modes:
1 - remove recods (when calculateAverage is FALSE)
2 - calculate average values for the intervals (when calculateAverage is TRUE)
|
| RenameTable |
Renames the table in the given DataSet.
|
| RestrictRows(DataSet, Int32) |
Restricts the number of rows to the top N items.
|
| RestrictRows(DataSet, Int32, Int32, Int32 ) |
Restricts the given DataSet to only given rows starting with the offset, and leaving only maximum defined number of rows.
|
| SelectRowsByString |
Selects the table rows by string values.
|
| SetColumnValues |
Sets column values to specified value.
|
| SetDataRowValue |
Sets value to data row. If value is null, DBNull will be used.
|
| SetPartialValue |
Sets new value to string that is separates by separator.
|
| SetTableName |
Sets the table name in the specified DataSet.
|
| ShiftValuesUp |
Shifts the values in the column of Data table one row up.
|
| SortDataTable |
Sorts the Data table using given OrderBy expression.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| TransferTable |
Transfers tabls from source DataSet to the destination DataSet and sets the source table name to specified value.
|
| TransferTableRows |
Transfers table rows between two tables.
|
| TransferTables |
Transfers tables from source DataSet to the destination DataSet.
|
| TranslateBinaryColumn |
Translates the binary column within data table from its string representation to byte[].
|
| TrimDataSetPage |
Trims first data table from source to fit into page.
|
| TrimLastIdFromList(String) |
Trims last ID from ID list (delimited by semicolon). Returns trimmed list
|
| TrimLastIdFromList(String, Int32 ) |
Trims last ID from ID list. Returns trimmed list.
|
| TryGetDataRowValue |
Returns the value from the DataRow field.
|
| TryGetDataRowViewValue |
Returns the value from the DataRowView field.
|
| Union |
Creates the union of two Datasets, the values are compared for uniqueness by the given ID column name.
|
| WriteDataSetToXml |
Writes the DataSet from given XML reader.
|
Extension Methods
| Name | Description | |
|---|---|---|
 | AsValue |
Converts object to a query value which can be used as a query parameter
(Defined by QueryExtensions.) |
| GetAPIString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| GetString |
Gets the string by the specified resource key
(Defined by CoreExtensions.) |
| ToBoolean |
Returns the boolean representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDateTime |
Returns the DateTime representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToDouble |
Returns the double representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToGuid |
Returns the Guid representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToInteger |
Returns the integer representation of an object or default value if not.
(Defined by CoreExtensions.) |
| ToString |
Returns the string representation of an object or default value if not.
(Defined by CoreExtensions.) |
Fields
| Name | Description | |
|---|---|---|
 | DATETIME_NOT_SELECTED |
No datetime selected constant.
|
| FAKE_ID |
Fake ID to use when the ID column requires a value, and needs to be faked
|
See Also