Direct Database Operation Procedures

FieldValue

Returns a field value from a DataRow. DataRow and field name should be specified

GetDateValue

Run the Select query and returns the date value. SQL query and parameters should be provided

GetDecimalValue

Run the Select query and returns the decimal value. SQL query and parameters should be provided

GetIntValue

Run the Select query and returns the int value. SQL query and parameters should be provided

GetLongValue

Run the Select query and returns the long value. SQL query and parameters should be provided

GetRows

Run the Select query and returns the list of DataRow objects. SQL query and parameters should be provided

GetScalarValue

Run the Select query and returns a single scalar value. . SQL query and parameters should be provided. The return type can be specified by user other than string.

GetStringValue

Run the Select query and returns the string value. SQL query and parameters should be provided

RunQuery

Run the SQL (Update or Delete) query. SQL query and parameters should be provided