Tag Archives: Programming

Opening a folder at C#

To open a folder in C#, simply follow the following example :

[code lang="csharp"]
private void openFolder()
string myDocspath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);// if you are after special documents (e.g. my documents)
string myFolderpath = Application.StartupPath + "\\folderName\\"; // a folder right beside where you run the program
string windir = Environment.GetEnvironmentVariable("WINDIR");
System.Diagnostics.Process process = new System.Diagnostics.Process();
process .StartInfo.FileName = windir + @"\explorer.exe";
process .StartInfo.Arguments = myFolderpath;
process .Start();//OPEN the folder


How to Export Data to Excel without hassel

Saving query to excel format could go through Microsoft Office Interop services or some third party libraries. However there is a simpler way. CSV file formats are wuite simple and one could simply read queries and save them into a text file format with CSV as the extension (myfile.csv).

The tricks would be to have the data read from database by query and write each record as a line and semicolon to separate the column vales.This is actually language independent and one could implement it by C#, Java or any other language that could execute queries on a database.

String to Double issues in C# .NET

If you are simply using

double test = Double.Parse(“12.45″);

and it doesn’t work due to formating issues, here is the right post for you. Almost certainly you’re using the wrong CultureInfo. Try specifying CultureInfo.InvariantCulture to parse in. I suspect it’s currently assuming that “.” is a thousands separator rather than a decimal point.

CultureInfo Invc = new CultureInfo(“”);
Invc = CultureInfo.InvariantCulture;
x1 = Double.Parse(“12.45″, Invc);


x1 = Double.Parse(“12.45″, CultureInfo.InvariantCulture);