目录的操作和Excel文件的链接与打开

string strPath = Server.MapPath(".") + "//Data//";

        string fileName=FileUpload1.FileName;
        if(string.IsNullOrEmpty(fileName))
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.Ticks.ToString(), "<Script>alert('没有您要上传的文件，请先选择您要上传的文件')</Script>");
            return;
        }
        if(!object.Equals(System.IO.Path.GetExtension(strPath+fileName),".xls")&&!object.Equals(System.IO.Path.GetExtension(strPath+fileName),".XLS"))
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), DateTime.Now.Ticks.ToString(), "<Script>alert('您选择的文件格式不对，请选择Excel文件')</Script>");
            return;
        }

       
        //目录存在就直接上传
        if (System.IO.Directory.Exists(strPath))
        {
            FileUpload1.SaveAs(strPath + fileName);
        }
        //目录不存在就先创建目录再上传
        else
        {
            System.IO.Directory.CreateDirectory(strPath);
            FileUpload1.SaveAs(strPath + fileName);
        }

 

      
        string strConn;
        strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strPath + fileName + ";Extended Properties=Excel 8.0;";

        OleDbConnection conn = new OleDbConnection(strConn);
        conn.Open();
        DataTable m_tableName = new DataTable();
        DataSet tableSet = new DataSet();
        //得到工作簿的名称
        m_tableName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

        if (m_tableName.Rows.Count > 0)
        {
            m_tableName.TableName = m_tableName.Rows[0]["TABLE_NAME"].ToString();
        }

        string strCommand = string.Empty;
       
        //查询出特定工作簿的数据
        strCommand = "SELECT * FROM[" + m_tableName + "]";
        OleDbDataAdapter myCommand = new OleDbDataAdapter(strCommand, strConn);
        myCommand.Fill(tableSet, m_tableName.TableName);
        conn.Close();