//Set connection string
string strConn = "Driver= {Microsoft Text Driver (*.txt;*.csv)}; DBQ= "+this.fileName;
//Create connection to CSV file
OdbcConnection odbcConnection = new OdbcConnection(strConn);
//Open the connection
odbcConnection.Open();
把一个路径存储在this.fileName中的txt文件写入DataSet中执行到odbcConnection.Open()时抛出异常,
提示“未发现数据源名称并且未指定默认驱动程序”,断点调试发现执行完OdbcConnection odbcConnection = new OdbcConnection(strConn)时,odbcConnection中的Driver仍未空,这是怎么回事呢?
string constr="Driver={Microsoft Text Driver (*.txt; *.csv)}; Dbq=" + ServerPath+";Extensions=asc,csv,tab,txt;";
{
string constr = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\;Extensions=asc,csv,tab,txt;";
OdbcConnection txtcon = new OdbcConnection(constr);
txtcon.Open();
}
{
string constr = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\;Extensions=asc,csv,tab,txt;";
OdbcConnection txtcon = new OdbcConnection(constr);
OdbcDataAdapter da = new OdbcDataAdapter(@"select * from ls1.txt", txtcon);
DataTable dt=new DataTable ();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
// 测试用例
// C:\ls1.txt文件内容
//日期,代码
//2000-02-01,00-00-00
//2000-02-02,00-00-00
//2000-02-03,00-00-00
//2000-02-04,00-00-00
//2000-02-05,00-00-00
上面是.NET Framework Data Provider for ODBC的标准用法
可以结贴了
Odbc数据查询语句中, select * from 不包括路径的文件名。
public void TestConn()
{
string constr = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\;Extensions=asc,csv,tab,txt;";
OdbcConnection txtcon = new OdbcConnection(constr);
txtcon.Open();
//a,b,c,d字段是不可少的
//fileName是文件名
string sql = "insert into fileName (a,b,c,d) values ('1','2','3','d')";
OdbcCommand cmd = txtcon.CreateCommand(); cmd.CommandText = sql;
cmd.CommandType = System.Data.CommandType.Text;
cmd.ExecuteNonQuery();
}