How to Write Successful or Failed Logfile after executed the SQL query Exe in C# -

i beginner development , creating exe file execute sql scripts. have 3 doubts here. 1. how file name folder @ run time. (currently did hardcore) 2. how write log file after executed query. 3. how show alert message after executed query? (patch executed successful / patch execution failed)

please find script mentioned below;

var txtconn = file.readalltext(@"c:\users\patch\connstrng.txt"); var txtfile = file.readalltext(@"c:users\patch\script.txt"); string[] sqlqry = txtfile.split(new[] {"~go~"}, stringsplitoptions.removeemptyentries); var conn = new sqlconnection(txtconn); var cmd = new sqlcommand("query", conn); conn.open(); foreach (var query in sqlqry){ cmd.commandtext = query; cmd.executenonquery();} conn.close(); 

// need show alert message "patch executed successful. please send result log support // need create result log file.'

you're going want use try catch block

        foreach (var query in sqlqry)         {             try             {                 cmd.commandtext = query;                 cmd.executenonquery();                 string logpath = ""; //path log                 using (streamwriter writer = new streamwriter(logpath, true))                 {                     writer.writeline("ran query " + query); //w                 }                 system.windows.forms.messagebox.show("patch executed successful. please send result log support // need create result log file.");             }             catch (exception ex)             {                 //handle error             }         } 

you'll need set path want write log file. after executing query, streamwriter class write whatever want log file. (the true parameter indicates append log file, each entry doesn't overwrite last). can use messagebox display information.

because executing of query ran inside of try block, if fails (some sort of exception happens) enter catch block, in case need handle error, perhaps popping message box or logging file.