How Do I Remove Path From This Code To Run It In Server

Question

0.00/5 (No votes)

See more:

C#

protected void btn_Click(object sender, EventArgs e)
    {

        try
        {

            if (FileUpload1.HasFile)
            {
                string path = string.Concat((Server.MapPath("~/temp/" + FileUpload1.FileName)));
                FileUpload1.PostedFile.SaveAs(path);
                OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0 ;");

                OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", OleDbcon);
                OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(cmd);
                OleDbcon.Open();
                DbDataReader dr = cmd.ExecuteReader();


                SqlBulkCopy bulkInsert = new SqlBulkCopy(con_str);
                bulkInsert.DestinationTableName = "table1";
                bulkInsert.WriteToServer(dr);
                OleDbcon.Close();
                Array.ForEach(Directory.GetFiles((Server.MapPath("~/temp/"))), File.Delete);
                Label1.ForeColor = Color.Green;
                Label1.Text = "successfully inserted";

              

            }
            else
            {
                Label1.ForeColor = Color.Red;
                Label1.Text = "Please select the File";

            }

        }
        catch (Exception ex)
        {

            Response.Write(ex.Message);


        }
        finally
        {


        }
    }

Posted 17-Sep-14 19:17pm

10923679

Updated 17-Sep-14 19:21pm

Mycroft Holmes

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 18-Sep-14 1:29am

Not clear. This is just the code dump, not a well-formulated question.
—SA

10923679 18-Sep-14 1:40am

alright...if this is a dump code... you give a better code... to import excel file to database .

Sergey Alexandrovich Kryukov 18-Sep-14 2:18am

Not dump code (maybe), but code dump. Do you see the difference? :-)
—SA

10923679 18-Sep-14 2:28am

yeah i see the difference .. if you know then give how to run in server...
because this code is searching temp in local system.
if i am using this code in local then it is working.
but from server it is not.

Sergey Alexandrovich Kryukov 18-Sep-14 2:51am

My whole point so far was that I don't understand the problem. Your code looks like working for ASP.NET server part.
What's the problem?
—SA

10923679 18-Sep-14 6:35am

point is i want to import excel file in database(sql server) using asp.net
in a LAN .
i have used this code.. it is running properly in a single system where i am having visual studio and sql server and that path("temp")

but when i keep this code in server
and try to upload excel file.
it search for that temp file.

well if you can help me how to import excel file directly to sql server table. please do it for me

Sergey Alexandrovich Kryukov 18-Sep-14 8:51am

Use Open XML SDK to read Excel files...
—SA

kavitha3 18-Sep-14 1:32am

Hi.!
why you need to remove path ...?
can you please elaborate it ....
--KS

10923679 18-Sep-14 1:39am

because when i run it from server.. it search temp file in local system..

i want to import a excel file into database table without giving any temp file..
because it will run in server..

KaushalJB 18-Sep-14 3:41am

The way you want your File Selection you can use InMemory reading of excel file ...and the way you are performing will also not create any issue.

10923679 18-Sep-14 3:48am

okay.. but i am getting an error..
when i run the program from server ..assuming 10.10.178.10/myprogram/program.aspx
then while uploading the excel file.. it is searching temp file in local system.
or shall i change
string path = "\\192.146.168.112\sharedtemp\" + FileUpload1.FileName; // assuming your IP is 192.146.168.112
will it work ??

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ashok rathod · Answer 1 · 2014-09-17T22:23:00

Solution 1

C#

From your question it seems that you are confuse about your input excel file path setting . so what you can do is you can creat a one appsettings in your asp.net web.config file and put the actual folder path in that key and then access in your code.

Example

XML

<appsettings>
<add key="path" value="FOLDERPath" />
</appsettings>

then use

C#

string path = ConfigurationManager.Appsettings["path"] + "\" +  FileUpload1.FileName;

Posted 17-Sep-14 22:23pm

ashok rathod

Updated 17-Sep-14 22:24pm

v2

Comments

10923679 18-Sep-14 6:46am

put the actual folder path in that key ??

what does that mean ??

you mean the server address like 10.10.248.12 ?

can you please mention it clearly...

10923679 18-Sep-14 6:47am

string path = ConfigurationManager.AppSettings["path"] + FileUpload1.FileName;

the above code was showing error.. i use this.. but while running still m getting error.

MukeshSagar · Answer 2 · 2014-09-17T22:34:00

Solution 2

There is no path defined in the above displayed code. The path where the Excel files are saved can be define din the Web.cong file under the <appsettings> tags. That is not accessible at the run time i.e. the path is not known to the end user.

Posted 17-Sep-14 22:34pm

MukeshSagar

Comments

10923679 18-Sep-14 6:49am

can you please give with some example..?

KaushalJB · Answer 3 · 2014-09-17T23:14:00

Solution 3

You probably apply like this :

C#

var Path = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath;

if (!System.IO.Directory.Exists(Path + "\\ExcelFiles"))
{
       System.IO.Directory.CreateDirectory(Path + "\\ExcelFiles");
}

var logFilePath = Path + "\\ExcelFiles";

This will create a folder inside your server deployed path...which will always access from the server where you have placed all dll's. So your server related issue is gone.

Posted 17-Sep-14 23:14pm

KaushalJB

Updated 17-Sep-14 23:15pm

v2

Comments

10923679 18-Sep-14 6:50am

if you have some more details... can please you help me with that

KaushalJB 18-Sep-14 7:29am

Replace FileUpload1.PostedFile.SaveAs(path); with FileUpload1.PostedFile.SaveAs(logFilePath);
using the code which is posted in answer and proceed the same way you are doing in your code...

10923679 18-Sep-14 7:33am

it shows that .. logFilePath doesnt exist.

this is the error (exception error)
\WebSites\myproject\ExcelFiles' is denied.

KaushalJB 19-Sep-14 2:20am

\WebSites\myproject this folders are not available in your server where you have deployed the project. So donot write this \WebSites\myproject instead only use System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath + "\ExcelFiles"

10923679 19-Sep-14 2:28am

try
{

if (FileUpload1.HasFile)
{

var Path = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath;

if (!System.IO.Directory.Exists(Path + "\\ExcelFiles"))
{
System.IO.Directory.CreateDirectory(Path + "\\ExcelFiles");
}

var logFilePath = Path + "\\ExcelFiles";

// string path = string.Concat((Server.MapPath("~/App_Data/" + FileUpload1.FileName)));
FileUpload1.PostedFile.SaveAs(logFilePath);
OleDbConnection OleDbcon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Path + ";Extended Properties=Excel 12.0 ;");

OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", OleDbcon);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(cmd);
OleDbcon.Open();
DbDataReader dr = cmd.ExecuteReader();

SqlBulkCopy bulkInsert = new SqlBulkCopy(con_str);
bulkInsert.DestinationTableName = "table";
bulkInsert.WriteToServer(dr);
OleDbcon.Close();
Array.ForEach(Directory.GetFiles((Server.MapPath("~/App_Data/"))), File.Delete);
Label1.ForeColor = Color.Green;
Label1.Text = "successfully inserted";

please edit this... and there is a line which delete the file..

what should i do there

Array.ForEach(Directory.GetFiles((Server.MapPath("~/App_Data/"))), File.Delete);