I want to upload csv file and import the data into sql. but I cant do the import thing. The file is uploaded but it cannot be imported into sql. This is my code. Hope that someone can tell me what is the problem.
[Code]....
I have the following code i found online and it works fine as long as the sheet names are simple names it seems..
If i have a excel file with a sheet name of (sheet1) the code works.. but if i have a file with a sheet name like (FileName2011_03_03_15_01_43) it fails and causes the rest of my code not work..
[Code]....
I am uploading an Excel file into DataSet/Gridview but once the file is uploaded, then i want to be able to make changes the data that is uploaded like making changes the data inside the Gridview or deleting the data etc. Here is my code:
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" />
<br />
[Code].....
How to get the full path of the file that is selected using the fileuploader.
View 1 RepliesI would like to use HTML input file type in my aspx page to allow user to browse for a excel file and then read the content of the excel sheet programmatically.If I want to read the excel sheet I need the full path of the file to connect to the excel sheet using asp.net.I do not understand how can I get the full path of the file.I know I can get the filename using postedFile.FileName property.But I need the full path of the file.
View 2 Repliesi am uploading a file through file upload control , file size has greater then 4 MB, I have to give the proper alert msg to the user that file size exceeding the limit.how to do it , because at server side it is crashed on the IIS and not return to the server to check the file size validation.that how it is possible to validate the file size and give the proper alert messege
View 3 RepliesI need to calculate the file size of uploaded file in order to catch System.Web.HttpException: Maximum request length exceeded.
This is my code
[code]....
I changed the file size in web.config.
<system.web>
<httpRuntime maxRequestLength="10240" />
I want to keep the uploaded file name to make it possible to users to download the file under the same name. But how can I implement it? The one option I see is to store each file to folder with unique name (GUID, for example).
View 2 Replieshow to download the uploaded file
I have used this in .aspx page...
I have a web form that uploads files by <asp:FileUpload> control. It uploads files to any folder on the disk (path to uploads can change in web.config, for example "c:UploadedFiles"). After file has been uploaded I need to show a link on the WebPage to download this file.
How it's possible create a link to this file (or what is another solution) on the web page if my website is in completely different place!?
Can anybody gives me the codes to get the date for upload file in asp.net(vb)
View 5 RepliesI need to create a custom web control which will be a part of a class library. This custom web control implements the upload functionality. I have implemented this with a web user control where I have a fixed path to a page in the web project where the upload of files take place and it works just fine.
The created control in this class library is used in the web project. How do I post the uploaded file to a page, say SomeClass.cs, in the class library.
I use FileHelpers to import data from excel sheet to classes and then put it in MSSQL. Can somebody tell me if there is there a way to do model validation data imported from excel files?
View 6 RepliesActually i am trying to storing the uploaded file into database but when i run this codes:
[Code]....
I got this error: " Incorrect syntax near the keyword 'File'.Incorrect syntax near the keyword 'File'. " can anybody tell me why this error came out?I tried toi change my connection string in web config,but it still showing the same error each time i run it in my local.
how to prevent exe file from being uploaded in a website , even if exe file is inside zip file( exe file in a new folder and new folder is then zipped and uploaded)?
View 2 Repliesi'me developing an ASP.NET application and it includes a FileUpload control, an object to show content of a format and a button to do functions. I want that when I upload the file, it will be shown in the object and for this reason i want to know the method to get the URL of the uploaded file.
This is the code:
[Code]....
is there any method on showing the image for the uploaded video files which are in flv format? i saw all the video in youtube got show the image of the video. how to do it?
View 4 RepliesI was trying to copy file to ftp via in my asp.net application... I did it successfully, however; when I open the copied file it is empty, I checked the properties aswell and its showing 0kb.
View 1 Replies[Code]....
Linking to Uploaded File with Spaces
I wanted to customize/Restrict the File Uploader control as follows:
1. To restrict Users to not to upload some type of file like.exe
2. To restrict the user to a specific size limit.
I also wanted to be able to display appropriate messages to the user if the abover restrictions are violated.
Can I use the validations control to achieve the above goals. As I am already using these controls to display appropriate messages to the user in case of wrong/invalid data.
I am using ASP.NET and C#.
I have made a document uploading page, In which use can upload their document. I am saving three fields in the database,
Document Name [NVarchar]
File [Image]
DocumentType [NVarchar]
Now, I am able to add records in the database, successfully. Now I want to show it in the gridview, like DocumentName, DocumentType and a link to download the file.
I have tried by retrieving the records and assigning them to the gridview but I am getting only two columns.
I'd like to get both C# and VB.NET sugestion.
I have an ASP.NET FileUpload control, which allows only image type. I used RegularExpressionValidator like below.
<asp:FileUpload ID="fuPhoto" runat="server" TabIndex="40" />
<asp:RegularExpressionValidator ID="RegularExpressionValidator3"
runat="server" ControlToValidate="fuPhoto" Display="Dynamic"
ErrorMessage="* You can only upload .jpg, .gif or .png image types."
ValidationExpression="^.*.(jpg|JPG|jpeg|JPEG|gif|GIF|png|PNG)$">* You can only upload .jpg, .gif or .png image types.</asp:RegularExpressionValidator>
This method will only verify the file's extension, not its actual type. Once I receive the file, I want to examine its contents to determine what it really is, in this case image only.
How do I examine the file content being uploaded?
I have a page set up that allows users to upload files to the server, and then uses a database entry to attach the file to a project. When the project opens, I load a gridview with the list of files, and create a hyperlink to the file like this:
Code:
Protected Sub gvFiles_RowDataBound(sender As Object, e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvFiles.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
' Dim oLinkButton As LinkButton = e.Row.FindControl("lbDescription")
Dim oSQL As New clsSQL
[Code] .....
When I try to click on the link, and select Open file, I get the following error:
I notice the type is right here, but on the open screen it isn't:
It says Type compressed Zip Folder for some reason. What I am doing incorrectly?
I am writing a simple web page that users can upload an image file. After the file is uploaded, Users can fill up other question in the web page. then users click the submit button to register them and the file is uploaded previously is move to special folder and is saved there. Know i want to delete the uploaded file if the user upload the file but dont click the submit button and close the web page. because i dont need the file uploaded until the user is not registered.I use Session_End event but i dont know why it dont work.
View 2 Repliesi'm developing an application written in C#, and it uses a FileUpload control but i want to add some lines which the user can delete the file that has uploaded to the server. How can i do that?
View 6 Replies