/// <summary>
/// Help link: //https://stackoverflow.com/a/25718674
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DownloadTxt(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string ext = Path.GetExtension(FileUpload1.FileName).ToLower();
fileName = FileUpload1.FileName;
//getting the path of the file
FileUpload1.SaveAs(Server.MapPath(serverStorageLocatn + FileUpload1.FileName));
string path = Server.MapPath(serverStorageLocatn + FileUpload1.FileName);
//DataTable dt = new DataTable();
dt = ExcelUtilities.ReadDBFfile(path, monthIndex);
//DownloadTxt(fileName);
result = ExcelUtilities.DumpDBFToTxt(dt).ToString();
string txtFilePath = monthIndex + "_" + fileName.Replace("DBF", "txt");
Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + serverStorageLocatn + txtFilePath);
Response.AddHeader("content-type", "text/plain");
using (StreamWriter writer = new StreamWriter(Response.OutputStream))
{
writer.WriteLine(result);
}
Response.End();
}
else
{
Label1.Text = "No File Uploaded.";
}
}
protected void GreetBotton_Click(object sender, EventArgs e)
{
HelloWorldLabel.Text = "Hello " + TextInput.Text;
TextInput.Text = string.Empty;
if (FileUpload1.HasFile)
{
string ext = Path.GetExtension(FileUpload1.FileName).ToLower();
fileName = FileUpload1.FileName;
//getting the path of the file
FileUpload1.SaveAs(Server.MapPath("~/MyFolder/" + FileUpload1.FileName));
string path = Server.MapPath("~/MyFolder/" + FileUpload1.FileName);
//DataTable dt = new DataTable();
dt = ExcelUtilities.ReadDBFfile(path, monthIndex);
//return something to UI
gvExcelFile.DataSource = dt;
gvExcelFile.DataBind();
Label1.Text = "File Uploaded: " + FileUpload1.FileName;
}
else
{
Label1.Text = "No File Uploaded.";
}
}
protected void GreetBotton_Click(object sender, EventArgs e)
{
helloWorldLabel.Text += txtInput.Text;
txtInput.Text = string.Empty;
if (FileUpload1.HasFile)
{
var ext = Path.GetExtension(FileUpload1.FileName).ToLower();
//getting the path of the file
FileUpload1.SaveAs(Server.MapPath(serverStorageLocatn + FileUpload1.FileName));
string path = Server.MapPath(serverStorageLocatn + FileUpload1.FileName);
//DataTable dt = new DataTable();
dt = ExcelUtilities.ReadDBFfile(path, monthIndex);
//return something to UI
gvExcelFile.DataSource = dt;
gvExcelFile.DataBind();
Label1.Text = $"File Uploaded: {FileUpload1.FileName}";
}
}