SQL create directories - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQL create directories

kvnsdrkvnsdr Posts: 9Member
I have a list of names in my SQL database("Books"), datatable("BookName") that I would like to use to create directories on my computer. The following code work excellent using a .txt file of the book names, however the SQL database has the same identical list of names. I'd like to use the SQL instead of the .txt file approach... Help...........


string strSource = (@"C:ookName.txt");
DirectoryInfo source = new DirectoryInfo(strSource);
string strTarget = (@"C:ooks");
DirectoryInfo target = new DirectoryInfo(strTarget);

StreamReader sr = File.OpenText(strSource);
string read;
while ((read = sr.ReadLine()) != null)
{
target.CreateSubdirectory(read);
}
sr.Close();

[email protected]

Comments

  • kvnsdrkvnsdr Posts: 9Member
    : I have a list of names in my SQL database("Books"), datatable("BookName") that I would like to use to create directories on my computer. The following code work excellent using a .txt file of the book names, however the SQL database has the same identical list of names. I'd like to use the SQL instead of the .txt file approach... Help...........
    :
    :
    : string strSource = (@"C:ookName.txt");
    : DirectoryInfo source = new DirectoryInfo(strSource);
    : string strTarget = (@"C:ooks");
    : DirectoryInfo target = new DirectoryInfo(strTarget);
    :
    : StreamReader sr = File.OpenText(strSource);
    : string read;
    : while ((read = sr.ReadLine()) != null)
    : {
    : target.CreateSubdirectory(read);
    : }
    : sr.Close();
    :
    :
    :

Sign In or Register to comment.