I'm populating a generic list from an excel file that contains names of pdf files. Now I want to take each item in the list and create a file from it. Here's what I have so far:
[Code]....
So now, the list called lines contains names of 900 pdf files. How would I take those names out of the list and create files from them?
I am creating an site where a user uploads an excel file to check if any of the records exist in a database. Then they are returned an excel file with only the records that are NOT in the database.
I was thinking I should do it this way1. User uploads their excel file. The app opens excel file and loads records into a dataset (so far this is working with the code below)2. Using datarow and another function to check if each excel record exists in the database3 If the record does NOT exist, and it is the first record tested, create an excel file called records.xlsx and write the record into the file
4. Check the next record and if it does NOT exist in the database, then check if records.xlsx already exists then open it and write it into it.
[Code]....
Hopefully its clear, sorry if its not, I'm a bit of a novice at this. Is this a good way to do it? Does anyone know of any tutorials that might outline how to open an existing file and write to it?
Want to create a web based application for reading and writing excel files.
Issue :
1. Want to upload an excel file and store it some location.
2. Read data from excel file, performing some sorting and filtering
3. Write filtered data to new excel file.
how to get the names of excel files opened on the Client machine and populate it in a ListBox? If somebody did it please reply to this or give some pointers / web site links to me, so that i will read and try to use for building my code.
View 1 Replieswhich component in MVC pattern is responsible for writing files to disk? Is this a controller or model?
View 2 RepliesI am testing with an MVC 2 project generated by the template in VS 2010. I have simply added an ADO.NET Entity Data Model, as well as a WCF Data Service that leverages the data model.
I was able to access the web application content (views, as well as the data served by the data service) just fine until the day before yesterday.
Yesterday I decided to reinstall Windows 7 on my development laptop, and I chose to go with the release of the OS with SP1. Of course, I reinstalled Visual Studio as well.
Now the same project gives me HTTP 404 errors when I try to browse to the data url .../MyTodoDataService.svc).
Here are some interesting facts:
The same data service works just fine in a Web Forms application. I see the problem only when deploying to the Local IIS Web Server (Cassini runs it just fine).
I am able to browse to the data url if force MVC routing to ignore the appropriate route by calling "IgnoreRoute" on the RouteCollection in Global.asax.
I have an app configured to use anonymous authentication, the application pool is set to network service. When I run filemonitor I can see that thw w3wp.exe is picking out the webpages and stuff from my hard drive and returning images etc. However one of the pages saves a file to a folder using c# save() method. Instead of the w3wp.exe actually writing the file to disk explorer.exe seems to be accessing the folder. What the hell is going on? I though the w3wp.exe did everything asp.net related why on earth is explorer.exe being introduced into the fold here?
View 1 RepliesI want to upload .pdf or .doc files on server not in the Database, after then i have to show list of all the uploaded Files on another form and when user clicks on one of the Files, the file should be opened in new Tab...
View 1 RepliesI am working on a journal website where user submit manuscripts , pdf files , is it good idea to store pdf files on directory or on database.
View 1 RepliesI have two tables:
Table1
IDTable1
CustomerName
Table2
IDTable2
IDTable1
FIlePath
There is a one to many relationship with key field = IDTable1
I have created one client and uploaded 20 files
Now I would like to:
Delete the client record from Table1
Delete all associated records in Table2
Delete all files from the disk based on the paths in Table2
I am able to delete all the records in both tables but I cannot delete the disk files. Here is what I ahve so far:
[Code]....
I want to upload a Excel file into database. But File name and File Type is not specific. that means excel file may be created in Office 2003
or Office 2007 or Office 2010. Now I knew that Connection string is diffrent for each format. But how i can recognize the File Format ?
I want to fetch data from all type of Excel files. I am using FileUpload control for uploading Excel.
I am developing audio related project for that i have stored movie names with mp3 file paths in database I am displaying movie names in grid view after clicking on movie name related mp3 file paths will be display in details view i am unable to play that files in details view how to do this ? Here i am storing original mp3 files in one folder in solution explorer and paths in database
View 1 Repliesi'm using stream writer to write a text file on client machine, but everytime while i'm writing a new file it over writes the existing one..so now i need to write seperate file each time ...and also i need to create a folder dynamically for first time and save text files in that folder when everytime i use my application....
View 3 RepliesI have write small web-service that recieves query and read txt file for matching. For it I'm using StreamReader.
I'm not waiting that it will be thousands of users in hour for this service, but whats worried me - if some users at the same time will be use that service is it ok? Can text file on server side be readed at same time from some users?
What is capacity for using StreamReader or StreamWriter on server?
What is the recommended method of writing and storing class files in VS 2008, I'm using a web application?
View 2 RepliesI am having difficulty using C in the VS IDE. No matter what I write the code always has errors and I am not able to see the end result. I don't understand VS and being that I am supposed to be taking Programming in C as a class, it is hard for me to get my work done because I don't understand VS and I really don't know how to match the two up.
View 3 Repliesi am trying to work up with captcha in my sign up page.Having a google search,i found a .dll which i implemented in my project and it worked fine.Now i want to know that is it a good idea to download the dll files and use it in the project instead of writing the whole code from the scratch?What are the disadvantages of using a dll instead of writing up the entire code form the scratch?
View 6 RepliesWhat I have?I have a ASP.NET page which allows the user to download file a on a button click. User can select the file he wants from a list of available files (RadioButtonList) and clicks on download button to download it. (I should not provide link for each file that can be downloaded - this is the requirement).What I want?I want the user to download multiple files one by one by selecting the required radio button and clicking on the button.What problem am I facing?I can download the file for the first time properly. But, after downloading, if I select some other file and click on the button to download it, click event of the button does not post back and the second file will not be downloaded.I use the follwoing code on the button click event:
protected void btnDownload_Click(object sender, EventArgs e)
{
string viewXml = exporter.Export();
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=views.cov");
Response.AddHeader("Content-Length", viewXml.Length.ToString());
Response.ContentType = "text/plain";
Response.Write(viewXml);
Response.End();
}
I want to write "upload multiple files at a time" functionality during upload files in dot net.I am not allowed to use JQuery.All i want is core dotnet.
View 2 RepliesI'm building an app that allows multiple file upload (trying to use the script from here: [URL] This upload will be a pop up from an html page. My question is how to pass the file name(s) to the parent page? I want to submit those names as hidden inputs from the html page.
View 8 RepliesGiven a set of uploaded files in Request.Files, how do figure out which form field yielded which file?
I have a generic form emailer that various forms post to. This file generates an email of the name/value pairs contained in the form post. I'm trying to add support for uploaded files such that the table of name/value pairs will show the name of the file upload element and the name that the file was saved as.
However, I can't figure out how to link that information together. HttpPostedFile doesn't contain any information about the HTTP request (like which field name was used), and Request.Form doesn't contain any entries for uploaded files.
So while I can easily upload the files, I don't have an easy way to generate an email saying "this uploaded file was for this field, and this uploaded file was for that field".
I want to allow users to download files that have names containing & characters.
We've escaped our way through the problem but cannot seem to get around one last obstacle.
Here in Download.asp.vb we have
Code:
[code]....
I have to large files in a database which users can download. The user clicks a link and the following code runs:
[Code]....
I'm working on a project in ASP.Net, and it requires reading/writing to files on my server. I'm hosted at GoDaddy, and they swear they've got me at Medium Trust. When I try to read or write files that are in my own domain, I get Security Exceptions. I've tried multiple ways of opening/saving the files and they all return security errors. Here's the most recent error and offending line of code (I didn't save them all, they're all pretty much the same thing):
Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.MediaPermission, WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' failed.
PngBitmapEncoder pbe = new PngBitmapEncoder();
pbe.Frames.Add(BitmapFrame.Create(new Uri("ornament.png", UriKind.Relative))); <-- Error
I've also gotten the error when trying to read/write using FileStream, Bitmap.Save and new Bitmap("ornament.png"). Could there be a problem with my Web.config? Is read/write supposed to be blocked by medium trust? This is a time-sensitive project and this is a brick wall for me. The deadline is end of business day tomorrow and GoDaddy isn't responding.
I'd like give unique name for uploaded files in a folder.
I know we can a uniqueidentifier to file name but I think it isn't a good way.