public static MyFile ListDrive(string drive)
{
DirectoryInfo di = new DirectoryInfo(@drive);
MyFile root = new MyFile(Iterator, drive, 1, -1);
SqlCommand myCommand = new SqlCommand("INSERT INTO table (id, name,is_directory,parent) " +
"Values (" + Iterator + "," + drive + ",1,-1)", conn);
myCommand.ExecuteNonQuery();
ListDriveRec(di, Iterator++);
return root;
}
public static MyFile ListDrive(string drive)
{
DirectoryInfo di = new DirectoryInfo(@drive);
MyFile root = new MyFile(Iterator, drive, 1, -1);
SqlCommand myCommand = new SqlCommand("INSERT INTO table (id, name,is_directory,parent) " +
"Values (" + Iterator + "," + drive + ",1,-1)", conn);
myCommand.ExecuteNonQuery();
ListDriveRec(di, Iterator++);
return(root);
}
public static void ListDriveRec(DirectoryInfo dir, int parent)
{
// Subdirs
try // Avoid errors such as "Access Denied"
{
foreach (DirectoryInfo iInfo in dir.GetDirectories())
{
MyFile file = new MyFile(Iterator++, iInfo.Name, 1, parent);
SqlCommand myCommand = new SqlCommand("INSERT INTO table (id, name,is_directory,parent) " +
"Values (" + Iterator + "," + iInfo.Name + ",1,"+parent+ ")", conn);
myCommand.ExecuteNonQuery();
ListDriveRec(iInfo, Iterator);
}
}
catch (Exception e)
{
LogWriter.WriteLine(e.ToString());
}
// Subfiles
try // Avoid errors such as "Access Denied"
{
foreach (FileInfo iInfo in dir.GetFiles())
{
MyFile file = new MyFile(Iterator++, iInfo.Name, 0, parent);
SqlCommand myCommand = new SqlCommand("INSERT INTO table (id, name,is_directory,parent) " +
"Values (" + Iterator + "," + iInfo.Name + ",0," + parent + ")", conn);
myCommand.ExecuteNonQuery();
}
}
catch (Exception e)
{
LogWriter.WriteLine(e.ToString());
}
}