在ASP.NET中上载文件

我正在尝试使用ASP.NET和C_导入Excel文件。我在VB中找到了一个示例,但它使用的是一个名为“server.mappath”的东西,它没有解析为名称空间。我在.NET 4.0、C_和Windows XP上。我找到了一个“httpserverputility.mappath”,但我不知道这是否等同于iis7?

C.*

public OleDbCommand ExcelConnection()        
{                        
    string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("~/ExcelImport.xls") + ";" + "Extended Properties=Excel 8.0;";
    //create your excel connection object using the connection string
    OleDbConnection ocnct = new OleDbConnection(conStr);
    ocnct.Open();

    //use a SQL Select command to retrieve the data from the Excel Spreadsheet
    //the "table name" is the name of the worksheet within the spreadsheet
    //in this case, the worksheet name is "Members" and is coded as: [Members$]
    OleDbCommand ocmd = new OleDbCommand("SELECT * FROM [Members$]", ocnct);
    return ocmd;
}

Online 样品

受保护的函数excelConnection()作为oledbcommand

' Connect to the Excel Spreadsheet
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
            "Data Source=" & Server.MapPath("~/ExcelImport.xls") & ";" & _
            "Extended Properties=Excel 8.0;"

' create your excel connection object using the connection string
Dim objXConn As New OleDbConnection(xConnStr)
objXConn.Open()

' use a SQL Select command to retrieve the data from the Excel Spreadsheet
' the "table name" is the name of the worksheet within the spreadsheet
' in this case, the worksheet name is "Members" and is coded as: [Members$]
Dim objCommand As New OleDbCommand("SELECT * FROM [Members$]", objXConn)
Return objCommand

端函数