C#学习教程：使用ODBC在.NET中上传CSV分享

使用ODBC在.NET中上传CSV

嗨，我在.net中有CSV上传代码

在C＃中

string strCOnnString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=D:\csv;ExtensiOns=asc,csv,tab,txt;Persist Security Info=False"; DataSet ds; using (OdbcConnection oCOnn= new OdbcConnection(strConnString)) { using (OdbcCommand oCmd = new OdbcCommand()) { oCmd.COnnection= oConn; oCmd.CommandType = System.Data.CommandType.Text; oCmd.CommandText = "select * from [my.csv]"; OdbcDataAdapter oAdap = new OdbcDataAdapter(); oAdap.SelectCommand = oCmd; ds = new DataSet(); oAdap.Fill(ds, "my"); oAdap.Dispose(); ds.Dispose(); } } 

在.VB

  Dim strConnString As String = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=D:\csv;ExtensiOns=asc,csv,tab,txt;Persist Security Info=False" Dim lOdbcConnection As New OdbcConnection(strConnString) ' lOdbcConnection.COnnectionString= strConnString 'lOdbcConnection.Open() Using lOdbcCommand As New OdbcCommand, lOdbcDataAdapter As New OdbcDataAdapter lOdbcCommand.COnnection= lOdbcConnection lOdbcCommand.CommandType = System.Data.CommandType.Text lOdbcCommand.CommandText = "select * from [my.csv]" lOdbcDataAdapter.SelectCommand = lOdbcCommand Dim ds As New DataSet() lOdbcDataAdapter.Fill(ds, "my") ds.Dispose() lOdbcDataAdapter.Dispose() 

在C＃中工作正常但在.VB中填充数据集时给出错误.-

错误[IM002] [Microsoft] [ODBC驱动程序管理器]未找到数据源名称且未指定默认驱动程序

我做错了什么？