Category: ASP.NET

05 May 2016 02:50

Joined:	23/08/2014
Level:	Silver
Points:	104

Points:	4

User has to select the path and save the file

Save button code as follows

i am directly save the excel in D folder.

for that code as follows

System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
gvEmpdetails.RenderControl(htw);
string renderedGridView = sw.ToString();
File.WriteAllText("D:Employee123.xl", renderedGridView)

but i want user has to select the path and save the excel.

for selecting path how can i do

#765820

05 May 2016 04:25

Joined:	21/11/2010
Level:	Bronze
Points:	81

Points:	4

1.first Create File on Server. You can use Server.MapPath
Server. MapPath method to get the physical path for a file in your web application.
2. User below code to download File from saver witch will Prompt you for Path

System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.ClearContent();
response.Clear();
response.ContentType = "text/plain";
response.AddHeader("Content-Disposition",
"attachment; filename=" + fileName + ";");
response.TransmitFile(Server.MapPath("Employee123.xl"));
response.Flush();
response.End();

you can also check
http://stackoverflow.com/questions/1268766/writing-file-to-web-server-asp-net
http://stackoverflow.com/questions/18477398/asp-net-file-download-from-server
https://msdn.microsoft.com/en-us/library/ez801hhe(v=vs.110).aspx

#765827

05 May 2016 23:46

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	4

Your existing code will not work after it will deploy on server, after deployment asp.net will work on server directories not on client machine so as per your code your excel file will save on D:\ of server not on client machine
To resolve this you first need to create excel file (which obviously created on server) then download it using below code


string a = HttpContext.Current.Server.MapPath("D:\\test.xls");
 Response.AppendHeader("content-disposition", "attachment; filename=" + name);
if (type != "")
            Response.ContentType = type;
        Response.WriteFile(path);
        Response.End();

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

#765836

08 May 2016 23:29

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	3

Hi,

You can pass the path location in textbox control and concatenate the textbox value with the appropriate location or get the drivers information in to dropdown and based on the selected value of dropdown you have to do some customization to concatenate your code.

Refer below link, how to get the drivers information : http://www.dotnetspider.com/resources/45476-Display-Drivers-Information.aspx

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

User has to select the path and save the file

About dotnetspider.com

Quick Links

General

Services