public override IdhtmlxConnector CreateConnector(HttpContext context) { dhtmlxTreeConnector connector = new dhtmlxTreeConnector( "SELECT * FROM Folders", "item_id", "item_parent_id", dhtmlxDatabaseAdapterType.SqlServer2005, ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString, "item_nm" ); connector.RootItemRelationIDValue = "0"; //Set ParentID value for root items return connector; }
public override IdhtmlxConnector CreateConnector(HttpContext context) { dhtmlxTreeConnector connector = new dhtmlxTreeConnector( "Folders", "item_id", "item_parent_id", dhtmlxDatabaseAdapterType.SqlServer2005, ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString, "item_nm" ); connector.RootItemRelationIDValue = "0"; //Set ParentID value for root items //add rule that will exclude hidden files from result connector.Request.Rules.Add(new FieldRule("is_hidden", Operator.NotEquals, true)); connector.BeforeOutput += new EventHandler<RenderEventArgs>(connector_BeforeOutput); return connector; }
protected void Page_Load(object sender, EventArgs e) { //Create and configure connector dhtmlxTreeConnector connector = new dhtmlxTreeConnector( "Folders", "item_id", "item_parent_id", dhtmlxDatabaseAdapterType.SqlServer2005, ConfigurationManager.ConnectionStrings["SamplesDatabase"].ConnectionString, "item_nm" ); connector.RootItemRelationIDValue = "0"; //Set ParentID value for root items connector.EnableDynamicLoading = true; //Process client request connector.ProcessRequest(this.Request.QueryString, this.Request.Form); //Render response this.Response.Clear(); connector.RenderResponse(this.Response); this.Response.End(); }