.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to upload from .xls file to mssql 2005 from asp.net using c#

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :ASP.Net

Hi Guys

Please can anyone help to solve this i was 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.Please can anyone help to solve it out.Below is the code.Thank you

<pre lang="msil">protected void btnUpload_Click(object sender, EventArgs e)
       string FileName = FileUpload1.PostedFile.FileName;
       string saveDir = @&quot;&quot;;
       string appPath = Request.ApplicationPath;
       string savePath = appPath + saveDir + Server.HtmlEncode(FileUpload1.FileName);
       String fileExtension = string.Empty;
       String path = Server.MapPath(&quot;~/Uploads/&quot;);
       //    try
       //    {

View Complete Post

More Related Resource Links

Log file is growing in secondary server (MSSQL 2005 log shipping)



logshiping is configured in our enviroment between SQL2005 SP3 Enterprise edition , we made the online secondary server for testing perpose. now again we have restored the latest full backup (size was 1000gb) into secondary server for maintaining the logshipping with norecovery mode . everything was fine and both databases is also in sync mode. but i have shrink the log file into promary server and database size reduced to 700Gb then automated backup happened and same backup is restored into secondry srever but secondry server log file size is still showing 350GB.

plz help us how to reduce the log flle of secondry srever, current status is

Primary server DB size is 750gb (50gb log)

secondary srever Db size 1050gb (350gb log)


Upload Multiple File using JQuery in asp.net

In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Upload a File to a SharePoint Document Library - Part I

The following helper class demonstrates a few techniques that allow documents to be uploaded to a SharePoint document library programmatically without using the API or a custom web service. You don't need to specify a document library name, and it will create any folders specified in the URL as required. File meta data will be updated if any properties are passed.

Multi File Upload Using JQuery!

Everyone knows about the file upload in .NET. But the multi file upload is some what difficult in .NET. For that purpose we can have some AJAX or JQuery!. Jquery is the latest advanced version. It will give some animated upload. You can try it for your own!!!!

file upload in chunks or not buffering in memory before writing to disk?


What are the options for handling file uploads to reduce the memory footprint?  Is there a way to upload in chunks?  Is there a way to stream upload directly to disk instead of loading entire file in server memory?


upload file not working



iam using masterpage and ajax update panel, i have child page called  fileupload.aspx,i try to upload the file

but its not working , can i use updatepanel in child page , pls very urgent

looking forward for answer.

file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?



In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.



I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?


<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">

  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />

Asp.Net upload file access denied



I have the problem below, if anyone can help me, appreciate it.

Server Error in '/' Application.

Access to the path 'c:\Inetpub\EnewsAttFiles\employ-e-header2.jpg' is denied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path 'c:\Inetpub\EnewsAttFiles\employ-e-header2.jpg' 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.

To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Hig

Reg File Upload control to upload files from document library


In Field Upload control if we click browse button it allow us to search file in our hard disk but now as per my requirement as soon as user clicks ‘Browse’ button it should point to the document libraries and their files in site.Let me know how could i achieve this?

Thanks & Regards,


Upgrading VS 2003 Project File to VB Express Edition 2005



I downloaded some project from some site which is made in VS 2003. When I open its project file in Notepad I get following at first line Microsoft Visual Studio Solution File, Format Version 8.00. I don't have VS 2003 in my PC but I have VB 2005 and 2008 Express Edition. Now I wanted to upgrade that file but it is not doing. Can somebody help to upgrade it.

FireFox File Upload error


Hi to all ,

this is srinivas,

i have been trying for uploading a file . it works fine in INTERNET EXPLORER  not in FIREFOX.

firefox browser fileupload control takes only file name ,not entire path. so ERROR  is file not found error thrown at run time.

(i dont want answers which suggests me to do SAVEAS file in local disk then upload.)

please post another answers.

  hope u all understand my question .

thanks in advance.

File Upload to an .ashx Script.


Hoping that someone can help me with this. I've been tearing my hair out for days looking for sources and coming up with nothing.

Basically, the scenario is this: I'm working on a project whereby an iPhone will make an HTTP-POST call to an .ashx file on my site. The POST will consist of some fields and a file.

I'm having difficulty - read that as no luck what-so-ever - in finding the form fields or the file when I look at the HTTPContext object in the debug mode of Visual Studio. And if I look at HTTPContext.Request.Files.Count (where I would expect to find a file count) the value is always zero!!

Please help, very confused by this!



why I can not upload file to web by using WebClient.UploadFile method?



I am using WebClient.UploadFile method to upload a file to a web page.

The code is like this:

WebClient client = new WebClient(); 
byte[] responseBinary = client.UploadFile(url, fileName); 
string response = Encoding.UTF8.GetString(responseBinary);

But I can not upload it to server.

I used fiddler to see what happens, and it shows me the following information:

http status code: 302, request headers: POST /testing/upload/default.aspx HTTP/1.1

http status code: 302, request headers: GET /testing/upload/default.aspx?AspxAutoDetectCookieSupport=1 HTTP/1.1

http status code: 200, request headers: GET /(X(1)S(22pynhvxd3eqsb455pudx145))/testing/upload/default.aspx?AspxAutoDetectCookieSupport=1 HTTP/1.1

I would like to know, why I get 302 code, and why it redirect me to the strange url with (X(1)S(22pynhvxd3eqsb455pudx145)) ?

By the way, the web page is ok to upload file by using web explorer.


Can Not load WPF project in Visual Studio 2005 on Win7 64 system, says "Project file not supported b

Dear all I am facing an issue in creating new wpf project or loading a WPF project in Visual studio 2005. I have installed Visual Studio 2005 Service pack - 1 (http://www.microsoft.com/downloads/details.aspx?familyid=bb4a75ab-e2d4-4c96-b39d-37baf6b5b1dc&displaylang=en) but still I can not see the option for wpf project  while creating a new project. Generally we can see WPF listing under item File -->New-->Project--> ".Net Framework 3.0" in VS 2005. I have few WPF project and when i try to load them it says "Project file not supported by this Installation". My System Config is given below: OS: Windows 7 (64 Bit) VS: Visual Studio 2005 with Service Pack 1 .Net Framework: 3.5 (By default inbuilt in Win7 OS)   I am suspecting something bugging related to .Net framework 3.0 in Win7. We have one option in control panel to alter .NetFramework 3.5 under "Turn Windows Features on or Off" but there I can not see something related to 3.0 :-(.   Kindly suggest how can I load my existing project and how can enable option to create new wpf Projects.   I saw few solutions suggested by people on following Thread bt most of them related to Windows XP or Vista: http://social.msdn.microsoft.com/Forums/en/vswpfdesigner/thread/06cf7bca-982c-44cf-aec9-99cf399b3000 Do someone has solution for Windows 7 (64 bit OS)

Acces the file upload path

how can i acces the file upload text. I mean if i choose a file , then the file path comes in file upload e.g. c:/data/fil1.txt.All i want to acces this full path and show in a label.

Insert Excel Data via File Upload into sql server database???

Hi all, I have requirement that User can Upload the Excel Sheet Data to sql server Database at once. How i do that Any Article or hint is apperciated.   Regards 


I have a requirement that a user can upload as many files as he wish. So i am dynamically generating <input type="file"... and embedding them into form tag, Once user clicks submit button. I see that nothing is uploaded to aspx page. The post data looks like this   -----------------------------19718198955447 Content-Disposition: form-data; name=""; filename="" Content-Type: application/octet-stream You can see that the filename is blank and file content is not posted.   I have set the enctype of my form to 'multipart/form-data', but still the problem persists.   Can someone tell me whats the issue here?    suneeelid2000@gmail.co
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend