This is a migrated thread and some comments may be shown as answers.

DNN File "Explorer"

19 Answers 226 Views

Miscellaneous

This is a migrated thread and some comments may be shown as answers.

19 Answers, 1 is accepted

answered on 23 Nov 2005, 09:04 AM

It sure does look like a great project! Very nice.

I have a question regarding this, although it is not the same kind of project.
I also use a r.a.d.treeview and a r.a.d.grid (used the telerik example as starting point) to show folders and files.

The difference is that I store everything inside SQL Server 2005. So I have one table that contains the folder structure (DocumentGroups) and one table that contains the files (Documents).

I really like this approach, because I can use the SQL 2005 caching functions and the r.a.d.callback controls to make this a very fast solution...

Now my question: when a user loads the page with this solution then he/she will see the r.a.d.treeview on the left with the 'directory' structure. Works very nice. But: I want to be able to put a value behind every node that shows how much files are saved for that particular node.

So then you will see something like this:

    Root Folder (0)
        Documents (4)
            Folder A (2)
            Folder B (2)

Maybe this is not a question for this forum, but I can't figure out how to do this inside a stored procedure. It has to do something with a recursive lookup, but I find it very difficult to create the right stored procedure. I want to select all the DocumentGroups at once, so that I only have to make one request to the database.

So, I hope you guys could think with me and maybe we can find a solutions. That would be very nice!

Thanks anyway,
Daniel

answered on 25 Nov 2005, 04:38 PM

Hello Daniel,

You can traverse all tree-nodes in Page_Load by using the GetAllNodes() method of r.a.d.treeview and add the number of child nodes to the parent node's Text using code similar to:

...
protected override Page_Load(object sender, EventArgs e)
{
     if (!Page.IsPostBack)
     {
         ArrayList allNodes = RadTree1.GetAllNodes();

        foreach (RadTreeNode node in allNodes)
         {
             if (node.Nodes.Count > 0)
                 node.Text = node.Text + " (" + node.Nodes.Count.ToString() + ")";
         }
     }
}
...

Hope this helps.

Best wishes,
Nick
the telerik team

www.telerik.com | www.sharepointcontrols.com | www.sitefinity.com | www.mcmscontrols.com

answered on 25 Nov 2005, 07:11 PM

Thanks for the reply.
Unfortunately this is not exactly what I'm looking for.

I don't want to count the nodes in the treeview but records that are linked to a node.

For example: take a look at a windows explorer window. You can see the folder structure and on the right the files that are in a particular folder.
I have the same kind of view but then I store both my 'DocumentGroups' (the folders) and my 'Documents' (the files) into a SQL database.

So I want to see on each node how many items are "under" it.
I find it hard to explain, but maybe I can give a link to an example on the internet: http://communityserver.org/files/40/themes_and_skins/category1025.aspx

Maybe then you can understand what result I want...

The difference is that I have 2 tables.

1) DocumentGroups
2) Documents

They are related to eachother. So 1 documentgroup can have 1 one more documents.

Hope this explains my problem a bit more?

answered on 28 Nov 2005, 03:35 PM

Hello Daniel,

Counting child nodes in a recursive SQL relation can be a bit tricky indeed. We have something similar to that in our load on demand SQL online example - here is our sample SQL:

tring sql = @"SELECT
                            Nodes.Id AS NodeId, Nodes.Text AS NodeText, COUNT(Children.Id) AS HasChildren
                        FROM
                            Nodes
                        LEFT JOIN
                            Nodes Children
                        ON
                            Nodes.Id = Children.ParentId
                        WHERE
                            Nodes.ParentId = {0}
                        GROUP BY
                            Nodes.Id, Nodes.Text";

This query gets the count of child nodes for a particular node. Still I believe the easiest way to implement this is to first bind the tree and then using recusrsion to count down the node subtree and update the text of the node there using the server-side API of the treeview rather than SQL.

Have a nice day,
Elton
the telerik team

www.telerik.com | www.sharepointcontrols.com | www.sitefinity.com | www.mcmscontrols.com

answered on 30 Jan 2006, 11:06 AM

telerik_0008.jpg

Nice work, Oliver!!! We will gladly post the example on our site, once you have the final version released.

A couple of things we found:
You had one of our paid versions uploaded in My Pictures -> My Pictures -> Level 3 -> Level 4. We tried to delete the file, but got JS errors. "Move to Trash" did not work either (the page did not refresh at all). For this reason we deleted the folder, which worked great.

Note, that we were able to upload our files and create new folders without any problems whatsoever. File deletion worked occasionally - we will have to look in our browser settings to see whether the problem is related to some browser settings. The JS error which we got is attached.

Other than that - the application looks very cool - thank you for your efforts! We will review the code and let you know what we think. What do you think of the idea to add skin support and maybe even drag and drop between treeview and grid?

Best wishes,
Robert
the telerik team

www.telerik.com | www.sharepointcontrols.com | www.sitefinity.com | www.mcmscontrols.com

answered on 30 Jan 2006, 06:03 PM

The version on my website is a few builds behind right now. I sent you guys the latest version in a support ticket late lastnight. I'll upload my latest version shortly which hopefully has things issues fixed.

EDIT: I'm glad the delete folder worked out. I'm noticing the issues with the delete files now. The grid isn't getting an updated viewstate (I think), this was working fine before the latest round of hotfixes. I'm going to triple check my ControlsToUpdate function, I might be excluding it at some point where it really needs to get updated. The delete file function only works when you're in either the root folder, or a direct child. Any LOD folders won't delete the files.

Adding Skin and Drag and Drop are definitely on my list. However for the first public release I wanted to keep it pretty simple, then I'm planning on adding things like this into the module after I get some feedback.

answered on 11 Apr 2006, 04:58 PM

Hello,
Sorry for the few months without any word on my module. I've finally finished (hopefully) everything for a stable release. I've also written a brief overview of the control (which I'm working on expanding as we speak)

The main reason for the delay, was the latest Q release from Telerik. They fixed tons of bugs which were delaying this control. After getting everything upgraded (mainly the callback 2.0) seemed to fix 99% of my issues.

You can view the full running sample on my Explorer Website. I've got a couple smaller things to finish up (mainly docs), but hopefully this sucker will get released before the end of the week!

Let me know what you guys think

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

DNN File "Explorer"

19 Answers, 1 is accepted