C#

public void GetData()<br />
    {   SqlConnection con = new SqlConnection(constr);<br />
        string cmd = "select a.errname as ErrorName, m.errortype as ErrorType, a.errpointsdeducted as PointsDeduction, convert(varchar,a.createddate,104) as CreatedDate from auditerrors a,auditerrormaster m where a.errtypeid=m.internalid order by m.errortype";<br />
        SqlDataAdapter da = new SqlDataAdapter(cmd,con);<br />
        DataSet ds = new DataSet();<br />
        DataTable dt = new DataTable();<br />
        da.Fill(ds, "auditerrors");<br />
        dt = ds.Tables["auditerrors"];<br />
        gvAuditErrors.DataSource=ds.Tables[0];<br />
        gvAuditErrors.DataBind();}

Process oProcess = new Process();
oProcess.StartInfo.FileName = "cmd.exe";
oProcess.StartInfo.CreateNoWindow = true;
oProcess.StartInfo.UseShellExecute = false;
RegistryKey oRegKey  = null;// variable to get the registry key of the selected application
string sUninstallString = "";

// following code gets the registry key of the selected application
string[] asSubKeys = Registry.LocalMachine.OpenSubKey(
 @"SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\").GetSubKeyNames();
foreach (string sSubKey in asSubKeys) {
  oRegKey = Registry.LocalMachine.OpenSubKey(
   @"SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\" + sSubKey);

  if (oRegKey.GetValue("Displayname") != null && 
   oRegKey.GetValue("Displayname").ToString() == this.treePrograms.SelectedNode.Text) {
    sUninstallString = oRegKey.GetValue("Uninstallstring").ToString();
    break;
  }
}

// check if the uninstall.exe exists for the selected application
if (sUninstallString.LastIndexOf("exe") != (sUninstallString.Length - 3)) {
  // uninstall.exe does not exists for the selected application
  // so i get uninstall string as:
  // MsiExec.exe /I{920EB460-99D1-4CFB-A383-20DD293AA86D}
  // (for some application on my machine)
  // I am not sure why I am getting "/I" instead of "/X"
  // Manually edit the string to make it work
  sUninstallString = sUninstallString.Remove(0, 14);
  // uninstall the application
  oProcess.StartInfo.Arguments = "/k msiexec.exe /x" + sUninstallString;
}
else {
  // uninstall.exe exists for the selected application
  // so i get uninstall string as:
  // C:\Program Files\WinRAR\uninstall.exe (for winrar)
  // edit it to make it work in cmd.exe
  sUninstallString = sUninstallString.Replace("C:\\", "");
  string sExe = sUninstallString.Substring(sUninstallString.LastIndexOf('\\') + 1);
  sUninstallString = sUninstallString.Remove(sUninstallString.LastIndexOf('\\'));
  oProcess.StartInfo.Arguments = ("/k cd\\ & cd " + sUninstallString + " & " + sExe);
}
oProcess.StartInfo.RedirectStandardError = true;
oProcess.Start();
// how much miliseconds should be kept here so that code works fine for any application? 
oProcess.WaitForExit(); 
// Check for successfull uninstallation ????
// I guess StandardError may help. But how?
oProcess.Close();
oProcess.Dispose();

private void toolStripButton2_Click(object sender, EventArgs e)
{

    //Write Header Record
    StreamWriter sw = new StreamWriter(@"C:\file1.csv", false);
    DataTable dt = m_dtCC;
    int iColCount = dt.Columns.Count;
    for (int i = 0; i < iColCount; i++)
    {
        /*Ensure all Fields are wrapped in Quotes
          else you get errors when opening file
          in Excel.
        */
        sw.Write(@"""{0}""", dt.Columns[i]);
        if (i < iColCount - 1)
        {
            sw.Write(",");
        }
    }
    sw.Write(sw.NewLine);

    //Write all records in the DB
    foreach (DataRow dr in dt.Rows)
    {
        //Search for all Records with value 0
        if (dr["Exported"].ToString() == "0")
        {
            for (int i = 0; i < iColCount; i++)
            {
                if (!Convert.IsDBNull(dr[i]))
                {
                    sw.Write(@"""{0}""", dr[i].ToString());
                }
                if (i < iColCount - 1)
                {
                    sw.Write(",");
                }
            }
            sw.Write(sw.NewLine);
        }
    }

    sw.Close();