public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxTreeGridConnector connector = new dhtmlxTreeGridConnector(
"Folders", "item_nm,item_order,item_desc", "item_id", "item_parent_id",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.RootItemRelationIDValue = "0";//Set ParentID value for root items
return connector;
}
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
//select only folders that has children + their children themselves
dhtmlxTreeGridConnector connector = new dhtmlxTreeGridConnector(
"SELECT item_nm, item_order, item_desc from Folders WHERE is_hidden = 0",
"item_id",
"item_parent_id",
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString
);
connector.RootItemRelationIDValue = "0";//Set ParentID value for root items
return connector;
}
