.net连接DBF文件

 string table ="f://d//dedg.dbf"

System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection();
            string table = @filepath;
            //设置连接串
            string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
            conn.ConnectionString = connStr;
            conn.Open();

            OdbcCommand cmd = new OdbcCommand();
            cmd.Connection = conn;

            string sql = @"select * from " + table;
            //读取数据
            OdbcDataAdapter da = new OdbcDataAdapter(sql, conn);
            DataTable dt = new DataTable();

            da.Fill(dt);
            conn.Close();

应用此方法可解决，连接DBF长文件名时打不开的现象。在应用之前要去网上下载一个vfpodbc.dll（版本6.1.8630.1）文件复制到window/system32下面覆盖即可，