转自:http://www.cnblogs.com/weekzero/archive/2009/10/13/1582793.html
/*
<div>现在开发的很多软件需要和一些老的系统进行数据交互,其中仍然有很多的在用foxpro数据库,对于我们这些一毕业就是.net和SqlServer的环境里,还真有些头疼。</div><div>前些天就遇到一个将dbf数据文件读取到datagridview里,然后再导入到SqlServer数据库里,难点就是如何将dbf文件读取到dataset或datatable里。</div><div>下面是其中的一个方法,就是利用OleDb类来读取,在一些客户的电脑上可能没有读取dbf的组件,这里需要安装一个文件“VFPOLEDBSetup.msi”,这个可以到网上搜索,一堆,也可以到微软官方去下载。代码如下:</div>
*/
string filePath = textBox2.Text; //文件路径,如:E:\a.dbf
FileInfo fi = new FileInfo(filePath);
string mulu = fi.DirectoryName;
string filename = fi.Name;
OleDbConnection conn = new OleDbConnection();
string table = filePath;
string connStr = @"Provider=VFPOLEDB.1;Data Source=" + mulu + ";Collating Sequence=MACHINE";
conn.ConnectionString = connStr;
conn.Open();
string sql = @"select * from " + filename;
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
转自:http://my.oschina.net/Tsybius2014/blog/278426
private void button1_Click ( object sender ,EventArgs e )
{
try
{
System.Data.Odbc.OdbcConnection ocConn = new System.Data.Odbc.OdbcConnection( );
string strTableName = @"DD0712.DBF";
string strConn =
@"Driver={Microsoft dBASE Driver (*.dbf)};SourceType=DBF;" +
@"Data Source=" + strTableName + ";Exclusive=No;NULL=NO;" +
@"Collate=Machine;BACKGROUNDFETCH=NO;DELETE=NO";
ocConn.ConnectionString = strConn;
ocConn.Open( );
string strSql = "SELECT * FROM DD0712.DBF";
OdbcDataAdapter oda = new OdbcDataAdapter( strSql ,ocConn );
DataTable dt = new DataTable( );
oda.Fill( dt );
dataGridView1.DataSource = dt;
ocConn.Close( );
}
catch ( Exception ex )
{
MessageBox.Show( ex.Message );
}
}