SQL statements are ready, how to embed them in an executible file? do i need to use ado.net?
Posted on 2005-04-10
My task is:
1. build SQL statements to stored the result in a .csv file to my sql server table:
BULK INSERT mytable
2. move some files to other table
3. get a .exe (executable) file to be used in other program (windows service, etc), i.e. when user execute the .exe file, the step 1 and step 2 will be done.
I've finished step1 in SQL server 2000, also i can program the move file operation in C#, and now how to get a .exe file to combine above specifications in the easiest way? Some kind of embedded SQL statement? Do i still need to use ADO.NET to open a connection to database, etc? Thanks for any suggestions.