c# - 在 Visual Studio Development 中上传文件时有效，但在网站发布时无效

Question

我有一个页面，用户可以在其中上传 csv 文件，然后将其保存在数据库中并显示在 gridview 中。这在开发网站时一切正常，但是当我将网站发布到 IIS 并从外部访问它时，它会在尝试上传文件时出现“500 内部服务器错误”的错误

这是我用来上传文件的代码：

private string GetConnectionString()
{
    return ConfigurationManager.ConnectionStrings["OfficeConnection"].ConnectionString;
}

private void CreateDatabaseTable(DataTable dt, string tableName)
{
    string sqlQuery = string.Empty;
    string sqlDBType = string.Empty;
    string dataType = string.Empty;

    StringBuilder sb = new StringBuilder();
    sb.AppendFormat(string.Format("CREATE TABLE {0} (", tableName));

    for (int i = 0; i < dt.Columns.Count; i++)
    {
        int maxLength = 0;
        dataType = dt.Columns[i].DataType.ToString();
        if (dataType == "System.Int32")
        {
            sqlDBType = "INT";
        }
        else if (dataType == "System.String")
        {
            sqlDBType = "NVARCHAR";
            maxLength = dt.Columns[i].MaxLength;
        }
        else
        {
            //do something else
        }

        if (maxLength > 0)
            sb.AppendFormat(string.Format("{0} {1} ({2}), ", dt.Columns[i].ColumnName, sqlDBType, maxLength));
        else
            sb.AppendFormat(string.Format("{0} {1},", dt.Columns[i].ColumnName, sqlDBType));
    }

    sqlQuery = sb.ToString();
    sqlQuery = sqlQuery.Trim().TrimEnd(',');
    sqlQuery = sqlQuery + " )";

    using (SqlConnection sqlConn = new SqlConnection(GetConnectionString()))
    {
        sqlConn.Open();
        using (SqlCommand sqlCmd = new SqlCommand(sqlQuery, sqlConn))
        {
            sqlCmd.ExecuteNonQuery();
            sqlConn.Close();
        }
    }
}

private void LoadDataToDatabase(string tableName, string fileFullPath, string delimeter)
{
    string sqlQuery = string.Empty;
    StringBuilder sb = new StringBuilder();
    sb.AppendFormat(string.Format("BULK INSERT {0} ", tableName));
    sb.AppendFormat(string.Format(" FROM '{0}'", fileFullPath));
    sb.AppendFormat(string.Format(" WITH ( FIELDTERMINATOR = '{0}' , ROWTERMINATOR = '\n' )", delimeter));
    sqlQuery = sb.ToString();

    using (SqlConnection sqlConn = new SqlConnection(GetConnectionString()))
    {
        sqlConn.Open();
        using (SqlCommand sqlCmd = new SqlCommand(sqlQuery, sqlConn))
        {
            sqlCmd.ExecuteNonQuery();
            sqlConn.Close();
        }
    }
}

private void UploadAndProcessFile()
{
    if (FileUpload1.HasFile)
    {
        FileInfo fileInfo = new FileInfo(FileUpload1.PostedFile.FileName);
        if (fileInfo.Name.Contains(".csv"))
        {
            string fileName = fileInfo.Name.Replace(".csv", "").ToString();
            string csvFilePath = Server.MapPath("UploadedCSVFiles") + "\\" + fileInfo.Name;

            //Save the CSV file in the Server inside 'UploadedCSVFiles'   
            FileUpload1.SaveAs(csvFilePath);

            //Fetch the location of CSV file   
            string filePath = Server.MapPath("UploadedCSVFiles") + "\\";

            string strSql = string.Format("SELECT * FROM [{0}]", fileInfo.Name);
            string strCSVConnString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='text;HDR=YES;'", filePath);

            // load the data from CSV to DataTable   
            DataTable dtCSV = new DataTable();
            DataTable dtSchema = new DataTable();
            using (OleDbDataAdapter adapter = new OleDbDataAdapter(strSql, strCSVConnString))
            {
                adapter.FillSchema(dtCSV, SchemaType.Mapped);
                adapter.Fill(dtCSV);
            }

            if (dtCSV.Rows.Count > 0)
            {

                CreateDatabaseTable(dtCSV, fileName);
                Label2.Text = string.Format("The table ({0}) has been successfully created to the database.", fileName);
                string fileFullPath = filePath + fileInfo.Name;
                LoadDataToDatabase(fileName, fileFullPath, ",");
                Label1.Text = string.Format("({0}) records has been loaded to the table {1}.", dtCSV.Rows.Count, fileName);
            }
            else
            {
                lblError.Text = "File is empty.";
            }
        }
        else
        {
            lblError.Text = "Unable to recognize file.";
        }
    }
}

protected void btnImport_Click(object sender, EventArgs e)
{
    UploadAndProcessFile();
}

这是我需要更改的 IIS 中的设置吗？我已经检查了网站上的许可，一切都很好。

谢谢

标签： c#iis