What I am doing seems to be saving the Excel file in a text format. All I am trying to do is save the Excel file (xls) on my web server. Below is the code that "fetches" it now but doesn't save it in the proper format.
[Code]....
Is that a way to edit excel file on browser and then save it on server?
View 5 Repliesi want to export an excel from my web application and want to save it on Web Server, but i am not able to save it on web server, i am able to do it on my local machine, but on web server it's not working.
View 1 RepliesI am executing the following T-SQL code, which runs successfuly according to message I see at end of its execution, but the file c:cptest.txt is never created. I have checked for this file and it doesn't exist. what is the issue here?
EXEC MASTER..xp_cmdshell 'bcp "SELECT top(10) from Person.Address" queryout "C:cptest.txt" -T -c -t,'
I have code to export the grid to excel . i have taken it from [URL] now i want to save excel file directly without asking user to save it or open it at client side. i want to save it on server folder. how to do that .
View 2 Repliesi use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
I want how to upload the excel sheet data and that data will save in Sql Server 2008(table).
View 2 RepliesI'm trying to force a large (200+ MB) file to download that's on a remote server. The problem is that I can't use the "WriteFile()" function, since I'm not using a virtual path. Then, when I try:
Response.AppendHeader("content-disposition",
I am opening excel file in div using IFRAME. Now i want to save the excel file by submit button , which is available on page
<div>
<iframe src="Test.xls" style="height:300px;width:600px">
</iframe>
</div>
<asp:button runat="server" id="submit" />
How to upload the file using iframe
I have deployed my site in Win 2003 server. In this, it copies file from Another server and copies it in local. It is working with my local computer, but not in the server i have deployed. I hope access credentials may be the first reason. But are there any other reasons for this.
I am trying to access a remote network share from a C# program in asp.net. What I need is something like
function download(dirname)
{
file = (This is the part I don't know how to do)
for file in directory:
copyfile(file);
}
i want to save one excel file in sql database in some column and same i want to retrive . for this i am using file upload control to upload a file.
i did follwoing
i defined one column in sql for storing the file with datatype. image
when i am inserting a document in this column "<Binary data>" this value is showing.
and when i trying to retrive this file.In the file "System.Byte[]" text is coming in a cell.
I am storing excel file in database
code to insert a Excel file in database:
Int32 File1Length = this.FileUpload1.PostedFile.ContentLength;
String File1Type = this.FileUpload1.PostedFile.ContentType;
Stream File1Stream;
File1Stream = this.FileUpload1.PostedFile.InputStream;
[Code]....
I have an interesting challenge. My application uses a third party's services and one of the functions is to upload video files to Amazon S3. The current solution I've implemented uses a simple form with a POST action set to a URL on Amazon's system. The
issue I have is that because the form posts to Amazon, I have no way of doing any type validations before the user clicks to upload the file i.e. checking file type, file size, etc.
However, I really do NOT want to set up my logic so that the file is first uploaded to my server then to Amazon because these are huge files and we'll end up using costly bandwidth on both ends -- our server and Amazon S3.
P.S. To be perfectly honest, I'm not that pleased with the current solution where it's a simple HTML form with a simple post to Amazon. However, because Amazon is so picky about all the hidden fields in my asp.net page, I had to strip everything off the
page -- including form runat"server" because the minute I have this, I end up with a hidden field for ViewState -- even if I completely turn off ViewState. There's always something left as a hidden field and Amazon was generating an error because of this.
Ideally, I'd love to be able to do an HttpWebRequest in code behind so that I can have the functions of a web form back and do some pre-upload work but I'm not sure how to upload the file to a remote destination without putting the file on my server first.
I am downloading file from remote server in page load using content disposition. After downloading the file i am trying show some other controls in the page. But that controls are showing asp.net .
View 1 RepliesIs it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
I have to create an excel sheet by reading data from the database and save this newly created excel to the server. I know how to create the excel, i do it by creating html table then changing the content header. But how can i save this as an excel file in the server.
View 2 RepliesI tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error
"Unable to connect to the remote server" on line :
FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?
Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.
I've been searching for various posts on Excel and ASP.Net, and wanted to try and figure out if what I'm attempting has any chance of working. I have a special Excel workbook with a worksheet that has a bunch of calculations and such for various fields that creates an order for his crew. My client uses this Excel worksheet for everything. He's asking me to be able to see online orders (which I have), click a link and have the worksheet be passed down to the client all populated and formatted exactly as is (just adding/editing data).
Is this even possible? I'd have to load this specific .xls file, then open it on the server, save data to various cells, and then do a Save As and then binarystream it down to the client. I'm quite certain there is no version of Excel loaded on the server. So I'm perplexed as to how to accomplish this. Has anyone encountered this situation before and been able to accomplish what's being asked?
After upload a pdf file (order.pdf) to remote server in UNC format, I used code below to open order.pdf file.Code is working in IE9 but not Chrome.Is there another way to open pdf file in remote server?
Dim fullpath As String = [String].Format("file:///{0}", "webserverorderorder.pdf")
Response.Redirect(fullpath)
The below code works fine for downloading a file from a current pc.plz suggest me how to download it from remote server using ip address or any method
protected void Button1_Click(object sender, EventArgs e)
{
const string fName = @"C:ITFSPDFbillsFebruaryAA.pdf";
FileInfo fi = new FileInfo(fName);
long sz = fi.Length;
Response.ClearContent();
Response.ContentType = MimeType(Path.GetExtension(fName));
Response.AddHeader("Content-Disposition", string.Format("attachment; filename = {0}", System.IO.Path.GetFileName(fName)));
Response.AddHeader("Content-Length", sz.ToString("F0"));
Response.TransmitFile(fName);
Response.End();
}
public static string MimeType(string Extension)
{
string mime = "application/octetstream";
if (string.IsNullOrEmpty(Extension))
return mime;
string ext = Extension.ToLower();
Microsoft.Win32.RegistryKey rk = Microsoft.Win32.Registry.ClassesRoot.OpenSubKey(ext);
if (rk != null && rk.GetValue("Content Type") != null)
mime = rk.GetValue("Content Type").ToString();
return mime;
}
filetoread = Server.MapPath("\servernamesharefile.csv")
filestream = File.OpenText(filetoread)
readcontents = filestream.ReadToEnd()
It works fine if I put the file in the local directory and use "filetoread = Server.MapPath("file.csv")", but won't do it over the UNC path.I'm guessing the problem is security related but can't find any info related to it, do I need to somehow specify a username/password somewhere ?
I have many images on remote server say [URL] & i want to access file names of all files that resides in the folder 222 on [URL]
i have tried following code but getting error "virtual path is not valid" :
imageserver = http://images.foo.com/222;
DirectoryInfo di = new DirectoryInfo(imageserver); // line giving exception
FileInfo[] rgFiles = di.GetFiles();
string simagename = "";
if (rgFiles.Count() > 0)
{
foreach (FileInfo fi in rgFiles)
{
//collect each filename from here
}
}
I have an asp.net website that needs to connect to a dBase file on a remote server. The remote server has a ODBC System DSN connection configured but I have no idea how to connect to it.
View 1 RepliesOn remote server i have shared folder. If there any way to download file from this shared folder on local machine? Without using ftp. Server dont have iis or something like this,just have shared folder.
View 1 RepliesThis is what I have right now for a file residing on the same server and it works.
Dim FILENAME as String = Server.MapPath("Output.txt")
Dim objStreamWriter as StreamWriter
objStreamWriter = File.CreateText(FILENAME)
dr = myCommand.ExecuteReader()
While dr.Read()
objStreamWriter.WriteLine("{0}|{1}|{2:yyyy-MM-dd}|{3:yyyy-MM-dd}", dr(0), dr(1), dr(2), dr(3))
End While
objStreamWriter.Close()
I was planning on FTPing the file to another server once done but is there a way to do it on a remote server? i.e create a text file on a remote server and write to it? Did not find any instances of that usage. How to use ServerXMLHTTP to replace Server.MapPath in this instance?
