ADO.NET :: Uploading From .xls File To Microsoft Sql Server?
Oct 21, 2010
trying to upload from an .xls file to microsoft sql server.What i did was i upload the file to a folder in server and pick the record from the folder. This work on development machine but on getting to a iis server to test the application i got an error that was saying the root folder for the www root for the folder was not found.
<pre lang="msil">protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = FileUpload1.PostedFile.FileName;
string saveDir = @"";
string appPath = Request.ApplicationPath;
string savePath = appPath + saveDir + Server.HtmlEncode(FileUpload1.FileName);
String fileExtension = string.Empty;
String path = Server.MapPath("~/Uploads/");
[Code]....
View 1 Replies
Similar Messages:
Feb 18, 2010
For my web application I need to allow the user to upload a word document to the database. I've searched the forums and I've only been able to find with uploading to a server. Can anyone one give me a link to a tutorial or step by step guide on how to do it? I'm not even sure what data type to set the attribute to in the database.
View 4 Replies
Dec 23, 2010
With the ajax file uploader, would it be possible to check the size of the image before uploading?Currently, it uploads the file to the server and then lets me know that it's bigger than the limit size.
View 3 Replies
Jan 11, 2011
i ve deployed many applications with file uploading feature on dedicated server and never got any issue. but it is not working on shared sever :( .. i think Server.MapPath("~") is not working on shared server. as in shared sever i am unable to find those directories which must for uploading.
m using following code for creating directories
string RootLocation = Server.MapPath("~") + "\";
string siteUploads = RootLocation + "uploads" + "\";
Directory.CreateDirectory(siteUploads );
View 6 Replies
Apr 16, 2010
i am working on a project in which I want user to upload files on to my website so for that i created a folder in which i'll store all those stuffs.now the thing is that it is all working fine on localhost but when i use it on server ,,it provides an error which is
Access to the path 'C:inetpubvhostsebas.co.inhttpdocsuploadsfile.exe' is denied.
i think this probably has something to do with the access permission for the folder...So could you tell me what are the permissions required to be set for this job to be done on server.
View 4 Replies
Aug 4, 2010
while uploading the file on the local host it works fine.but the same coding does not work on the webserver. is there anything to do with the foldr read and write permissions.i m using the server.map for finding the path of the browsed file.
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
string fold = "images";
string Name = FileUpload1.FileName;
sring path = Server.MapPath("~" + "/" + fold + "/" + Name);
[code]...
i hv not used any database for storing the path of the image.
View 3 Replies
Sep 15, 2010
Here is an easy one:I need a stable simple file uploader with a progress bar, I have found lots of fancy ones from the search. However, I need the community opinion on which ones to go with? Tutorial links would be appreciated.BOUNTY: I have a FileStream which I would like to upload to a server, below is a sample server server URL:string uploadUri;string SavedFileName = "testXRay.jpg"
uploadUri = @"http://localhost/MyApplication/Upload/Images/" + SavedFileName;I am adding a bounty in hope to get a working solution which I could use from my SL application. MyApplication is hosted in IIS.
View 3 Replies
May 19, 2010
I am trying to upload a file on server using fileupload control in asp.net 3.5.
On local machine code is working fine, but when uploaded on server, it gives
exception as :Exception Access to the path 'D:hostingcontmarch2010abcabc.comwwwattachme ntsabc.jpg' is denied.
I tried to set permission on attachments folder to (777) but when doing this server responds unrecognized chmod.
View 3 Replies
Oct 12, 2010
I am using the fileupload control to upload an excel file to a server, but I am getting a
"Access to the path '\<server>importResponses.xls' is denied" when I try to use fileUploader.SaveAs(filepath). The filepath I use is \<server>importResponses.xls, so I am actually saving it to a share on a different server.My environment consists of a web server and a database server. I am trying to upload the excel file to a share on the database server. A stored procedure then takes that excel file and imports the data from it into a table. So the problem isn't with being unable to save a file to a share on the web server, but it's a problem with being unable to save a file to a share on the database server. It used to work, but now it doesn't and I have no idea why. What process(es) on the database server do I need grant write access for in order for the fileupload control to successfully save the excel file?Right now, I only have the Network Service account with read/write access to the share on the database server. I tried adding other accounts, such as the ASPNET and IUSR_<server name> accounts, but nothing seems to work.The web application that does the actual uploading is configured like this:
<authentication mode="Windows"/>
<identity impersonate="true"/>
Could that have anything to do with it?If you're asking why I'm trying to save an excel file on the database server instead of on the web server, this was the only way I got this to work. If anyone has a better suggestion on how to programatically import excel data into a SQL table, I am all ears.
View 2 Replies
May 6, 2010
I was able to upload 4MB size audio file in my database. The problem occurred when I tried to upload 90MB .mp3 file to MS-SQL Server 2005. only 4MB is allowed by default. I increased the default size in the web config to 195MB,and it's still not working. The following code depicts the size that I currently set in the web config.
<httpRuntime
View 5 Replies
Aug 7, 2010
i am doing an task about uploading & retrive video file in asp.net. first of all tell me How Can we Upload Video files In sql server? then second one is How Can we displays that uploaded video files in my web page?
View 3 Replies
Dec 27, 2010
i use to upload a photo to a server this piece of code:
uplTheFile.PostedFile.SaveAs(Path);
But the Path can't be relative (like ~\Photos\image.jpg) .
I was thinking of getting the location of the .aspx file from where i upload the image and attach \Photos\image.jpg to it, but i don't know how to get the address (location ) of my .aspx page on the server .
View 1 Replies
Dec 12, 2010
when i upload a file i need to insert the data into sql server data (file will be in comma separated with different extension .ord) in vb.net file will be stored on server in a folder
View 3 Replies
Jun 13, 2010
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.
View 3 Replies
Mar 1, 2011
I created my application using asp.net binded to MySQL database and every thing is working fine.
I used connection strings and normal connections defined in the code as mysqlconnection.
I uploaded all pages and database to the webserver, but the data is not accessed.
I have to modify the web.config file but what changes I have to make?
View 2 Replies
Nov 25, 2010
While uploading file on live server i get this error.
System.UnauthorizedAccessException: Access to the path 'xxxwork-max.comTelecomimageslogo.gif' is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
<identity impersonate="true"/> promotes for user name and password each time i select
file uploading.
[URL] - with reference to this post grant permissions to NETWORK SERVICE user will solve the problem but granting permissions will
View 2 Replies
Oct 30, 2010
Hi,
I am trying to developing a project which is getting mssql version, creating tables,views and insert default datas to database.
I have to develeope it working in MSSQL 2005-2008.
Now my project uses using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common;
name spaces from MSSQL dlls.it works fine in serves which has MSSQL2008.Bu d-today i tried it in a server which has MSSQL2005 nad it failed.
Error;
Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
So.Where can i find this namespace and and i need to add this namespace dll to my project.
Else i need another way to do these process working in 2005 nad 2008.
View 4 Replies
Oct 12, 2010
I am using VB to upload image files to my server but am having problems. How can I use the ContentType to filter only image files? This is my code for my upload button which does not seem to be working. I can only upload bmp files:
[Code]....
Also, how can I show the user the image they uploade
View 2 Replies
Oct 25, 2010
I'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded. I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server (using Linq and VB by the way)
View 4 Replies
Apr 25, 2010
[Code]....
i have successfully showed data using puting directpath in to a textbox(e.g, filename=TextBox1.Text;). but the code above is not working. i dont know why.
View 1 Replies
Apr 4, 2011
I a webproject in asp.net my project worked fine in my pc but after uploading it to a iis server it is not working.My webproject is to delete a file,
string s;
int i;
s = Environment.GetEnvironmentVariable("temp"); ;
[code]...
View 1 Replies
Oct 27, 2010
I am facing the problem to acess the Data Base. some time ago i am easily acess the data base by typing the server name(like 127.80.1.7) and type the user id and password from web.config file but now i am find the error.like Login failed for user 'NSAdmin' (Microsoft Sql Server, Error:18456).
View 3 Replies
May 18, 2010
I have a big excel file , and i want to upload it to server.
on upload_click , i have to do a processing which takes very long time,
because i am finding latitude and longitude from the google by reading that excel file.
and i wanted that when used click on CANCEL button the process should stop.
i have created a thread on upload_click and doing all this stuff in that thread .
when user clicks on CANCEL , i am aborting that thread.
but when user again tries to upload file , i am getting the error that file is in use .
to solve this problem i have to stop aspnet_wp.exe from task manager and have to try again .
View 1 Replies
Jun 11, 2013
I have got an error "server response error : Unknown server error" while uploading file using Ajax AsyncFileUpload, code behind function is triggered while uploading, but after code behind function executed, we are getting this error.
View 1 Replies
Jun 10, 2010
i am using a file uploader to upload files. Now when i am using this on a mobile emulator with default browser IE it is uploading only those files whose name is less than 6 character. the files with name more than 6 character is not uploading through mobile emulator or mobile phone (PDA). I need this solution very soon.
View 1 Replies
