首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

不知道错在哪啦,请帮忙见见

2013-12-29 
不知道错在哪啦,请帮忙看看如下代码:using Systemusing System.Data.OleDbnamespace ConsoleApplication

不知道错在哪啦,请帮忙看看
如下代码:
using System;
using System.Data.OleDb;
namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            OleDbConnection myConn =
                new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\\MyExcel.csv;Extended Properties='text;HDR=YES;FMT=TabDelimited'");
            Console.WriteLine(myConn);
            myConn.Open();   
        }
    }
}
MyExcel.csv的位置截图
不知道错在哪啦,请帮忙见见
MyExcel.csv的内容截图
不知道错在哪啦,请帮忙见见
运行出错截图
不知道错在哪啦,请帮忙见见
未处理System.Data.OleDb.OleDbException
  _HResult=-2147467259
  _message='c:\MyExcel.csv'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。
  HResult=-2147467259
  IsTransient=false
  Message='c:\MyExcel.csv'不是一个有效的路径。 确定路径名称拼写是否正确,以及是否连接到文件存放的服务器。
  Source=Microsoft JET Database Engine
  ErrorCode=-2147467259
  StackTrace:
       在 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       在 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       在 System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       在 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       在 System.Data.OleDb.OleDbConnection.Open()
       在 ConsoleApplication2.Program.Main(String[] args) 位置 c:\Users\Administrator\Documents\Visual Studio 2013\Projects\ConsoleApplication2\ConsoleApplication2\Program.cs:行号 12
       在 System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
       在 System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       在 Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       在 System.Threading.ThreadHelper.ThreadStart()
  InnerException: 


[解决办法]
Data Source用文件夹,select from再用文件名:
Data Source =c:\\;

热点排行