Directories are recursive. IOW, a directory can contain a fairly deep tree
of directories.
This means that code to look into directories is nearly always written in a
recursive method. This is much better way to do it because the code is
simpler and easier to debug.
For the sake of making this code simpler, I'm assuming that two classes
exist in the project: DocRecord and DirRecord that contain properties for
the fields you've defined. I'll demonstrate the jist of creating a set of
records of each type and adding them to seperate collections.
calling method:
// caveat: uncompiled air code
MyDirectoryColl ection.Clear(); // clear out our class-level collection
of directories
MyFileCollectio n.Clear(); // clear out our class-level collection of
files
DirectoryNumber = 0; // class-level variable
FillDirectoryCo llections(@"c:\ MyRootDir", 0);
recursive method:
private void FillDirectoryCo llections(strin g startingdir, int
CurrentDirId)
{
foreach (string fname in Directory.GetFi les(startingdir ))
{
DocRecord dr = new DocRecord(); // see note above about
assumed classes.
dr.FileName = fname;
dr.DirId = CurrentDirId;
MyFileCollectio n.Add(dr);
}
foreach (string dname in Directory.GetDi rectories(start ingdir))
{
DirRecord ddr = new DirRecord(); // assume that the
DirRecord class has logic to create a new dir id when the object is created
ddr.TopID = CurrentDirId;
ddr.DirName = dname;
MyDirCollection .Add(ddr);
// now for the recursion
FillDirectoryCo llections(dname ,ddr.DirId); // pass in
subdir and it's id
}
}
That's pretty much it. If you take a look at the recursive method, then the
FillDirectoryCo llections method is called by the root directory and each
directory under it. As the comments imply, I assumed that creating an
object of type DirRecord would have the class itself generate the unique id.
The same goes for DocRecord. The difference is that I actually _use_ the id
created for DirRecord in the call to get the subdirectories.
Caveat: this is air code. I'm trying to illustrate the point. Please
forgive syntax errors if any are found.
--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"huzz" <hu**@discussio ns.microsoft.co m> wrote in message
news:5C******** *************** ***********@mic rosoft.com...
I need to write script in c# that will scan directories for files and
insert
the files and directory names in the database.. I've have two tables
tblDir
and tblDocs.
Example:
-Directory1
a_file1
a_file2
Directory1_1
b_file1
b_file2
-Directory2
a_file1
a_file2
Directory2_1
b_file1
b_file2
root_file1
root_file2
I want to record the file and directory list as shown below:
tblDir
---------------------------------
id | TopID | DirName |
---------------------------------
1 0 Directory1
2 1 Directory1_1
3 0 Directory2
4 2 Directory2_1
tblDocs
-----------------------------------
id | DirID | FileName |
-----------------------------------
1 0 root_file1
2 0 root_file2
3 1 a_File1
4 1 a_File2
5 2 b_File1
6 2 b_File1
7 3 a_File1
8 3 a_File2
9 4 b_File1
10 4 b_File1
Here is my codes.. i seem to be getting the folder records in a wrong
place.. please help.
int FolderID = 0;
foreach (string f in Directory.GetFi les(sDir))
{
file = f.Substring(f.L astIndexOf("\\" )+1);
if(!doc.DocExis t(DepID,FolderI D,file))
{
doc.AddDoc(DepI D,FolderID,file );
}
}
foreach (string d in Directory.GetDi rectories(sDir) )
{
folder = d.Substring(d.L astIndexOf("\\" )+1);
if(!doc.FolderE xist(DepID,Fold erID,folder))
{
FolderID = doc.AddFolder(D epID,FolderID,f older);
}
foreach (string f in Directory.GetFi les(d))
{
folder = d.Substring(d.L astIndexOf("\\" )+1);
file2 = f.Substring(f.L astIndexOf("\\" )+1);
FolderID = doc.GetFolderID (folder);
if(!doc.DocExis t(DepID,FolderI D,file2))
{
DocID = doc.AddDoc(DepI D,FolderID,file 2);
}
}
DirSearch(d,Dep ID);
}
