Member Avatar for pranabmohanty

hello everyone.,
i m new to asp.net. i am using fileupload control in my project. i want the complete file path...in IE i am getting the complete file path but not in Mozilla....in mozilla i am getting the file name only i.e. myfile.xls.......but i want the complete file path i.e. c:\abc/xyz/myfile.xls.
i know because of security mozilla dont show the complete file path....but i need a way to show the file path completely........

i am using asp.net and C#....

its urgent.....plz help.........

thanx in advance......

  • 5 Contributors
  • 6 Replies
  • 302 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by arasan123
Member Avatar for pranabmohanty

i have done it using FileUpload.PostedFile.FileName .... but the problem is everything is working fine in IE ....but not in mozilla.......actually i want to get the full path of the selected file...not the file name only..........

actually my intension is to read the file path and then reading an excel file and finally save it in data base.......

here are some of the code in C# what i have used in my proj....

protected void btnUpload_Click1(object sender, EventArgs e)
{



String sFileName = FileUpload1.PostedFile.FileName;
String sFIlePath = FileUpload1.FileName;


// Code to read excel file


string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sFileName + ";Extended Properties=Excel 8.0;";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");


//Data base connection


OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db4iquad/iquad.mdb") + ";");
conn.Open();
for (int i = 0; i < myDataSet.Tables["ExcelInfo"].Rows.Count; i++)
{
OleDbCommand ocAccess = new OleDbCommand("INSERT INTO iqua (name,age) VALUES " +
"('" + myDataSet.Tables["ExcelInfo"].Rows[0] + "'," + myDataSet.Tables["ExcelInfo"].Rows[1] + ")", conn);
ocAccess.ExecuteNonQuery();


}
Response.Write("VALUE STORED");
myCommand.Dispose();
conn.Close();
}

its woking in IE but not in mozilla because of the file path only...plz help.......

Edited by happygeek because: fixed formatting
Member Avatar for pranabmohanty

thanx jacky...i got the solution....u really help me a lot........actually i did everything as per the links given by you....its working........ :)....

Edited by happygeek because: fixed formatting
Member Avatar for NetUser

hi pranabmohanty,

can you tell me how you solved that problem.

Thanks in advance

Member Avatar for rahulrrathi

Hi pranabmohanty

I have struck in the same problem.
Can u tell me how you solved this problem of getting complete file path in Mozilla

Rahul Rathi

Member Avatar for arasan123

how you solved this problem of getting complete file path in Mozilla?

in java scrpit?

regards,
Arasan

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.