SQL create directories

Question

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(); keivn@upgrade1.com

Administrator · Answer

Hi, The easiest way to do any SQLServer stuff is to start by getting the SqlHelper classes from the Microsoft site. They remove the need to do as much typing as you would otherwise have to do. Write a stored proc that returns the data you want from the database Call one of the SqlHelper ExecuteDataset or ExecuteReader...whichever you are most comfortable with Iterate over the returned results and run your code as normal Cheers,

Administrator · Answer

Have a look at the Quickstart tutorials on how to connect to the database, get your data into something like a SqlDataReader and loop through the reader creating each of the files. Have a go, and if you get stuck post your code and we can help you.

SQL create directories

Answers (2)