Save File Dialog into Web Based Application

Dear team :),

I have a small problem. My case is that I am inserting some data into my Data Table, I need to export them into csv file. I could be able to write the code but I have a problem that the location of saving must be static. Is there anyway , same as WPF or Windows Forms, in ASP.net to let the user open save dialog and choose the path and even write the name?

Many thanks

Re: Save File Dialog into Web Based Application

Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment; filename=test.csv");
Response.TransmitFile(Server.MapPath("~/Uploads/test.csv"));
Response.End();

Refer this also

http://www.mindcracker.com/Story/496/how-to-download-pdf-file-using-Asp-Net

Hope this helps...

Re: Save File Dialog into Web Based Application

I think first you can generate the cvs file and save as a temporary file in your server-side temporary file folder .

Tranfmit the file as attchment . while you download the file , then you can choose your save path and write the name.

Assume you got a button when user click the button do this:

Response.ContentType = "Application/vnd.ms-excel";// these code write in the button click event
            Response.AppendHeader("Content-Disposition", "attachment; filename=data.cvs");
            Response.TransmitFile(Server.MapPath("~/temp_files/data.cvs"));//here server.mappath is your saved temp file[data.cvs]
            Response.End();

hope it hellps. if not , please let me know.

Re: Save File Dialog into Web Based Application

Many thanks for your answer, below is what I currently have:

when the user click on Save button, WrtieCSV function will be called but here the path is a static :(

string path = "F:\\MigrationFrom.csv";

CreateCSVFile(MigrationResult, path); // MigrationResult is my data table and after filling it with data using Adapter

public void CreateCSVFile(DataTable dt, string strFilePath){ // the Funtion

}

I need the path to be determined by a user as well as file name !

so, you may give me another way, a better way of doing this :) especially that I also need an output in Differant formats i.e : xls, csv, .dbf or others.

Here I also deal with around 2,000,000 records from Oracle database tables.

Many thanks again

Re: Save File Dialog into Web Based Application

Hi,

I think you can add a dropdownlist or combox control(item like:excel,word,pdf,dbf etc), then user can select the type of file, and add a textbox, user can write the name of the file (also path). in the code behind , when user click the button, you can get the value of dropdownlist and textbox, then you can dynamic set the type and the path of the file that you wanna save(here i got a question for you : do you really want to save the created file in server side? you got so many records!).

Re: Save File Dialog into Web Based Application

Of course I DONT :), and for that I asked how can i let the user determine the path. it's not applicable to let the user write a path into a text box ! Come On!!! what I need is like when we browse to save a file, same as we want to download sth from any page. We usually select the path, then write the name.

Re: Save File Dialog into Web Based Application

Hi,

For security , based on my exerpience and research user can browse the server side file system. and Unfortunately my knowledge about save file in server side is incomplete, so what i can suggest you is : after the file been trasmit to user side then delete it.

thanks

Re: Save File Dialog into Web Based Application

mmm, so you suggest that I let the user save the file into server, then transmit the file into a location where can choose.

but I am really wondering ! I only need , like WPF or Windows Forms, sth such as Save file Dialog where I can get the path and even the name !

and I have a datatable with write function to write the data into csv file.

what do you think ?

Re: Save File Dialog into Web Based Application

Hi,

Base on my exerpience and research, you can create a save file folder in your Project, then user can save file into the folder. It is static path. And as far as I know, web application don't have something like WF Save File Dialog.

Re: Save File Dialog into Web Based Application

