Administrator

Administrator

  • Tech Writer
  • 2.2k
  • 1.5m

SQL create directories

Apr 15 2003 9:49 AM
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)