import excel file

[orked]

i want to import excel file to gridview but there was error(Failed to map this path "/xmltest.xml") and i couldn't handle it my code:

public void fillGrid()
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("../xmltest.xml"));
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            fillGrid();
        }
    }
 
    protected void btImport_Click(object sender, EventArgs e)
    {
        string conn = ("Provider=Microsoft.Jet.OLEDB.4.0;" + ("Data Source=C:\\WebSqlEditor\\Test.xls;" + "Extended Properties=\"Excel 8.0;\"")); 
        string SSQL = "SELECT name , dept, salary  from [sheet1$]";
        OleDbDataAdapter oleDA = new OleDbDataAdapter(SSQL, conn); 
        DataSet ds = new DataSet();
        oleDA.TableMappings.Add("Table","ExcelTest"); 
        oleDA.Fill(ds);
        GridView1.DataSource = ds.Tables[0].DefaultView; 
        GridView1.DataBind();
    }

i need any idea to fix this error,i tried more to fix it but i cann't
thanks

[Plater]

Does the xmltest.xml file exist in the parent directory of wherever you are?
You should try outputing the result of Server.Mappath, to see what its returning (if anything at all)

Also I think that if you try to go to directory higher up then the "root" directory for your webapplication, it will fail

[orked]

i made the source of excel file in c:websqleditor
in this folder i made excel file called(test) as i wrote in code
note if i changed the path the same error appear
i wonder if i need any thing to map path

[Plater]

Well by default your webpage would be in like c:\inetpub\wwwroot\
So running Server.MapPath("../xmltest.xml"); Would produce c:\inetpub\xmltext.xml
Which would be above the "root" of your web application, and thus the server.mappath call would error because you are trying to access a file outside of its dominion

[orked]

at first my application wasn't in the root c:\Inetpub\wwwroot\.....
i put it in this root and i changed the path in my code to be suitable for path but the error still appear