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[i][0] + "'," + myDataSet.Tables["ExcelInfo"].Rows[i][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.......
