Sql File in DLL problem
-
Hi all, i have SQL script that i will execute it in class and i have to add this SQL file to the class ,but i need no one else see this file ,so i make the copy option to be"Do not copy" , but i use this file to read from it ,so when i use the created dll in another solution , it can't find that file what exactly shall i do? your answers will be appreciated Thank you
-
Hi all, i have SQL script that i will execute it in class and i have to add this SQL file to the class ,but i need no one else see this file ,so i make the copy option to be"Do not copy" , but i use this file to read from it ,so when i use the created dll in another solution , it can't find that file what exactly shall i do? your answers will be appreciated Thank you
I think your SQL file is inside the Project so when you use the dll in the project . you find it but when you try to use the same DLL from another project it does not give you path. So two solutions. 1. encrypt the file and let it be with copy on the system. and decrypt it when required. 2. make a function in the class and it will hold the query in string array and will return it back to you when you call it or directly run it when you pass some required parameters. Rizwan Bashir
-
I think your SQL file is inside the Project so when you use the dll in the project . you find it but when you try to use the same DLL from another project it does not give you path. So two solutions. 1. encrypt the file and let it be with copy on the system. and decrypt it when required. 2. make a function in the class and it will hold the query in string array and will return it back to you when you call it or directly run it when you pass some required parameters. Rizwan Bashir
-
thank you Rizwan , can u guide me how to do the encryption? so that when file exist in the customer's machine can't be opened!!!
try google. you will find million of exmaples http://www.google.com.pk/search?hl=en&q=encryption+vb.net&meta=[^]