I am trying to created an automated create Stored Procedure routine in VB.Net, but the SQL code is a tad long and a pain to manually add into a string. Is there a way I can save the TSQL code as a Text file then embed the file into the VB.Net project/executable and then recall it? In other words, recall the embedded text file and dump it's contents into a string, then use that string in my Create Procedure routine...?
Please help, thanks in advanced.
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook
