I've an application built on asp.net 2.0. There is an option for user to upload excel file. Once the file has been uploaded the data in the file is validated against some business rules. Rows that successfully validates are inserted into database as soon as it is validated.
I use ado.net to connect to excel file. And use data reader to iterate over all the records. Normally the number of records range from 5,000 to 20,000. This process takes good 8 to 10 minutes. I want to optimize this process because to my understanding it takes too long. Currently I am looking at OPENROWSET, OpenDataSource which so far is unsuccessful. Valiation that takes place on every row is very simple. I only checks for maximum length. So validation itself is not an issue.
I have a gridview that allows the user to export this gridview to excel. Here is my codes but I would like my user to be able to select where to download the file
Protected Sub ExportToExcel(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click lblMsg.Visible = True Try Dim objSw As New StreamWriter(txtFileName.Text.Trim + ".xls") 'Dim serverFilePath As String = "D:Excel Files" 'Dim fileStream As New FileStream(serverFilePath, FileMode.Open) 'Dim fileSize As Long = fileStream.Length 'Response.ContentType = "application/octet-stream" 'Response.AddHeader("Content-Disposition", "attachment; filename=""" & txtFileName.Text.Trim & """;") 'Dim fileBuffer As Byte() = New Byte(fileSize - 1) {} 'fileStream.Read(fileBuffer, 0, CInt(fileSize)) 'Response.BinaryWrite(fileBuffer) 'fileStream.Close() 'Response.[End]() Dim objDt As DataTable = DirectCast(Session("Data"), DataTable).Copy() 'Get No Of Column in GridView Dim NoOfColumn As Integer = objDt.Columns.Count...........................
I got a pdf creator on my webapp where my user can create a pdf with different stats. How should I do so they get the option to prewiev or save the file right after the creation of it? the file is saved.
I am trying to upload an excel file and my code reads the data of excel one by one. Unfortunately as we all know that excel doesn't restrict the data type for each cells, so there is a chance and possibility that my code can catch the exceptions.
How can I do this?
Code:
try { // do the statement } catch { // throw the exception, log it and then proceed to the next, don't stop. // then prompt the users of all exceptions encountered. }
I need to process more than 1,000 rows of data from excel. I don't want every time there is an exceptions the uploading process stops and fixed the problem then re-upload the data again. I want to consolidate first all the data with issues or exceptions then deal with it later after the uploading process done.
i need to control Only ExcelFile uploading with RegularExpressionValidator How can i do that? i need to write a regex pattern in ValidationExpression...
i have a large excel file which has 1 lakh row , i want to insert these data in my table i am using entity framework for insert but it takes more than 45 minutes to insert which is too much, i want to speed up the uploading process what should i do. can I use multithreading for it if yes then how i can use? if any other way to do this process.
I have a simple webpage which uses the FileUpload control. I am trying to select a file from the local pc and save it to the web server which is a remote server on the company network. I have a shared folder on the web server with the appropriate permissions. The folder authentication is using a predefined user name and password.
I have tried My.Computer.Network.UploadFile and System.Net.WebRequestMethods.File.UploadFile. For both methods I am getting the following error:
System.IO.FileNotFoundException: Could not find file 'C:empfilename.xls'
We have the data in excel file and want to upload the same into Oracle table.To achieve this we are using following query insert into [ODBC:Driver={Microsoft ODBC for oracle};connectionstring].tablename (select * from sheet$ ) This is working fine for less records but when the record count increases following is the error faced. Error : System Resource Exceeded
We tried the following: 1. We tried to remove connection pooling for oracle. 2. We tried to remove connection pooling for excel. 3. We also verified that only one connection for each (oracle and excel) is open.
Our assumptions: 1. Either the server setting is the issue 2. Jet oledb Driver is the issue.
Hardware involved: SQL Server 2000 Microsoft Server 2003 with IIS6 [code]...
The goal, from internal department (user) perspective:A department wants to "upload" an excel spreadsheet of data (product, term, rate, etc) to SQL (this will be from the internal network). The data is then saved to a webpage location for that department to view and approve. Once "approved," this data is displayed on the live web servers (public-facing website which is two load balancing servers). Bonus:
The .NET application/SQL Server can send an email to the department reminding them to upload the latest rates (each weekday morning, then each Thursday afternoon) if rates have not yet been "approved."
From the development perspective, this is my general idea, but I may be wrong.There are three spreadsheets, each with one tab. The first spreadsheet is uploaded, and the .NET application puts it in a SQL table. I then need to display this table of data on a .aspx page for the department to approve before the .aspx page is pushed to the live web servers.
First, I need an interface for this department to upload Excel files. I need this application to save the data to SQL and display it in a .aspx page so that the department can look it over and approve it. The department needs a way to "approve" the page, and this action will push the data to the live web servers. Will this involve SQL data transformation services?
I need to upload a file (xml, pdf, etc) from the user's PC, but I need to write it directly to a file server. I cannot use FileUpload because there is no way to direct its initial upload to anything but the web server. So, how do I use the HTML INPUT to upload the file from the user's PC directly to a file server located at a different URL than the web server the web page is being hosted on?
I am using the async file upload control to upload to a image file. I want the user to upload only jpg files. And for that I am checking the uploadedfile content type in server side, after the upload complets. I wanna check this, before upload starts. There is one javascript method
function startUpload(sender, args){}
but how to access the content type of the file selected by user.
Question: I have a web interface where a user can upload an XML file, which then gets imported into a SQL database.
Import works fine, interface works fine, logfile works fine. The problem: The user doesn't get any progress report until the entire file has been processed... Is there any way the server can output logfile messages to the user page while processing? I mean AJAX doesn't work for server side calls to the client, only vice-versa, or is there a workaround ?
i use file upload to upload file a folder. but i need to give write permission to IUSR_MACHINENAME user. Can i achieve this with different user Account Credidental?
I made a website for a friend and he uploads a lot of pictures, around 20k per month. And sadly, I made it so he has to upload 1 at a time, because when they are uploaded they are renamed, attached to a group id and watermarked. Is there a way to allow him to select all 20 in a group and have them be uploaded and processed? I've looked into a couple of way to do it, mostly flash, and that will not work since we are renaming and added the newly created name to the db. Adding addition upload controls is not a solution. If we need to make a desktop application that does the uploading, that is alright as well, but we'd like to keep it all in the asp.net environment.
