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

HierarchyDataLoadFromDatabase Method (String, DBMSType, String, String, String) Chart4.NET - Organization Charting Component (C#/VB.NET/ASP.NET) - Documentation

Onlinewww.Chart4.NET (Documentation) | OnlineSamples Download | Release Notes

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++

View Colorized 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

View Colorized 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: OnlineSystemString
The database connection string

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

TableName: Type: OnlineSystemString
Name of the table

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

WhereCondition: Type: OnlineSystemString
The CONDITION column name in the table

Return Value

Returns blank if succeeded, error message otherwise.