2
Answers

SQL create directories

Ask a question
Administrator

Administrator

21y
4.4k
1
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:\bookName.txt"); DirectoryInfo source = new DirectoryInfo(strSource); string strTarget = (@"C:\books\"); DirectoryInfo target = new DirectoryInfo(strTarget); StreamReader sr = File.OpenText(strSource); string read; while ((read = sr.ReadLine()) != null) { target.CreateSubdirectory(read); } sr.Close(); [email protected]

Answers (2)