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

HierarchyData LoadFromDatabase Method (DbConnection, 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(
	DbConnection Connection,
	string TableName,
	string[] FieldsArray,
	string WhereCondition
)

public string LoadFromDatabase(
	DbConnection Connection,
	string TableName,
	string[] FieldsArray,
	string WhereCondition
)

Public Function LoadFromDatabase ( _
	Connection As DbConnection, _
	TableName As String, _
	FieldsArray As String(), _
	WhereCondition As String _
) As String

Public Function LoadFromDatabase ( _
	Connection As DbConnection, _
	TableName As String, _
	FieldsArray As String(), _
	WhereCondition As String _
) As String

public:
String^ LoadFromDatabase(
	DbConnection^ Connection, 
	String^ TableName, 
	array<String^>^ FieldsArray, 
	String^ WhereCondition
)

public:
String^ LoadFromDatabase(
	DbConnection^ Connection, 
	String^ TableName, 
	array<String^>^ FieldsArray, 
	String^ WhereCondition
)

member LoadFromDatabase : 
        Connection : DbConnection * 
        TableName : string * 
        FieldsArray : string[] * 
        WhereCondition : string -> string

member LoadFromDatabase : 
        Connection : DbConnection * 
        TableName : string * 
        FieldsArray : string[] * 
        WhereCondition : string -> string

Copy to Clipboard Print

public String LoadFromDatabase(
	DbConnection Connection,
	String TableName,
	String[] FieldsArray,
	String WhereCondition
)

public String LoadFromDatabase(
	DbConnection Connection,
	String TableName,
	String[] FieldsArray,
	String WhereCondition
)

Parameters

Connection: Type: System.Data.Common DbConnection
The database connection object

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.