Click or drag to resize

Database Class

SOWI database settings based on XML
Inheritance Hierarchy
SystemObject
  SIC.FileXMLDatabase
    SIC.ConfigurationDatabase

Namespace:  SIC.Configuration
Assembly:  SIC (in SIC.dll) Version: 19.1.23.1 (19.1.23.622)
Syntax
public class Database : XML<Database>

The Database type exposes the following members.

Constructors
  NameDescription
Public methodDatabase
Initializes a new instance of the Database class. Constructor with parameter
Top
Properties
Methods
  NameDescription
Public methodCount
Gives number of all exist data item in DataTable object (XML)
(Inherited from XMLDataItemClass.)
Public methodCount(String)
Gives number of exist data item by Name
(Inherited from XMLDataItemClass.)
Private methodCreateItem (Inherited from XMLDataItemClass.)
Public methodDelete
Delete a data item by field Name
(Inherited from XMLDataItemClass.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Private methodExistColumn
Checked exists column by name in the table
(Inherited from XMLDataItemClass.)
Public methodExistOne
Check exist one data item by Name
(Inherited from XMLDataItemClass.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetAll
Get all data items
(Inherited from XMLDataItemClass.)
Public methodGetByName
Gives a data item by Name
(Inherited from XMLDataItemClass.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Protected methodGetTableFields
Gives a list of type PropertyInfo from the table fields
(Inherited from XMLDataItemClass.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodInsert
Insert data item into datatable and store in xml file
(Inherited from XMLDataItemClass.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodRead
Load xml file when exist and put data table structure setting xml
(Inherited from XMLDataItemClass.)
Public methodSaveAs
Data items save to file
(Inherited from XMLDataItemClass.)
Private methodSetDataTable
Requirement: object DataTable not be null.
(Inherited from XMLDataItemClass.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUpdate
Sets value into datatable and store in xml file
(Inherited from XMLDataItemClass.)
Protected methodWrite
Data items save to file
(Inherited from XMLDataItemClass.)
Top
Extension Methods
  NameDescription
Public Extension MethodGetObjectToBytes
Convert an object to byte array
(Defined by Extensions.)
Public Extension MethodIsNumber
Check is value a number
(Defined by Convert.)
Public Extension MethodToHTMLDisplay(DataGrid, TempDataDictionary)Overloaded. (Defined by Extensions.)
Public Extension MethodCode exampleToHTMLDisplay(String, DataGridDataTypes, String, String, String, String, TempDataDictionary)Overloaded.
Gives HTML code for display.
(Defined by Extensions.)
Public Extension MethodToHTMLEditor(DataGrid, TempDataDictionary, String)Overloaded. (Defined by Extensions.)
Public Extension MethodToHTMLEditor(String, DataGridDataTypes, String, String, String, TempDataDictionary, Boolean, String, DataPlacements, String, String)Overloaded.
Gives HTML code for Input field
(Defined by Extensions.)
Public Extension MethodCode exampleToHTMLHidden(String)Overloaded.
Gives HTML code for hidden data
(Defined by Extensions.)
Public Extension MethodToHTMLHidden(DataGrid)Overloaded.
Gives HTML code for hidden data
(Defined by Extensions.)
Public Extension MethodXMLWrite
Gives XML string from data item
(Defined by Helper.)
Top
Remarks
This class based on SOWI XML file handling with SOWI database settings data structure.

The file must have the appropriate permissions (read/write).

See Also