OledbConnection无效参数

Question

我试图读取文件，但在connection.Open()中得到了无效的参数。我错什么了？

using System.Configuration;
using System.Data.OleDb;
using System.Linq;

namespace LeTuanAnh_Training.TestDataAccess
{
    class ExcelDataAccess
    {
        public static string TestDataFileConnection()
        {
            var fileName = ConfigurationManager.AppSettings["TestDataSheetPath"];
            var con = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source = {0}; Extended Properties=Excel 12.0;", fileName);
            return con;
        }

        public static UserData GetTestData(string keyName)
        {
            using (var connection = new OleDbConnection(TestDataFileConnection()))
            {
                connection.Open();
                var query = string.Format("select * from [Sheet1$] where key='{0}'", keyName);
                var value = connection.Query<UserData>(query).FirstOrDefault();
                connection.Close();
                return value;
            }
        }
    }
}

App.config文件

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings configSource="Configurations\Environment.config" />
</configuration>

Environment.config文件

<?xml version="1.0" encoding="utf-8" ?>
    <appSettings>
      <add key="TestDataSheetPath" value="TestDataAccess/Data.xlsx"/>
</appSettings>

误差Pic

Answer 1

当你在做

using (var connection = new OleDbConnection(TestDataFileConnection()))

Using关键字打开连接，并在使用块结束时关闭它。所以您不需要connection.Open()和connection.Close()。

尝试连接到您的DB，并再次检查DB连接数据。你的问题与硒无关..。