Question How to specify the path in File Upload Control?

[Anonymous]

Hello,

I am trying to upload an excel file into SQL server. The thing is I am stuck here

  string fileName = Path.Combine(@"C:\", FileUpload1.FileName);
                    FileUpload1.SaveAs(fileName);

                    String excelConnString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0\"", fileName);

The line

string fileName = Path.Combine(@"C:\", FileUpload1.FileName);

gives pathname as C:\\FileName for which I get an exception that access is denied, and from this Why is access to the path denied?
I got to know that we can get these errors if the path is a directory. I know my path is wrong, but I am clueless as how to select the correct path for further processing.

My asp.net code is

<asp:FileUpload ID="FileUpload1" runat="server" Width="368px" />
        <p>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
        </p>

When I referred this

How To Import Excel Data In SQL Server Using ASP.NET

In this blog, we are going to learn how to import excel data into SQL database table using asp.net and display them into gridview jquery data table.

www.c-sharpcorner.com

and changed my code to

string path = string.Concat(Server.MapPath("~/UploadFile/" + FileUpload1.FileName));
                    FileUpload1.SaveAs(path);

I got Could not find a part of the path exception.

+        $exception    {"Could not find a part of the path 'C:\\Users\\AMEN\\source\\repos\\ExcelDatabase\\ExcelDatabase\\Files\\New Microsoft Excel Worksheet.xlsx'."}    System.IO.DirectoryNotFoundException

 

[mashispano]

Have you trying using Server.MapPath() to convert physical path to virtual, I notice that you're using Webform most of the time IIS does not like windows physical path that is why you must convert to virtual. Good luck

 

[Skydiver]

Look closely, he already is using Server.MapPath(). See the part where he says "and change my code to".