private void DownloadFile(bool forceDownload)
        {
             string type = "";
            // set known types based on file extension
            if (ext != null)
            {
                switch (ext.ToLower())
                {
                    case ".htm":
                    case ".html":
                        type = "text/HTML";
                        break;

                    case ".txt":
                        type = "text/plain";
                        break;

                    case ".doc":
                    case ".rtf":
                        type = "Application/msword";
                        break;

                    case ".xls":
                        type = "Application/x-msexcel";
                        break;
                }
            }
            if (forceDownload)
            {
                Response.AppendHeader("content-disposition",
                    "attachment; filename=" + name);
            }
            if (type != "")
            Response.ContentType = type;
            Response.AddHeader("Content-Disposition", "attachment; filename="  );
            Response.WriteFile(path);
            Response.TransmitFile(strRolloverFilepath);
            Response.End();
        }

Re: Save File Dialog into Web Based Application

Many thanks :) but...

How can I let the user determine the path !!!!!! in addition, where can i put my table adapter in the above code :D ?

i need an example, as simple as possible, showing the user selects a path and a type to be saved as from DataAdapter or DataTable

Br,

Re: Save File Dialog into Web Based Application

string FileName = Path.GetFileName(flUpdUpload.PostedFile.FileName);
                string Extension = Path.GetExtension(flUpdUpload.PostedFile.FileName);
                string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
                string FilePath = Server.MapPath("~/UploadFiles/" + FileName);

whereas Uploadfiles is a folder in my solution. u can have it or leave.try this

Re: Save File Dialog into Web Based Application

HOW CAN THE USER SELECT THE PATH !!!!!!!!!!!!!!!, how can he have such a browse window to select the path and write the name ?????

Many thx

Re: Save File Dialog into Web Based Application

Hi Wael Abu Rezeq,

Browse server side file system, blow might help you.

.aspx file

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm19.aspx.cs" Inherits="WebDev.WebForm19" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>test</title></head>
 <body>
    <form id="Form1" method="post" runat="server">
      <asp:ListBox id="lstDirs" style="Z-INDEX: 101; LEFT: 32px; POSITION: absolute; TOP: 72px" runat="server" Width="248px" Height="208px" Font-Names="Verdana"></asp:ListBox>
      <asp:Button id="cmdParent" style="Z-INDEX: 109; LEFT: 176px; POSITION: absolute; TOP: 280px" runat="server" Text="Up One Level" Width="100px" Height="24px"></asp:Button>
      <asp:Button id="cmdShowInfo" style="Z-INDEX: 107; LEFT: 312px; POSITION: absolute; TOP: 280px" runat="server" Text="Show Info"></asp:Button>
      <asp:Label id="Label2" style="Z-INDEX: 104; LEFT: 312px; POSITION: absolute; TOP: 56px" runat="server" Width="192px" Height="24px" Font-Names="Verdana" Font-Bold="True" Font-Size="X-Small">Contained Files:</asp:Label>
      <asp:ListBox id="lstFiles" style="Z-INDEX: 102; LEFT: 312px; POSITION: absolute; TOP: 72px" runat="server" Width="280px" Height="200px" Font-Names="Verdana"></asp:ListBox>
      <asp:Label id="Label1" style="Z-INDEX: 103; LEFT: 32px; POSITION: absolute; TOP: 56px" runat="server" Width="216px" Height="38px" Font-Names="Verdana" Font-Bold="True" Font-Size="X-Small">Subdirectories:</asp:Label>
      <asp:Label id="Label3" style="Z-INDEX: 105; LEFT: 32px; POSITION: absolute; TOP: 16px" runat="server" Width="184px" Height="19px" Font-Names="Verdana" Font-Bold="True" Font-Size="Medium">Current Directory:</asp:Label>
      <asp:Button id="cmdBrowse" style="Z-INDEX: 106; LEFT: 32px; POSITION: absolute; TOP: 280px" runat="server" Text="Browse To Selected" Width="136px" Height="24px"></asp:Button>
      <asp:Label id="lblFileInfo" style="Z-INDEX: 108; LEFT: 312px; POSITION: absolute; TOP: 328px" runat="server" Width="280px" Height="80px" BorderStyle="Groove" BorderWidth="2px" Font-Names="Verdana" Font-Size="X-Small"></asp:Label>
      <asp:Label id="lblCurrentDir" style="Z-INDEX: 110; LEFT: 240px; POSITION: absolute; TOP: 16px" runat="server" Width="184px" Height="24px" Font-Names="Verdana" Font-Bold="True" Font-Size="Medium"></asp:Label>
    </form>
  </body>
</html>

.cs file

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;

namespace WebDev
{
    public partial class WebForm19 : System.Web.UI.Page
    {
        //protected System.Web.UI.WebControls.ListBox lstDirs;
        //protected System.Web.UI.WebControls.Button cmdParent;
        //protected System.Web.UI.WebControls.Button cmdShowInfo;
        //protected System.Web.UI.WebControls.Label Label2;
        //protected System.Web.UI.WebControls.ListBox lstFiles;
        //protected System.Web.UI.WebControls.Label Label1;
        //protected System.Web.UI.WebControls.Label Label3;
        //protected System.Web.UI.WebControls.Button cmdBrowse;
        //protected System.Web.UI.WebControls.Label lblFileInfo;
        //protected System.Web.UI.WebControls.Label lblCurrentDir;

        private void Page_Load(object sender, System.EventArgs e)
        {
            if (!this.IsPostBack)
            {
                string startingDir = System.Web.HttpContext.Current.Server.MapPath(@"~\");//@"c:\Temp";
                lblCurrentDir.Text = startingDir;
                ShowFilesIn(startingDir);
                ShowDirectoriesIn(startingDir);
            }

        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.cmdParent.Click += new System.EventHandler(this.cmdParent_Click);
            this.cmdShowInfo.Click += new System.EventHandler(this.cmdShowInfo_Click);
            this.cmdBrowse.Click += new System.EventHandler(this.cmdBrowse_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void ShowFilesIn(string dir)
        {
            DirectoryInfo dirInfo = new DirectoryInfo(dir);

            lstFiles.Items.Clear();
            foreach (FileInfo fileItem in dirInfo.GetFiles())
            {
                lstFiles.Items.Add(fileItem.Name);
            }
        }

        private void ShowDirectoriesIn(string dir)
        {
            DirectoryInfo dirInfo = new DirectoryInfo(dir);

            lstDirs.Items.Clear();
            foreach (DirectoryInfo dirItem in dirInfo.GetDirectories())
            {
                lstDirs.Items.Add(dirItem.Name);
            }
        }

        private void cmdShowInfo_Click(object sender, System.EventArgs e)
        {
            if (lstFiles.SelectedIndex != -1)
            {
                string fileName = Path.Combine(lblCurrentDir.Text, lstFiles.SelectedItem.Text);
                FileInfo selFile = new FileInfo(fileName);
                lblFileInfo.Text = "<b>" + selFile.Name + "</b><br>";
                lblFileInfo.Text += "Size: " + selFile.Length + "<br>";
                lblFileInfo.Text += "Created: ";
                lblFileInfo.Text += selFile.CreationTime.ToString();
                lblFileInfo.Text += "<br>Last Accessed: ";
                lblFileInfo.Text += selFile.LastAccessTime.ToString();
            }

        }

        private void cmdParent_Click(object sender, System.EventArgs e)
        {
            if (Directory.GetParent(lblCurrentDir.Text) != null)
            {
                string newDir = Directory.GetParent(lblCurrentDir.Text).FullName;
                lblCurrentDir.Text = newDir;
                ShowFilesIn(newDir);
                ShowDirectoriesIn(newDir);
            }

        }

        private void cmdBrowse_Click(object sender, System.EventArgs e)
        {
            if (lstDirs.SelectedIndex != -1)
            {
                string newDir = Path.Combine(lblCurrentDir.Text, lstDirs.SelectedItem.Text);
                lblCurrentDir.Text = newDir;
                ShowFilesIn(newDir);
                ShowDirectoriesIn(newDir);
            }

        }
    }
}