c# 读取dbf格式的文件

 

//读取 DBF 文件, 需要安装 VFPOLEDB.msi

下载

 

 

  OleDbConnection objConn = new OleDbConnection();
            OleDbDataAdapter SQLada;
            objConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\Microsoft Visual FoxPro OLE DB Provider\Samples\Northwind;

 Extended Properties='dBASE 5.0'";
            objConn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select * from employeeterritories";//employeeterrITories.dbf 
            SQLada = new OleDbDataAdapter(cmd);