protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
//Substring everything before the period, then add ".xml" at the end of the ExportedFileName
string ExportPath = @"C:\temp\temp\";
string ExportFileName = "ExportDT.xml";
string FilePath = Server.MapPath(FolderPath + FileName);
FileUpload1.SaveAs(FilePath);
csvObjects csvO = new csvObjects();
//ImportToGrid(FilePath, Extension, rbHDR.SelectedItem.Text);
DataTable dt = csvO.ImportCsvToDataTable(FilePath, Extension, rbHDR.SelectedItem.Text);
csvO.ExportDataTableToXML(dt, ExportPath, ExportFileName);
FilePathHiddenField.Value = FilePath;
ExtensionHiddenField.Value = Extension;
IsHDRHiddenField.Value = rbHDR.SelectedItem.Text;
GridView1.DataSource = dt;
GridView1.DataBind();
// ExportHelpers.GlobalVar.filePath = FilePath;
// ExportHelpers.GlobalVar.extension = Extension;
// ExportHelpers.GlobalVar.isHDRHiddenField = rbHDR.SelectedItem.Text;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
//Substring everything before the period, then add ".xml" at the end of the ExportedFileName
string ExportPath = @"C:\temp\temp\";
string ExportFileName = "ExportDT.xml";
string FilePath = Server.MapPath(FolderPath + FileName);
FileUpload1.SaveAs(FilePath);
csvObjects csvO = new csvObjects();
//ImportToGrid(FilePath, Extension, rbHDR.SelectedItem.Text);
DataTable dt = csvO.ImportCsvToDataTable(FilePath, Extension, rbHDR.SelectedItem.Text);
csvO.ExportDataTableToXML(dt, ExportPath, ExportFileName);
FilePathHiddenField.Value = FilePath;
ExtensionHiddenField.Value = Extension;
IsHDRHiddenField.Value = rbHDR.SelectedItem.Text;
GridView1.DataSource = dt;
GridView1.DataBind();
// ExportHelpers.GlobalVar.filePath = FilePath;
// ExportHelpers.GlobalVar.extension = Extension;
// ExportHelpers.GlobalVar.isHDRHiddenField = rbHDR.SelectedItem.Text;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
//Substring everything before the period, then add ".xml" at the end of the ExportedFileName
string ExportPath = @"C:\temp\temp\";
string ExportFileName = "ExportDT.xml";
string FilePath = Server.MapPath(FolderPath + FileName);
// FileUpload1.SaveAs(FilePath);
csvObjects csvO = new csvObjects();
//ImportToGrid(FilePath, Extension, rbHDR.SelectedItem.Text);
///////////////////////// DataSet ds = csvO.ImportDataTableFromXML(FilePath);
//ImportDataTableFromXML(DataTable dt, string Path, String FileName)
//csvO.ExportDataTableToXML(dt, ExportPath, ExportFileName);
string filename = @"c:\temp\temp\ExportDT.xml";
DataSet ds = new DataSet();
ds.ReadXml(filename);
FilePathHiddenField.Value = FilePath;
ExtensionHiddenField.Value = Extension;
IsHDRHiddenField.Value = rbHDR.SelectedItem.Text;
GridView1.DataSource = ds;
GridView1.DataBind();
//This is the section that I need to convert the XMl
//from DataSet to Excel, or CSV(Convert the XML to CSV)
// ExportHelpers.GlobalVar.filePath = FilePath;
// ExportHelpers.GlobalVar.extension = Extension;
// ExportHelpers.GlobalVar.isHDRHiddenField = rbHDR.SelectedItem.Text;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
//Substring everything before the period, then add ".xml" at the end of the ExportedFileName
string ExportPath = @"C:\temp\temp\";
string ExportFileName = "ExportDT.xml";
string FilePath = Server.MapPath(FolderPath + FileName);
// FileUpload1.SaveAs(FilePath);
csvObjects csvO = new csvObjects();
//ImportToGrid(FilePath, Extension, rbHDR.SelectedItem.Text);
///////////////////////// DataSet ds = csvO.ImportDataTableFromXML(FilePath);
//ImportDataTableFromXML(DataTable dt, string Path, String FileName)
//csvO.ExportDataTableToXML(dt, ExportPath, ExportFileName);
string filename = @"c:\temp\temp\ExportDT.xml";
DataSet ds = new DataSet();
ds.ReadXml(filename);
FilePathHiddenField.Value = FilePath;
ExtensionHiddenField.Value = Extension;
IsHDRHiddenField.Value = rbHDR.SelectedItem.Text;
GridView1.DataSource = ds;
GridView1.DataBind();
//This is the section that I need to convert the XMl
//from DataSet to Excel, or CSV(Convert the XML to CSV)
// ExportHelpers.GlobalVar.filePath = FilePath;
// ExportHelpers.GlobalVar.extension = Extension;
// ExportHelpers.GlobalVar.isHDRHiddenField = rbHDR.SelectedItem.Text;
}
