LoadFromDatabase Method (String, DBMSType, String, String[], String)

HierarchyData LoadFromDatabase Method (String, DBMSType, String, String , String)

Chart4.NET - Organization Charting Component (C#/VB.NET/ASP.NET) - Documentation

Loads data from a database table. See HierarchyData class description for the table format.

Namespace: UnifoChart.Hierarchy
Assembly: UnifoChart.Hierarchy (in UnifoChart.Hierarchy.dll) Version: 5.1.0.0 (5.1.0)

Syntax

C++

Copy to Clipboard Print

public string LoadFromDatabase(
	string ConnectionString,
	DBMSType DBMSType,
	string TableName,
	string[] FieldsArray,
	string WhereCondition
)

public string LoadFromDatabase(
	string ConnectionString,
	DBMSType DBMSType,
	string TableName,
	string[] FieldsArray,
	string WhereCondition
)

Public Function LoadFromDatabase ( _
	ConnectionString As String, _
	DBMSType As DBMSType, _
	TableName As String, _
	FieldsArray As String(), _
	WhereCondition As String _
) As String

Public Function LoadFromDatabase ( _
	ConnectionString As String, _
	DBMSType As DBMSType, _
	TableName As String, _
	FieldsArray As String(), _
	WhereCondition As String _
) As String

public:
String^ LoadFromDatabase(
	String^ ConnectionString, 
	DBMSType DBMSType, 
	String^ TableName, 
	array<String^>^ FieldsArray, 
	String^ WhereCondition
)

public:
String^ LoadFromDatabase(
	String^ ConnectionString, 
	DBMSType DBMSType, 
	String^ TableName, 
	array<String^>^ FieldsArray, 
	String^ WhereCondition
)

member LoadFromDatabase : 
        ConnectionString : string * 
        DBMSType : DBMSType * 
        TableName : string * 
        FieldsArray : string[] * 
        WhereCondition : string -> string

member LoadFromDatabase : 
        ConnectionString : string * 
        DBMSType : DBMSType * 
        TableName : string * 
        FieldsArray : string[] * 
        WhereCondition : string -> string

Copy to Clipboard Print

public String LoadFromDatabase(
	String ConnectionString,
	DBMSType DBMSType,
	String TableName,
	String[] FieldsArray,
	String WhereCondition
)

public String LoadFromDatabase(
	String ConnectionString,
	DBMSType DBMSType,
	String TableName,
	String[] FieldsArray,
	String WhereCondition
)

Parameters

ConnectionString: Type: System String
The database connection string

DBMSType: Type: UnifoChart.Hierarchy DBMSType
Type of the Database Management System

TableName: Type: System String
Name of the table

FieldsArray: Type: System String
Array of column names in the order of IdField, ParentIdField, TextField, ValueField, ToolTipField, ImageFileField, UrlField, TagField

WhereCondition: Type: System String
The CONDITION column name in the table

Return Value

Returns blank if succeeded, error message otherwise.