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);
while ((read = sr.ReadLine()) != null)