XML to excel/datagridview parsing

Hi Mate,
thanks alot.
if i need these two lines to close the xml/kml file where should they be?

  theWriter.WriteLine("");
  theWriter.WriteLine(" \n \n \n \n \n ");

regarding the file extention it was a stupid mistake (should have always been .csv/.kml)

i am now only missing the issue with these two lines.

thanks again for the support.

Hi Mate,
sorry about that.
below you can find the entire code
please check this also - i have a combobox that includes insite (*.kml and *.csv).
when i choose that the streamwriter will use it "FileTypeExt.Text;" the software hangs and crashes (vshost.exe not working).
with the code below i get also the error message with the null and the vshost.exe hanging.

thanks again for the support.



[code]
using
System;using
System.Collections.Generic;using
System.ComponentModel;using
System.Data;using
System.Drawing;using
System.Text;using
System.Reflection;using
System.Runtime.InteropServices;using
System.IO;using
System.Xml;using
Excel = Microsoft.Office.Interop.Excel;using
System.Windows.Forms;using
System.Threading;using
System.Globalization;using


System.Xml.Linq;namespace
{


WindowsApplication2public partial class Form1 : Form{


{
InitializeComponent();
}


{


{


FileTypeExt.Text =


}


public Form1()private void button1_Click(object sender, EventArgs e)if ((alertlayertextbox.Text == null) || (alertlayertextbox.Text == ""))MessageBox.Show("No Alert Layer File selected" + "\r\n" + "Please select an Alert Layer", "Error loading Alert Layer");null;return;//if ((outputfiletextbox.Text == null) || (outputfiletextbox.Text == ""))

//{

// MessageBox.Show("Output Directory was not selected" + "\r\n" + "Please select output directory", "Error output directory can not be found");

// FileTypeExt.Text = null;

// return;



//}



XDocument doc = XDocument.Load(alertlayertextbox.Text);// string path = @"C:\Users\Desktop\Book Application\";

// string path = @"C:\Users\Desktop\Book Application\test\";



{






string path = outputfiletextbox.Text + "\\";foreach (XElement alert in doc.Root.Elements("alert_area_object"))StreamWriter theWriter = null;try{




string name = (string)alert.Element("name");string fileName = name.Trim() + FileTypeExt.Text;// ".kml";

theWriter =


string polyname = name.Trim();new StreamWriter(path + fileName, true); // appends rather than overwrites?

//creating the KML FiletheWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(


" + "\"" + "1.0" + "\"" + " encoding=" + "\"" + "UTF-8" + "\"" + "?>");""\"" + "http://www.opengis.net/kml/2.2" + "\"" + " xmlns:gx=" + "\"" + "http://www.google.com/kml/ext/2.2" + "\"" + " xmlns:kml=" + "\"" + "http://www.opengis.net/kml/2.2" + "\"" + " xmlns:atom=" + "\"" + "http://www.w3.org/2005/Atom" + "\"" + ">");"");"" + polyname + "");""\"" + "msn_ylw-pushpin" + "\"" + ">");" \n normal \n #sn_ylw-pushpin \n ");" \n highlight \n #sh_ylw-pushpin \n ");"");"");// theWriter.WriteLine("");theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(
theWriter.WriteLine(




{






"");"");"" + polyname + "");"0 \n #msn_ylw-pushpin \n \n 1 \n \n ");"");foreach (XElement geo in alert.Element("shape").Elements("geo_position"))double latitude = (double)geo.Attribute("lat");double longitude = (double)geo.Attribute("long");// theWriter.WriteLine(String.Format("lat=\"{0}\" long=\"{1}\"", latitude, longitude));theWriter.WriteLine(longitude +
}
}


{


"," + latitude + ",23");catch (Exception ex)// MessageBox.Show(ex.Message);

// StreamWriter errorlogger = new StreamWriter(path + "error log.txt");

// errorlogger.WriteLine(ex.Message);

// if (errorlogger != null) errorlogger.Close();}


finally{
theWriter.WriteLine(
theWriter.WriteLine(




"");" \n \n \n \n \n ");if (theWriter != null) theWriter.Close();// MessageBox.Show(FileTypeExt.Text);}
}
}


{


{
outputfiletextbox.Text = outputlocation.SelectedPath;
}
}


{
alertlayerfiledialog.Filter =


{


alertlayertextbox.Text = alertlayerfiledialog.FileName;
}
}


{
}


{


{
CreateLayers.Enabled =
}
FileTypeExt.DropDownStyle =
}


{




{
CreateLayers.Enabled =
}


private void button3_Click(object sender, EventArgs e)if (outputlocation.ShowDialog() == DialogResult.OK)private void alertlayerbtn_Click(object sender, EventArgs e)"alert layer (*.xml) | *.xml";if (alertlayerfiledialog.ShowDialog() == DialogResult.OK)if (alertlayerfiledialog.FileName != " ")private void alertlayerfiledialog_FileOk(object sender, CancelEventArgs e)private void Form1_Load(object sender, EventArgs e)if ((FileTypeExt.Text == "") || (FileTypeExt.Text == null))false;ComboBoxStyle.DropDownList;private void FileTypeExt_SelectedIndexChanged(object sender, EventArgs e)if ((FileTypeExt.Text == "*.CSV") || (FileTypeExt.Text == "*.KML"))true;else{
CreateLayers.Enabled =
}
}


{






}
}
}
false;private void button1_Click_1(object sender, EventArgs e)MessageBox.Show(" + "\"" + "1.0" + "\"" + " encoding=" + "\"" + "UTF-8" + "\"" + "?>");MessageBox.Show(""\"" + "http://www.opengis.net/kml/2.2" + "\"" + " xmlns:gx=" + "\"" + "http://www.google.com/kml/ext/2.2" + "\"" + " xmlns:kml=" + "\"" + "http://www.opengis.net/kml/2.2" + "\"" + " xmlns:atom=" + "\"" + "http://www.w3.org/2005/Atom" + "\"" + ">");MessageBox.Show(" \n highlight \n #sh_ylw-pushpin \n ");

[/code]