Click or drag to resize
Format Class
Formatter methods for the DataTables Editor. All of the methods in this class return a delegate that can be used in the
GetFormatter
and
SetFormatter
methods of the
Field
class. Each method may define its own parameters that configure how the formatter operates. For example the date / time formatters take information on the formatting to be used.
Inheritance Hierarchy
SystemObject
  DataTablesFormat

Namespace:  DataTables
Assembly:  DataTables (in DataTables.dll) Version: 1.6.5.0 (1.6.5.0)
Syntax
C#
public static class Format

The Format type exposes the following members.

Methods
  NameDescription
Public methodStatic memberDateFormatToSql
Convert to SQL date / date time format (ISO8601) from a format given by the options parameter.
Public methodStatic memberDateSqlToFormat
Convert from SQL date / date time format (ISO8601) to a format given by the options parameter.
Public methodStatic memberDateTime
Convert from one date time format to another
Public methodStatic memberExplode
Convert a string of values into an array for use with checkboxes.
Public methodStatic memberFromDecimalChar
Convert a number from using any character other than a period (dot) to one which does use a period.This is useful for allowing numeric user input in regions where a comma is used as the decimal character. Use with a set formatter.
Public methodStatic memberIfEmpty
Convert an empty string to `null`. Null values are very useful in databases, but HTTP variables have no way of representing `null` as a value, often leading to an empty string and null overlapping. This method will check the value to operate on and return null if it is empty.
Public methodStatic memberImplode
Convert an array of values from a checkbox into a string which can be used to store in a text field in a database.
Public methodStatic memberNullEmpty
Convert an empty string to `null`. Null values are very useful in databases, but HTTP variables have no way of representing `null` as a value, often leading to an empty string and null overlapping. This method will check the value to operate on and return null if it is empty.
Public methodStatic memberToDecimalChar
Convert a number with a period (dot) as the decimal character to use a different character(typically a comma). Use with a get formatter.
Top
Fields
  NameDescription
Public fieldStatic memberDATE_ISO_1036
Date format: Fri, 9 Mar 12. jQuery UI equivalent format: D, d M y
Public fieldStatic memberDATE_ISO_1123
Date format: Fri, 9 Mar 2012. jQuery UI equivalent format: D, d M yy
Public fieldStatic memberDATE_ISO_2822
Date format: Fri, 9 Mar 2012. jQuery UI equivalent format: D, d M yy
Public fieldStatic memberDATE_ISO_822
Date format: Fri, 9 Mar 12. jQuery UI equivalent format: D, d M y
Public fieldStatic memberDATE_ISO_850
Date format: Friday, 09-Mar-12. jQuery UI equivalent format: DD, dd-M-y
Public fieldStatic memberDATE_ISO_8601
Date format: 2012-03-09. jQuery UI equivalent format: yy-mm-dd
Top
See Also