Hi,
I have a .sql file that contains sql statement to create tables. Is there a way where I can execute the codes in this file creating the tables?
Thanks
EDIT
The code is in C# so use the code converter in the second link.
http://www.c-sharpcorner.com/UploadFile/mahesh/CreatingDBProgrammaticallyMCB11282005064852AM/CreatingDBProgrammaticallyMCB.aspx
http://www.carlosag.net/Tools/CodeTranslator/Default.aspx
|||Hi,
Thanks for the link. Will try it out and post the outcome.
|||If it does not work it will be related to C# to VB conversion because I have helped a user clone a database and all the objects with ExecuteNonQuery.|||Hi,
Yup the 'ExecuteSQL' did not seem to work, so I just removed that entire function and directly called an 'ExecuteNonQuery' and it worked fine.
Thanks!
sql
No comments:
Post a Comment