This class is a helper class for dealing data values. It is intended to be a static helper class only.
| Name | Description |
|---|
 | GetValueFromRowAsDateTime(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsDateTime(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullTimeSpan(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullTimeSpan(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullTimeSpan(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsTimeSpan(System.Data.DataRow, System.String) | |
| GetValueFromRowAsTimeSpan(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsTimeSpan(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsGuid(System.Data.DataRow, System.String) |
Will get the data value from the row as a Guid. If the value is null an will be thrown
This procedure assumes that the data is a Guid, if not a cast exception will be thrown.
|
| GetValueFromRowAsGuid(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsGuid(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullGuid(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable Guid. The return value will be set to either null or the Guid value
This procedure assumes that the data is a Guid, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullGuid(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullGuid(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsChar(System.Data.DataRow, System.String) | |
| GetValueFromRowAsChar(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsChar(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullChar(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullChar(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullChar(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsRowVersion(System.Data.DataRow, System.String) | |
| GetValueFromRowAsRowVersion(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsRowVersion(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsBinary(System.Data.DataRow, System.String) | |
| GetValueFromRowAsBinary(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsBinary(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRow(System.Data.DataRow, System.String) |
Will get the data value from the row as an object retuning the .NET null value in the event the data value is
null in the DataRow.
|
| GetValueFromRow(System.Data.DataRow, System.Data.DataColumn) |
Will get the data value from the row as an object retuning the .NET null value in the event the data value is
null in the DataRow.
|
| GetValueFromRow(System.Data.DataRow, System.Int32) |
Will get the data value from the row as an object retuning the .NET null value in the event the data value is
null in the DataRow.
|
| GetValueFromRowAsString(System.Data.DataRow, System.String, System.Boolean) |
Will get the data value from the row as a string. The return value will be set to either null or and empty string depending
on the value of ReturnNullAsEmptyString
|
| GetValueFromRowAsString(System.Data.DataRow, System.Int32, System.Boolean) |
Will get the data value from the row as a string. The return value will be set to either null or and empty string depending
on the value of ReturnNullAsEmptyString
|
| GetValueFromRowAsString(System.Data.DataRow, System.Data.DataColumn, System.Boolean) | |
| GetValueFromRowAsNullInt(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable int. The return value will be set to either null or the int value
This procedure assumes that the data is an integer, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullInt(System.Data.DataRow, System.Data.DataColumn) |
Will get the data value from the row as a nullable int. The return value will be set to either null or the int value
This procedure assumes that the data is an integer, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullInt(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullUInt(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullUInt(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullUInt(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsInt(System.Data.DataRow, System.String) |
Will get the data value from the row as an int. If the value is null an will be thrown
This procedure assumes that the data is an integer, if not a cast exception will be thrown.
|
| GetValueFromRowAsInt(System.Data.DataRow, System.Data.DataColumn) |
Will get the data value from the row as an int. If the value is null an will be thrown
This procedure assumes that the data is an integer, if not a cast exception will be thrown.
|
| GetValueFromRowAsInt(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsUInt(System.Data.DataRow, System.String) | |
| GetValueFromRowAsUInt(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsUInt(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullDecimal(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable Decimal. The return value will be set to either null or the Decimal value
This procedure assumes that the data is an Decimaleger, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullDecimal(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullDecimal(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsDecimal(System.Data.DataRow, System.String) |
Will get the data value from the row as an Decimal. If the value is null an will be thrown
This procedure assumes that the data is an Decimaleger, if not a cast exception will be thrown.
|
| GetValueFromRowAsDecimal(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsDecimal(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullDouble(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable Double. The return value will be set to either null or the Double value
This procedure assumes that the data is an Double, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullDouble(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullDouble(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsDouble(System.Data.DataRow, System.String) |
Will get the data value from the row as an Double. If the value is null an will be thrown
This procedure assumes that the data is an Double, if not a cast exception will be thrown.
|
| GetValueFromRowAsDouble(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsDouble(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullFloat(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullFloat(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullFloat(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsFloat(System.Data.DataRow, System.String) | |
| GetValueFromRowAsFloat(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsFloat(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullLong(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable long. The return value will be set to either null or the long value
This procedure assumes that the data is an long, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullLong(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullLong(System.Data.DataRow, System.Data.DataColumn) |
Will get the data value from the row as a nullable long. The return value will be set to either null or the long value
This procedure assumes that the data is an long, if not a cast exception will be thrown.
|
| GetValueFromRowAsLong(System.Data.DataRow, System.String) |
Will get the data value from the row as an long. If the value is null an will be thrown
This procedure assumes that the data is an long, if not a cast exception will be thrown.
|
| GetValueFromRowAsLong(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsLong(System.Data.DataRow, System.Data.DataColumn) |
Will get the data value from the row as an long. If the value is null an will be thrown
This procedure assumes that the data is an long, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullULong(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullULong(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullULong(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsULong(System.Data.DataRow, System.String) | |
| GetValueFromRowAsULong(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsULong(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsBool(System.Data.DataRow, System.String) |
Will get a the data value from the data row as a bool. If a DB Null is found then throw a NullException
|
| GetValueFromRowAsBool(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsBool(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsBool(System.Data.DataRow, System.String, System.Boolean) |
Will get a the data value from the data row as a bool. If a DB Null is found then it will return the default bool value defined in DefaultReturnValueIfNull
|
| GetValueFromRowAsNullBool(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullBool(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullBool(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullShort(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable short. The return value will be set to either null or the short value
This procedure assumes that the data is a short, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullShort(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullShort(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsUShort(System.Data.DataRow, System.String) | |
| GetValueFromRowAsUShort(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsUShort(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullUShort(System.Data.DataRow, System.String) | |
| GetValueFromRowAsNullUShort(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullUShort(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsShort(System.Data.DataRow, System.String) |
Will get the data value from the row as an short. If the value is null an will be thrown
This procedure assumes that the data is an short, if not a cast exception will be thrown.
|
| GetValueFromRowAsShort(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsShort(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullSbyte(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable sbyte. The return value will be set to either null or the sbyte value
This procedure assumes that the data is a sbyte, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullSbyte(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullSbyte(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsSbyte(System.Data.DataRow, System.String) |
Will get the data value from the row as an sbyte. If the value is null an will be thrown
This procedure assumes that the data is an sbyte, if not a cast exception will be thrown.
|
| GetValueFromRowAsSbyte(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsSbyte(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullByte(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable short. The return value will be set to either null or the short value
This procedure assumes that the data is a short, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullByte(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullByte(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsByte(System.Data.DataRow, System.String) |
Will get the data value from the row as an byte. If the value is null an will be thrown
This procedure assumes that the data is an byte, if not a cast exception will be thrown.
|
| GetValueFromRowAsByte(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsByte(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsNullDateTime(System.Data.DataRow, System.String) |
Will get the data value from the row as a nullable short. The return value will be set to either null or the short value
This procedure assumes that the data is a short, if not a cast exception will be thrown.
|
| GetValueFromRowAsNullDateTime(System.Data.DataRow, System.Int32) | |
| GetValueFromRowAsNullDateTime(System.Data.DataRow, System.Data.DataColumn) | |
| GetValueFromRowAsDateTime(System.Data.DataRow, System.String) |
Will get the data value from the row as an DateTime. If the value is null an will be thrown
This procedure assumes that the data is an DateTime, if not a cast exception will be thrown.
|
DataHelper Class 
Methods