How to run my .Exe file?

Dinesh Santhalingam

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.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted 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 Santhalingam9y ago
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.
Dinesh Santhalingam9y ago
1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
5. using licautomation;
6. using System.Data;
7. using System.Data.SqlClient;
8. using System.Configuration;
9. using System.Diagnostics;
10. using System.IO;
11. using System.Net;
13. namespace automation
14. {
16. class Program
17. {
19. static void Main(string[] args)
20. {
21. DateTime currnt = DateTime.Now;
22. automation.ledetails details = new ledetails(); //class
23. automation.userdetails userdetails = new userdetails(); //class
24. tosql data = new tosql();//To store the data to sql
25. var dir = AppDomain.CurrentDomain.BaseDirectory;
26. string filepath = Path.Combine(dir, "cmd.exe");//Path for cmd
27. string tempfolder="Temp";
28. string outputPath1 = Path.Combine(dir, tempfolder);//text file output path
29. try
30. {
31. Process cmd = new Process();
32. string[] arr = { "TEXT1", "TEXT2", "TEXT3", "TEXT4", "TEXT5", "TEXT6" };
33. for (int i = 0; i < args.Length; i++)
34. {
35. string date = DateTime.Now.ToString("dd-MM-yyyy HH_mm_ss");
36. string arg = args[i];
37. string name = arr[i];
38. cmd.StartInfo.FileName = filepath;
39. cmd.StartInfo.RedirectStandardInput = true;
40. cmd.StartInfo.RedirectStandardOutput = true;
41. cmd.StartInfo.CreateNoWindow = true;
42. cmd.StartInfo.UseShellExecute = false;
43. cmd.Start();
44. cmd.StandardInput.WriteLine(arg);
45. cmd.StandardInput.Flush();
46. cmd.StandardInput.Close();
47. string sRes = cmd.StandardOutput.ReadToEnd();
48. string createTextFile = "";
49. string outputPath = @""+ outputPath1 +"\\" + name + " " + date + ".txt";
50. createTextFile += "" + sRes + Environment.NewLine;
51. System.IO.File.WriteAllText(outputPath, createTextFile);
52. string[] path = System.IO.File.ReadAllLines(@"" + outputPath1 + "\\" + name + " " + date + ".txt");
54. details.loaddata(path, currnt); //send var to class
56. }
57. data.loadtosql(details.licensedetail); //Retrieve a datatable from class
60. Console.WriteLine("Your output were extracted.......");
61. }
62. catch (Exception e)
63. {
64. Console.WriteLine(e.Message);
68. }
70. }
71. }
73. class tosql
74. {
75. storedata store = new storedata();
76. public void loadtosql(DataTable dt2)
77. {
78. store.BatchBulkCopyuserdetails(dt2); //store datatable to sql
79. }
81. }
83. }
85. This is my program for your information

Nitin Sontakke9y ago

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?

Amit Gupta9y ago

@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.

Nilesh Shah9y ago

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 Santhalingam9y ago

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

Nitin Sontakke

Dinesh Santhalingam9y ago

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

Nitin Sontakke9y ago

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?