How to run my .Exe file?

Question

I built a console application in VS2010.The tool will simply process some details and atore it to the sql table .When I debug my program in VS2010 it run sucessfully and meet my requirement.But when i run the exe file it run but can't stroe the values to sql table.The exe didn't generate any error.It runs but failed to meet my requirement.I don't know why this is happened?please help me to solve my issue.

Amit Gupta · Answer

@Dinesh As your code seems somehow good but to figure it out and catch where the root of the actual problem, pause the console windows by writing Console.ReadLine() after the catch block, there may be a problem of not passing command line argument string arg = args [i]; Also I would suggest you to comment the line cmd.StartInfo.CreateNoWindow = true ; for the time being, so that you should look what is happening in the cmd.exe process while writing and reading from it. This will help you to find the exact problem. Hope this helps :)

Dinesh Santhalingam · Answer

You are Exactly right @ Amit Gupta there may be a problem of not passing command line argument string arg = args [i]; I used arg to declare the variables thats why the exe does'nt meet my requirement.Now i declare var in a string array now the exe perfectly working.Thank you So much for your valuable time.

Amit Gupta · Answer

@Dinesh There are many ways that cause this type of errors Is your program working with relative path? If working with settings file . You need to share the code details to look at it. As @nitin has told, log the file for each action performed.

Nitin Sontakke · Answer

In scenarios like this, everything needs to be questioned. The best approach, I believe, is to put the exception handling and logging errors to a text file. Start with the most obvious places of failure, for example, opening the connection, etc. Are you executing it on the same machine as a development box?

Nilesh Shah · Answer

Check in event viewer if you can find anything. type event viewer in windows run command, open event viewer go to Applications and Services Log check if you can see anything related to your application

Dinesh Santhalingam · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Text; using licautomation; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Diagnostics; using System.IO; using System.Net; namespace automation { class Program { static void Main(string[] args) { DateTime currnt = DateTime .Now; automation.ledetails details = new ledetails(); //class automation.userdetails userdetails = new userdetails(); //class tosql data = new tosql();//To store the data to sql var dir = AppDomain .CurrentDomain.BaseDirectory; string filepath = Path .Combine(dir, "cmd.exe");//Path for cmd string tempfolder = "Temp" ; string outputPath1 = Path.Combine(dir, tempfolder);//text file output path try { Process cmd = new Process(); string[] arr = { "TEXT1", " TEXT2 ", " TEXT3 ", " TEXT4 ", " TEXT5 ", " TEXT6 " }; for (int i = 0 ; i args.Length ; i++) { string date = DateTime .Now.ToString("dd-MM-yyyy HH_mm_ss"); string arg = args [i]; string name = arr [i]; cmd.StartInfo.FileName = filepath ; cmd.StartInfo.RedirectStandardInput = true ; cmd.StartInfo.RedirectStandardOutput = true ; cmd.StartInfo.CreateNoWindow = true ; cmd.StartInfo.UseShellExecute = false ; cmd.Start(); cmd.StandardInput.WriteLine(arg); cmd.StandardInput.Flush(); cmd.StandardInput.Close(); string sRes = cmd .StandardOutput.ReadToEnd(); string createTextFile = "" ; string outputPath = @""+ outputPath1 +"\" + name + " " + date + ".txt"; createTextFile += "" + sRes + Environment.NewLine; System.IO.File.WriteAllText(outputPath, createTextFile); string[] path = System .IO.File.ReadAllLines(@"" + outputPath1 + "\" + name + " " + date + ".txt"); details.loaddata(path, currnt); //send var to class } data.loadtosql(details.licensedetail); //Retrieve a datatable from class Console.WriteLine("Your output were extracted......."); } catch (Exception e) { Console.WriteLine(e.Message); } } } class tosql { storedata store = new storedata(); public void loadtosql(DataTable dt2) { store.BatchBulkCopyuserdetails(dt2); //store datatable to sql } } } This is my program for your information

Nitin Sontakke · Answer

This being a console app, can you not write several Console.WriteLine("In...method name"); statements in app itself. This will indicate how far it went. If logging in possible, write in log file info messages how far execution has gone. Either exception or information message, one of the two must be logged, isn't it?

Dinesh Santhalingam · Answer

I set the log error file.But there is no file were created which means the program dont have any errors.@ Nitin Sontakke

Dinesh Santhalingam · Answer

Am executing it in my machine but it not works.I follow your steps and revert you back.

How to run my .Exe file?

Amit Dhania