DataSource Controls :: Excel File Being Locked - Way To Unlocked It
Jun 14, 2010
I have a page where users can upload an excel file and it is read into our system. I am using the Jet.OLEDB.4.0 provider to read the files. I access the file one time to read out the header names and then allow the user to select which field each column will be read into on import. For some reason after this read the file is locked and the next time I try to access it to do the data import I get the "File in use" message. Each time I open a connection it is closed so I am not sure why the file is being locked.
View 2 Replies
Similar Messages:
Aug 12, 2013
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then Dim dataSet1 As New DataSet dataSet1
Dim dataSet2 As New DataSet dataSet2 Dim dataSet3 As New DataSet dataSet3
Dim dataSets As New List(Of DataSet)() dataSets.Add(dataSet1) dataSets.Add(dataSet2) dataSets.Add(dataSet3)
Dim strout As String = Server.MapPath("test1.xls") DataSetsToExcel(dataSets, strout) End If End Sub
[Code]..
How to create each excel sheet non-editable (read only)
View 1 Replies
Jan 27, 2010
i have an asp.net application that connects to a database. I've set up the connection string with the correct server name and username/password. This use to work perfectly. Suddenly for some reason, when i navigate to the site i get a Login failed for user
admin. Account locked. I check the server and the account is not locked, but just to be sure i reset the password and change my conn string accordingly. This makes no difference and i still get the account locked error message.
View 6 Replies
May 19, 2010
this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db.
the problem is the excel file may be updated or changed and i have to periodically import it and perform the process but I still cant check or compare between the two Data Source (excel, sql) as I violate the entity integrity (PK)
i found a kind of stupid approach that each time i want to import the file i will empty the table then re-insert the data, but at this step a new problem raise that other tables are !engaged! with it ... so i will violate the referential integrity (FK)
i looking for solution to compare between two sources for each tuple / row, ignore the existing one and insert the new
[Code]....
View 2 Replies
May 10, 2010
i want create a file excel from sql server? how can i do?
and can i create it using also sqldatasource control?
View 4 Replies
Apr 17, 2010
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]....
View 1 Replies
Jan 10, 2010
I need a way to read all the rows in one column from an Excel file that the user picks from a fileupload control. I tried saving the excel file on the webserver with the upload control and then opening it with a OleDbConnection but that fails when running it from the webserver and gives the error:
Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
This works fine when just running it localhost, so i figured it might be a problem with security level at the webserver which i cant change. Instead i tried doing it with a streamreader direct from the fileupload control and because theres no need for saving the excel file on the server, but im not sure how to query the rows i need this way.
View 1 Replies
Feb 2, 2010
I got data retrieved from Sql DB in a 3 different dataset. I need to get all data from
View 7 Replies
Feb 7, 2010
i have different tables for product details, images, category mapping
is there any way to import/export products by excel file in database along with category mappying and pictures in one go rather that importing just the products and then categorizing each product and adding image one by one ?
View 4 Replies
Jan 1, 2010
How to port the data of a SQL Server table to a excel file?
View 8 Replies
Apr 28, 2010
I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 Replies
May 7, 2015
after i can copy my file to another folder i realised that if this webapplication is used by multiple users at once, then some users are going to get locked out because each one is trying to copy those files.
so how do i tell the user thats trying to use a file to wait untill the file is available.
StreamWriter WriterTotxt = new StreamWriter("date.txt", false);
DateTime LastAccess = File.GetLastWriteTime("path.dbf");
WriterTotxt.Write(LastAccess);
WriterTotxt.Flush();
WriterTotxt.Close();
string ReadTextFile = File.ReadAllText(txtFile);
DateTime test = Convert.ToDateTime(ReadTextFile);
if (File.GetLastWriteTime(LatestUpdatedTime).CompareTo(test) > 0)
{
File.Copy(Path.Combine(sourcefile, fName), Path.Combine(destinationfile, fName), true);
}
View 1 Replies
Jul 22, 2010
I have some pdf files that get attached to emails and are emailed out through a web application. Sometimes this causes the PDF files to get locked and I cannot delete them from the server (even after the email has gone out). I get the message "The process cannot access the file 'D:myfile.pdf' because it is being used by another process".
View 6 Replies
Mar 10, 2010
I'm uploading an excel file and viewing it in a grid. But if I need to upload the file again in a couple of minutes I get an error that the file is being used by another process, so I cannot upload the file again. The file is always the same name.
View 3 Replies
Apr 6, 2014
i 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?
View 1 Replies
Jun 11, 2013
I need to auto fit the dropdown width to auto fit with the cell in excel using c#.net.
I have exported the dropdown to the excel using c#.
when the column width of the cell is increated, the width of the dropdown should be auto fit to the width of the cell.
View 1 Replies
Apr 1, 2010
when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.
my code:
public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
View 2 Replies
Sep 2, 2011
I have a web page in my project that views a selected pdf file. The problem is the file stays locked with the process w3wp.exe which I assume is the adobe file reader or something. How I can release this process after viewing it? Or another way of viewing it without locking the file?
Here is how I am doing it:
Code:
Dim File1 As String = System.Configuration.ConfigurationManager.AppSettings("Report")
Dim R1 As String = Page.Request.QueryString("r")
If R1 <> "" Then
Dim path As String = File1 & R1
[Code]..
View 1 Replies
Sep 1, 2010
i have try to export data to excel using gridview.
I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .
[Code]....
I need to set the exported excel file column format to TEXT but find no solution on this.
View 2 Replies
Jan 12, 2010
I need to remove the password protection from an uploaded excel file. I have been doing this directly with the Excel assemblies (ASP.NET/C#) and then I tried with the ooxmlcrypto, both worked, but the problem is that I can not deploy either of those solution because of the dependencies.
I mean, my sysadmin does not want us installing Excel on the server and, as I have been searching for some alternatives, I can not find one.
My question is: is there a way to put the necessary dlls in the server without installing Excel or the Office suite?
I found this: Office 2007 Primary Interop Assemblies redistributable package but still, it requires a Microsoft Office Product.
View 2 Replies
Jan 29, 2010
everyting working fine but with this below query only numeric value getting from excel and saving into sql database String value not getting from excel?
INSERT INTO dbo.ImportTest
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:ook1.xls;Extended Properties=Excel 8.0')...[Sheet1$]
View 3 Replies
Feb 2, 2010
well I am trying to export sql data that has 80,000 records more than 65,000 rows which excel has.i do I export that much data in one trial without error.is it posible with bcp utility?
I tried DTS but did not work what option shall i use to define range in excel file to export data ?
View 1 Replies
Feb 10, 2010
The following code is a short version of a process to export data from Sql Server to Excel. I am moving 300k of data to excel and am having to divide it up into 65500+ blocks. This is not a problem in classic asp but .net does not seem to like this method. When ExecuteNonQuery() executes the insert statement each time through the loop it really slows down this process. Otherwise in runs in seconds commenting out ExecuteNonQuery(). Also it looks like the excel file does not grow until the very end. I would think it would be inserting every time it did ExecuteNonQuery(). Do I have something wrong here or should I do a completely different method for this?
using (SqlConnection conn = new SqlConnection(sqlConnString)
View 2 Replies
May 30, 2013
I have exported the excel and save it in a folder.
Now i need to save the excel in the pdf format using c#.net
Is there any way to achieve this.
View 1 Replies
Feb 22, 2010
I am trying to get column count of an Excel sheet. I need count of only those columns which are explicity defined by sheet creator. Columns other than explicitly defined take the form F20,F21... which i dont want to include in my counting. I am using
Provider=Microsoft.ACE.OLEDB.12.0 to access data.
View 1 Replies
